Data Integration Engineer

Caris Life Sciences; United States; On-site; USD 105,000 - 125,000; Full time

Benefits offered by this job

Medical, dental and vision coverage

Health Savings Account (HSA)

Paid time off

401k match

LTD/STD insurance

Employee Assistance Program

Job summary

Caris Life Sciences, Inc. is seeking a Data Integration Engineer to implement back-end ETL pipelines that ingest healthcare data from EMRs and other systems. You will help enable analytics dashboards by preparing validated data and ensuring timely delivery to business users.

The role requires 3+ years in ETL and relational databases, HL7 experience, and strong problem-solving skills. Remote work options are available with a competitive benefits package.

Qualifications

• Bachelor’s degree in a related field required.
• 3+ years of ETL programming experience.
• 3+ years experience with relational databases.
• Experience with HL7.
• Ability to work independently solving application software problems.
• Experience establishing ETL strategies across multiple data sources, including EMR systems.
• Ability to assemble and query complex data and perform in-depth analysis.
• Experience with SQL and/or MySQL.
• Proficient with Microsoft Office Suite.

Responsibilities

• Bridge the gap between business and technology by leading technical requirements and integration approaches.
• Assemble large datasets 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 build dashboard outputs from ETL data in agile fashion.
• Adhere to departmental and corporate standards; perform other duties as assigned.

Skills

ETL programming

Relational databases

HL7

SQL/MySQL

Data analysis

Independent problem solving

Education

Bachelor's degree

Tools

Epic Beaker

Epic Bridges

Mirth Connect

CloverETL

Job description

## Data Integration EngineerApplylocations: Remote - UStime type: Full timeposted on: Posted Yesterdayjob requisition id: JR105333**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.* Teamwork - Commitment to the successful achievement of team and organizational goals through a desire to participate with and help other members of the team.* Customer Service Focus - Demonstrate a focus on listening to and understanding client/customer needs and then delighting the client/customer by exceeding service and quality expectations.**Physical Demands*** Will work at computer most of the time.* Must possess ability to sit and/or stand for long periods of time.* Must possess ability to perform repetitive motion.**Training*** All job specific, safety, and compliance training are assigned based on the job functions associated with this employee.**Other*** Willingness to work overtime.* Weekend/evening/holiday work may be required depending on business need.**Annual Hiring Range**$105,000 - $125,000Actual compensation offer to candidate may vary from posted hiring range based upon geographic location, work experience, education, and/or skill level. The pay ratio between base pay and target incentive (if applicable) will be finalized at offer. **Description of Benefits*** Highly competitive and inclusive medical, dental and vision coverage options* Health Savings Account for medical expenses and dependent care expenses* Flexible Spending Account to pay for certain out-of-pocket expenses* Paid time off, including: vacation, sick time and holidays* 401k match and Financial Planning tools* LTD and STD insurance coverages, as well as voluntary benefit options* Employee Assistance Program* Pet Insurance* Legal Assistance* Tuition Assistance**Conditions of Employment:** Individual must successfully complete pre-employment process, which includes criminal background check, drug screening, credit check ( applicable for certain positions) and reference verification.This job description reflects management’s assignment of essential functions. Nothing in this job description restricts management’s right to assign or reassign duties and responsibilities to this job at any time.