Senior Data Integration Engineer

ChenMed LLC; United States; On-site; USD 99,000 - 142,000; Full time

Job summary

ChenMed LLC is seeking a Senior Data Integration Engineer to design, implement, and maintain HL7 interfaces and ETL processes. You will ensure data quality across healthcare data exchanges, build dashboards with SQL, SSIS/SSRS, and Power BI, and collaborate with architects and vendors.

The role requires strong data integration skills, healthcare domain knowledge, and the ability to mentor teams while delivering enterprise DW solutions. Located in the United States with up to 10% travel.

Qualifications

• BA/BS degree in Software Engineering, Software Development, Mathematics, Computer Science, or related field.
• 3+ years in data analysis, data modeling, and mapping; healthcare experience is a plus.
• CSM or similar certification is a plus; .NET experience is a plus.

Responsibilities

• Develops and maintains HL7 interfaces and file transfers; designs testing plans with end-users.
• Monitors data exchange between systems and resolves data errors.
• Creates dashboards and reports using SQL, SSIS/SSRS, and Power BI.
• Collaborates with DW architects and vendors to ensure reliable data warehouse solutions.
• Trains and mentors junior staff and supports project execution.

Skills

HL7 interfaces

ETL development

SQL & SSRS/SSIS

Power BI

FHIR & HIPAA

Data quality & governance

API/web services

SaaS data integration

Communication skills

Travel up to 10%

Education

BA/BS in Software Engineering or Computer Science

Tools

Corepoint (preferred) or InterSystems/Mirth Rhapsody

SQL Server / MySQL / SSRS

.NET development

Job description

We’re unique. You should be, too. We’re changing lives every day. For both our patients and our team members. Are you innovative and entrepreneurial minded? Is your work ethic and ambition off the charts? Do you inspire others with your kindness and joy? We’re different than most primary care providers. We’re rapidly expanding and we need great people to join our team.

