ETL Developer

Ensure Data Solutions is seeking an ETL Developer to design, implement, optimize, and maintain ETL processes for its healthcare data platform. The role focuses on building reliable data feeds and improving data quality and performance to support organizational decision-making.

Responsibilities

Implement and optimize Microsoft SQL-based ETL processes using SSIS packages and Stored Procedures to extract from a variety of sources, including API's, databases, and text files

Responsible for the design of ETL data feeds

Deploy and maintain ETL processes in a development environment

Perform code optimization and performance tuning of existing ETL processes

Generate ad-hoc reports for different users

Re-define ETL process validation, metadata maintenance, data integrity validation process, quality standards, and monitoring standards to ensure data quality

Provide accurate estimates of the effort required to complete assignments

Document technical designs with charts, diagrams, schemes, and descriptive software component documentation

Research and advise on emerging technologies with respect to industry best practices, procedures, and concepts

Manage highly complex projects from start to finish using Agile/SCRUM development methodology and Team Foundation Server (TFS)

Develop and assist Project Managers and Directors with the creation of task-level project plans that detail the specific tasks required to deliver a solution

Develop, test, and implement system changes and upgrades

Preferred

Hands-on experience in ETL development and Agile methodologies

Experience in building ingestion pipelines for healthcare data sources (837/835, 270/271, 277CA, CCD/C-CDA, FHIR, EMR flat files, HL7, ADT feeds, pharmacy claims, labs, etc)

Background in value-based care, population health, or Medicare Advantage analytics

Experience integrating with EHR systems (Epic, Cerner, Athena, eClinicalWorks, NextGen, etc.)

Familiarity with SOC 2, HIPAA, PHI, and HITRUST data governance

ETL Development

Agile Methodologies

Healthcare Data Ingestion

837/835 Claims

270/271 Eligibility

277CA Claims Acknowledgments

CCD/C-CDA

FHIR

EMR Flat Files

HL7

ADT Feeds

Pharmacy Claims

Laboratory Data

Value-Based Care

Population Health

Medicare Advantage Analytics

EHR Integration

Epic

Cerner

Athena

eClinicalWorks

NextGen

SOC 2

HIPAA

PHI

HITRUST

Healthcare Data Governance

Benefits

Health, dental, and vision insurance

Generous PTO and holidays

Company

Healthcare data analytics and value-based care management software

Miami, Florida, USA

https://ensuredatasolutions.com/

Founded in 2019

11-50 employees

Qualifications

Minimum of 3 years relevant experience

Skill in collecting, organizing, and analyzing data

Ability to recognize, analyze, and solve a variety of problems

Ability to exercise sound judgment in making critical decisions

The candidate must have knowledge of the following: Visual Studio, SSIS, Team Foundation

3 years designing, implementing, testing, deploying, and maintaining ETL solutions using Microsoft SQL Server Integration Services (SSIS)

Experience analyzing existing SQL queries and scripts for performance improvements

Understanding of SQL, relational, and analytical databases

Strong analytical skills to understand business needs in terms of business value

Experience identifying, recommending, and implementing ETL process improvements

Excellent interpersonal/communication skills with various levels of the organization

Detail-oriented with the ability to multitask and meet deadlines

Experience with enterprise databases, MS-SQL

This position is not eligible for visa sponsorship

Hands-on experience in ETL development and Agile methodologies

Experience in building ingestion pipelines for healthcare data sources (837/835, 270/271, 277CA, CCD/C-CDA, FHIR, EMR flat files, HL7, ADT feeds, pharmacy claims, labs, etc)

Background in value-based care, population health, or Medicare Advantage analytics

Experience integrating with EHR systems (Epic, Cerner, Athena, eClinicalWorks, NextGen, etc.)

Familiarity with SOC 2, HIPAA, PHI, and HITRUST data governance

Minimum of 3 years relevant experience.

3 years designing, implementing, testing, deploying, and maintaining ETL solutions using Microsoft SQL Server Integration Services (SSIS).

Required skills

Represents the skills you have, click on the tags, ETL Development, Microsoft SQL Server, SQL Performance Tuning, SQL Server Integration Services (SSIS), Team Foundation Server (TFS), Agile/Scrum, Healthcare Data Integration, FHIR, HL7, EHR Integration, HIPAA

Experience

3+ years