Senior Integration Analyst

Senior Integration Analyst

Vacancy expired!

Job Description:

About the Company:


Avalon Healthcare Solutions, headquartered in Tampa, Florida, is a clinical services and information technology company using evidence-based medicine to develop and deploy medical policies and protocols in the high-volume, dynamic and complex diagnostic lab environment. The company manages the appropriate use of thousands of existing lab tests and researches new tests to determine efficacy and impact on patient care.


Studies show that 30% of clinical laboratory testing is unnecessary or overused. Inappropriate testing or missing a key screening can lead to complications and expense arising from unwarranted care, or not obtaining proper care when needed, leading to increased health risks and costs. Avalon helps ensure delivery of the right test, at the right time, and in the right setting. We seek to ensure the most effective patient treatment, improve clinical outcomes, and optimize cost and affordability.


Avalon is a portfolio company of Francisco Partners, a global private equity firm that specializes in investments in technology and technology-enabled service companies. Since its launch 15 years ago, FP has raised approximately $10 billion and invested in more than 150 companies.


Avalon is a high growth company where every associate has an opportunity to make a difference. You will be part of a team that shapes a new market and business. You'll enjoy seeing the results of your work as we rapidly implement our plan. Most importantly, you will help Avalon to achieve its mission and improve clinical outcomes and health care affordability for the people we serve.


For more about Avalon, please visit our web site at http://www.avalonhcs.com.

About the Senior Integration Analyst (SSIS) Position:


The Senior Integration Analyst (SSIS) is responsible for developing and maintaining application integrations, onboarding and supporting external trading partners, and providing for monitoring the integrity of the data exchanges. The position will work closely with the implementation and support teams to create integrations using different communication methods and messaging standards including, but not limited to SSIS. This position will also be required to create and maintain documentation as it pertains to each integration. Key areas include integrating with health plans and providers in support file exchanges. Has excellent SQL and data analysis skills. Has extensive system integration experience.

This is a fulltime, W2 position. Preferred location is Tampa, FL.

Senior Integration Analyst (SSIS) - Essential Functions and Responsibilities:

• Analyze business integration requirements, assess implementation alternatives and formulate overall design approaches. Typically involves in-depth analysis and profiling of data to be exchanged.


• Define file layouts for data interchanges.


• Develop, test, implement, and support automated integration solutions for stable services in accordance with company standards and requirements.


• Capture statistics to enable reporting on the integrity of the data exchanges.


• Work closely with internal MFT and Security teams to implement secure exchanges of sensitive data.

Work closely with the data architect team to design the database schema for destination repositories.

• Work closely with the Quality Assurance team to assist efforts to deliver a high-quality product.


• Work closely with the business owner to onboard and support external trading partners.


• Publish integration guides.


• Document integration solutions (e.g. data models, data flows, mapping, transformations) and support procedures.


• Diagnose and resolve integration data issues and process failures.


• Provide on-call support.


• Follow and participate in improving development, implementation, and project management processes.


• And all other duties assigned by the manager and/or supervisor.

Senior Integration Analyst (SSIS)

- Qualifications:

• A minimum of 4 years of experience working at a high capacity with proven results developing SSIS interfaces.


• A minimum of 4 years of SQL experience.


• A minimum of 6 years of Information Technology experience.


• Bachelor's degree in Computer Science, MIS, or closely related field; or 3 years of ETL / enterprise application integration (EAI) experience.

Tech stack to include:

• Strong data analysis skills are required.


• Ability to quickly master new software / applications and adapt to technical change.


• Knowledgeable of healthcare interface standards


• Advanced Microsoft SQL Server Integration Services (SSIS) development experience is required.


• Experience with NextGen Connect (formally Mirth Connect) processing HL7 or FHIR messages is desirable.


• Ability to translate technical requirements into ETL solutions.


• Advanced skills in SQL query writing.


• Skilled at connecting to applications using published API and Web Service interfaces.


• Knowledgeable of relational and dimensional database modeling concepts.


• Advanced System Performance Monitoring / Troubleshooting skills.

Interpersonal skills to include:

• Excellent time management skills, organizing and prioritizing workload, in order to meet deadlines.


• Strong analytical, decision-making and problem resolution abilities.


• Ability to think and work independently to troubleshoot and resolve a wide variety of technical issues with a significant level of complexity.


• Ability to interact effectively with customers and vendors to build and support integration solutions.


• Ability to interact with trading partners and staff to quickly resolve technical problems.


• Self-Motivated, Self-Starter with a strong sense of urgency and personal accountability.


• Confidence and the ability to relate professionally to a wide range of technical and business-oriented audiences, including trading partners (e.g. health plans, providers, business partners).


• Excellent written and verbal communication skills; a good listener.


• Ability to handle work pressure while providing quality work and maintaining a positive attitude.

Senior Integration Analyst (SSIS)

- Qualifications Preferred:

• Healthcare IT experience is highly desirable.


• Cloud infrastructure experience is highly desirable, especially the AWS Amazon Cloud.


• Experience interfacing with NoSQL database technologies is a plus.


• Previous experience in a start-up or early-stage company helpful.


• Working knowledge of EDI standards is desirable.

PI160206421