The Senior Data Integration Engineer is responsible for coding standard and non-standard (Health Level Seven International (HL7) interfaces and file transfers through an interface engine product as well as, updating, modifying and correcting interface code when necessary. The incumbent in this role designs testing plans with end-users to ensure the software performs error free through all phases of testing. He/She leads the monitoring of application data between systems and resolves data errors. The Senior Data Integration Engineer has broad technical knowledge and a strong understanding of the marketplace and healthcare industry. The Senior Data Integration Engineer is responsible for coding standard and non-standard (Health Level Seven International (HL7) interfaces and file transfers through an interface engine product as well as, updating, modifying and correcting interface code when necessary. The incumbent in this role designs testing plans with end-users to ensure the software performs error free through all phases of testing. He/She leads the monitoring of application data between systems and resolves data errors. The Senior Data Integration Engineer has broad technical knowledge and a strong understanding of the marketplace and healthcare industry.

ESSENTIAL JOB DUTIES/RESPONSIBILITIES:

• Contributes to strategic and tactical planning on the data integration field by sharing insights.
• Builds extensive internal and/or external networks to facilitate achievement of objectives.
• Develops data programs that extract, transform, and load (ETL) data from the data warehouse, assures that architecture and development follow data warehouse best practices.
• Owns data and continually improves its quality and integrity; proactively identifies issues at every step and coordinates the implementation of required fixes.
• Creates, monitors, operates and maintains HL7 and other interfaces using a variety of data technologies.
• Collaborates with DW architects, data architects, hardware/software engineers, DBAs, application vendors and managed services to ensure enterprise DW solutions are reliable, scalable, flexible and low maintenance.
• Develops reports, dashboards, and tools using SQL, SSIS/SSRS, and Power BI, as well as other tools.
• Serves as a liaison and acts as a role model sharing data integration best practices with less experienced staff.
• Manages assigned projects and new hire training for less senior positions, in addition to providing support with on-the-job training and escalation.
• Advises on complex situations by using previous experience to identify the most appropriate option.
• May provide recommendations on adaptions or improvements to existing processes.
• Facilitates healthcare data exchange such as ADTs and CCDs integrating with EMR & practice management system via interface engines.
• Consume and process Admit/Discharge/Transfer (ADT) messages from external partners using interfaces engines.
• Consumes and processes CCD information from external partners using interface engines.
• Partners with business stakeholders to understand their needs and assists in the development of dashboards, visualizations and solutions tailored to their needs.
• Participates as a Subject Matter Expert (SME) on different projects for specific products, processes or applications.
• Troubleshoots and documents interoperability issues and their probable causes.
• Identifies root/cause, tests and implements solutions including, but not limited to, updating and reprocessing transactions as appropriate.
• Integrates data to/from SaaS applications with our internal systems and applications.
• Performs other duties as assigned and modified at manager’s discretion.

KNOWLEDGE, SKILLS AND ABILITIES:

• Highly developed business acumen and acuity
• Deep technical know-how and product knowledge related to BI practices
• Knowledge of DIRECT protocol for healthcare
• Knowledge of JSON, XML, HIPAA ANSI X12, FHIR, HL7 standards/formats, and File Transfer Protocols
• Knowledge of ETL, SQL development, queries, database maintenance and data security
• Proven knowledge in web-based systems architecture, service-based architecture, and understanding of Web Service API's for integration purposes
• Working knowledge of Health Information Exchange platforms such as Corepoint (preferred), InterSystems, Mirth Connect, or Rhapsody
• Proficiency with SQL scripting, MySQL and/or Microsoft SQL Reporting Services, Microsoft SQL. Integration Services, and automation.
• Technical skills with MySQL/MSSQL database and scripting, Excel & pivot tables and other relevant technologies (i.e., AWS, XML, HTTP, SOAP, REST) is required
• Strong analytical, prioritizing, problem-solving, project management and planning skills
• Excellent communication skills
• Strong project coordination skills
• Excellent problem solving skills
• Advanced skill in Microsoft Office Suite products including Word, Excel, PowerPoint and Outlook, plus a variety of other word-processing, spreadsheet, database, e-mail and presentation software
• Ability and willingness to travel locally, regionally and nationwide up to 10% of the time
• Spoken and written fluency in English
• This job requires use and exercise of independent judgment

EDUCATION AND EXPERIENCE CRITERIA:

BA/BS degree in Software Engineering, Software Development, Mathematics, Computer Science, Computer Information Systems or a related field required OR additional experience above the minimum may be considered in lieu of the required education on a year-for-year basis A minimum of 3 years work experience in data analysis, data modeling and mapping, file layouts and/or data structures required; in a healthcare environment is a plus Certified ScrumMaster (CSM) or similar technology certification a plus Experience developing with .NET is a plus Experience with identifying, analyzing and implementing integration opportunities

PAY RANGE:

$99,369 - $141,957 Salary The posted pay range represents the base hourly rate or base annual full-time salary for this position. Final compensation will depend on a variety of factors including but not limited to experience, education, geographic location, and other relevant factors. This position may also be eligible for a bonuses or commissions.

EMPLOYEE BENEFITS

We’re ChenMed and we’re transforming healthcare for seniors and changing America’s healthcare for the better. Family-owned and physician-led, our unique approach allows us to improve the health and well-being of the populations we serve. We’re growing rapidly as we seek to rescue more and more seniors from inadequate health care. ChenMed is changing lives for the people we serve and the people we hire. With great compensation, comprehensive benefits, career development and advancement opportunities and so much more, our employees enjoy great work-life balance and opportunities to grow. Join our team who make a difference in people’s lives every single day. https://chenmed.makeityoursource.com/helpful-documents

Who We Are

ChenMed is a family-owned, family-oriented organization committed to bringing superior health care to moderate-to-low-income seniors. Our vision To positively change American healthcare through primary care innovation for the neediest populations. Our mission To provide a convenient, patient-centered environment that fosters enduring relationships between doctors, staff and patients and delivers superior outcomes and a compassionate experience. We will create a healthcare system specifically for our patients' needs through dedicated doctors, a supportive team, and customized technology, and achieve value through scalable innovation, resourcefulness andaccountability. Our patient promise You are the reason we are here. Your coordinated healthcare and well-being is our focus. Like a member of our family, we will take care of you in good times and in times of need.