Data Integration Engineer

6AM City, LLC; United States; On-site; USD 100,000 - 140,000; Full time

Job summary

Caris is seeking a Data Integration Engineer to install backend, automated data integrations to EMRs, data warehouses, and billing systems to ingest healthcare data. You will lead ETL across multiple internal data systems to support internal analytics dashboards and ensure timely, accurate data delivery for business users.

You will assemble large clinical data sets, contribute to BI infrastructure, and establish secure data access using HL7, FHIR, and APIs, while collaborating in an agile

Qualifications

• Bachelor's degree required.
• 3+ years of ETL programming experience.
• 3+ years of experience working with relational databases.
• Experience with HL7.
• Ability to work independently solving application software problems.
• Experience establishing ETL strategies with multiple data sources, incl. EMR systems.
• Ability to assemble and query complex data from databases and perform in-depth analysis.

Responsibilities

• Bridge the gap between business and technology by leading technical requirements gatherings and establishing integration approaches for each project.
• Assemble large data sets of clinical outcomes for ingestion into Caris' systems.
• Contribute to design and development of clinical informatics and BI infrastructure.
• Establish access to EMRs across platforms using direct DB access, FHIR, HL7, APIs or other methods.
• Gather business requirements and work with users in an agile fashion to build dashboard outputs from ETL data.
• Adhere to departmental and corporate standards and assist with related duties.

Skills

ETL programming

Relational databases

HL7

SQL

Epic Beaker

Epic Bridges

Mirth Connect

JavaScript

Data analysis

Education

Bachelor's degree in related field

Tools

HL7 tools

FHIR

Job description

At Caris, we understand that cancer is an ugly word-a word no one wants to hear, but one that connects us all. That's why we're not just transforming cancer care-we're changing lives.

We introduced precision medicine to the world and built an industry around the idea that every patient deserves answers as unique as their DNA. Backed by cutting-edge molecular science and AI, we ask ourselves every day: "What would I do if this patient were my mom?" That question drives everything we do.

But our mission doesn't stop with cancer. We're pushing the frontiers of medicine and leading a revolution in healthcare-driven by innovation, compassion, and purpose.

Join us in our mission to improve the human condition across multiple diseases. If you're passionate about meaningful work and want to be part of something bigger than yourself, Caris is where your impact begins.

Position Summary

The Data Integration Engineer will install back-end, automated data integrations to customer electronic medical records, billing, data warehouses or other applicable customer systems in order to ingest customer healthcare data into applicable Caris' environments. They will also help create, manage, and optimize ETL from multiple internal data systems in order to provide a foundation for internal analytic dashboards. They will lead data discovery and validation projects to ensure accurate data is delivered in a timely manner for business users.

Job Responsibilities

• Bridge the gap between business and technology by leading technical requirements gatherings and establishing integration approaches for each unique project. The applicant will need to be able to clearly communicate technical processes to non-technical business leaders and communicate non-technical business requirements to technical process owners.
• Assemble large data sets of clinical outcomes. The applicant will need to gather large amounts of data and organize it in a way that the data can be ingested into Caris' systems.
• Contribute to architectural design and development of clinical informatics and business intelligence infrastructure. The applicant will need to understand business requirements and create a plan of how to accomplish those requirements using technology.
• Establish access to electronic medical records across multiple platforms using direct database access, Fast Healthcare Interoperability Resources (FHIR), Health Level Seven (HL7), Application Program Interfaces (API) or other standard or non-standards methods.
• Gather business requirements and work with users in an agile fashion to build dashboard outputs based on ETL sourced data.
• Adheres to documented departmental and corporate standards.
• Assists as needed to perform other related duties and special projects as required.
• Accepts other duties as assigned.

Required Qualifications

• Bachelor's degree in related field required.
• 3+ years of experience in extract, transform, and load (ETL) programming.
• 3+ years of experience working with relational databases.
• Experience with Health Level Seven (HL7).
• Ability to work independently solving application software problems.
• Experience with establishing external access and extract, transform, and load (ETL) strategies with multiple types of data sources, particularly a variety of electronic medical record systems.
• Ability to assemble and query complex data from databases, perform in depth analysis and decipher computational data.
• Working experience with relational databases including Microsoft SQL, and/or MySQL
• Proficient in Microsoft Office Suite, specifically Word, Excel, Outlook, and general working knowledge of Internet for business use.

Preferred Qualifications

• Candidates must have a strong background, advanced knowledge and working experience in IT technologies, security architecture and system life-cycle phases are recommended.
• 3+ years of experience of ETL programming in an analytic/dashboard building environment, preferably with healthcare related data.
• Programming and scripting skills with Java Script.
• Certified in Epic Beaker and/or Epic Bridges.
• Familiarity and past work experience deploying ETL solutions using Mirth Connect, CloverETL, and/or other ETL tools.
• Strong leadership, teaming/interpersonal, communication, and customer service skills. These personal skills include honesty, integrity, inspire others, commitment, passion, decision making capabilities, accountability, delegation, empowerment, creativity, and innovation.
• Drive for Results (Service, Quality, and Continuous Improvement) - Ensure procedures and processes are in place that leads to delivery of quality results and continually reassess their effectiveness to achieve continuous improvement.
• Communication - Proficient verbal and written communication skills. Willingness to share and receive information and ideas from all levels of the organization to achieve the desired results.
• Team