Data Integration Engineer

Summary

Caris Life Sciences is transforming cancer care and changing lives through precision medicine. The Data Integration Engineer will be responsible for installing automated data integrations to customer systems and optimizing ETL processes to ensure accurate healthcare data delivery for analytics.

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

Skills

• 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
• 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

Qualifications

Must Haves

• 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

Nice to Haves

• 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

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