Data Integration Engineer

We have a full-time direct hire remote opportunity available for a Data Integration Engineer with our client. As a Data Integration Engineer, you will be responsible for automating data ingestion for our clients’ healthcare platform. The ability to automate the ingestion of member, claims, and HIE data is essential. In this role, you can own the data ingestion processes from end to end.

This role offers a competitive base, benefits, 401(k) with match, PTO, and 9 paid holidays

Our client is a new kind of healthcare company. They serve health plans and provider organizations an integrated system-of-care comprised of clinical and social services backed by a robust technology platform. By engaging individuals with virtual, in-home, in-clinic and in-facility care options, they deliver advanced community-based health services that allow their clients to live healthier, more independent lives.

Essential Duties and Responsibilities:

• Build and maintain efficient data pipelines to and from various applications and databases
• Work closely with product and engineering to develop strategy for data ingestion architecture, tools, and processes
• Design, implement, test, and monitor automated system for ingesting healthcare member, claims and quality data
• Create data feeds leveraging healthcare standards such as HL7v2, C-CDA, and FHIR
• Construct ETL pipelines for data extracts from HIEs, EMRs, payor databases, and other structured and unstructured sources
• Develop and build custom software and integrations for EMR interoperability with hospitals and providers
• Automate read, extract, transform, stage and load data processes using state of the art cloud-based tools
• Develop, construct, test and maintain data management systems using appropriate tools to perform data ingestion, transformation, cleansing and loading
• Integrate up-and-coming data management and software engineering technologies into existing data structures
• Implement processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it
• Perform data analysis required to troubleshoot data related issues and assist in the resolution of data issues
• Filter and cleanse the data to remove errors and ensure consistency and completeness, employ ETL tools and programming skills to write scripts that correct errors through automation
• Ensure data is organized and properly stored in database structures to optimize performance and maintain history
• Work with the project team to define tasks, create work plans, identify issues affecting progress, and recommend solutions
• Communicate variances and potential scope changes in status reports, enumerate project-related expenses and resource constraints and recommend efficiencies
• Performs in accordance with clients’ competencies and professionally expected behaviors

Qualifications/Skills:

• Bachelor's degree in Mathematics, Computer Science, Information Management or similar required
• 5+ years of experience as a data integration engineer or in a similar role
• 5+ years of SQL experience
• 5+ years of programming/scripting experience
• 5+ years of experience designing, building, and maintaining data processing systems in a cloud architecture
• Experience with data integration tools
• Experience with processing healthcare data
• Experience with AWS Suite (preferred)
• Experience with Python and PySpark (preferred)
• Experience with NoSQL databases (preferred)
• Experience with data integration tools (preferred)

Benefits:

• Fully paid employee medical/dental/vision/life/short term disability
• Employer matching 401(k)
• Annual sick/PTO with 9 paid holidays