ETL Developer

Are you interested in leading the transformation of cancer care through software that puts world-leading scientific knowledge in the hands of patients and their doctors?  If so, join our growing team at VieCure, the company that is revolutionizing cancer care by putting A.I. driven technology tools and an unparalleled knowledge base into the hands of physicians.

Job Description

We are seeking an experienced full time, highly motivated ETL Developer. Our role holder will use their experience in data extraction, exploration, manipulation and reporting to implement ETL pipelines and monitor / maintain data pipeline performance.

Location: Denver, CO or Columbus, OH

Responsibilities

  • Identify data storage requirements for customers

  • Write and maintain custom scripts from various database and to facilitate automation process

  • Create test scripts for implementation of EMPI applications and HL7 related transactions

  • Interpret technical documentation requirements for HL7 interfaces and EMR systems • Interpret business rules and requirements for technical systems

  • Interpret business rules and requirements for technical systems

  • Work directly with internal and external customers to isolate and resolve defects or issues

  • Leverage EMR integration methods for Smart on FHIR, Context Aware Linking development

  • Develop expertise around various EMR integration methods including HL7, Private API, Public API, FHIR and XML/Document

  • Diagnose and resolve complex technical issues related to EMR data integration

  • Develop CCD/CCDA/HL7 integration/extraction and data mapping to support various use cases

  • HL7 data mappings and troubleshooting of interfaces during pre and post integration (Production)

  • Build of ata pipelines in mirth for connecting data sources into VieCure.

  • Joining records from systems using identified patient identifiers

  • Provide internal status updates to team lead

  • Write documentation to describe program development, logic, coding, and corrections

Skills, Competencies & Experience

  • Minimum Bachelors Degree in Computer Science, Information Technology, or equivalent

  • 5 or more years proven hands-on experience as a Data Integration Engineer / ETL Developer

  • Experience with HL7 Messaging, CCD, CDA, CCDA

  • Strong knowledge and Experience in ETL best practices including designing and implementing ETLs and data migrations

  • Basic knowledge of EMR data standards, coding, schemes and ontologies

  • Comprehensive understanding of HIPPA standards

  • Experience with Mirth for EMR Data parsing and ingestion

  • Hands on experience with integration tools (Mirth, DTS, SSIS, Data Stage, etc.)

  • Ability to work closely with the other data teams (DBAs, Architects, Analyst, programmers)

  • Extensive experience with EMR, EHR, and other clinical data that are fluent in healthcare IT standards preferred

  • Strong Ability to hit tight deadlines and work under pressure;

  • Strong Analytical skills and attention to detail

  • Strong written and oral communication skills.


We are headquartered in Greenwood Village, Colorado, and have a complement of remote staff who live in proximity to client sites. For this role, we require a candidate based in, or willing to relocate to Denver, CO or Columbus, OH. We support hybrid working (2 days at home / 3 days on site). There may be some occasional travel involved in this role.


The salary range for this role is $100,000-$130,000 per annum. The exact salary offered will be based on the candidate’s location, knowledge, skills and experience.

Apply Now

To apply, please submit your resume to careers@viecure.com