ETL Developer

Insight Global is seeking an ETL Developer to support the ingestion, transformation, and delivery of healthcare data in a population health environment. The role focuses on building and maintaining data pipelines, ensuring data quality, creating downstream data extracts, and integrating healthcare data systems.

Responsibilities

• Ingest healthcare data from clients and external source systems into the data environment
• Design, build, test, and maintain ETL pipelines to move and transform data
• Review client data dictionaries to understand fields, formats, business rules, and mapping requirements
• Perform data quality checks to identify missing, inaccurate, duplicate, or incorrectly mapped data and resolve ingestion issues
• Create data extracts for downstream teams, analytics, reporting, and client deliverables
• Work with healthcare datasets such as medical claims, pharmacy claims, EHR, eligibility, behavioral health, and population health data
• Develop and maintain API integrations with internal and external systems

Preferred

• Experience supporting Population Health Management programs
• Experience working with behavioral health data
• Experience working with multiple healthcare data sources and integrating them into a centralized data platform
• Dashboard experience (Power BI, Tableau, or Databricks Dashboards)
• Python
• AWS S3
• Population Health Management
• Behavioral Health Data
• Healthcare Data Integration
• Centralized Data Platforms
• Dashboard Development
• Power BI
• Tableau
• Databricks Dashboards

Benefits

• Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching.
• Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.

Company

• Global talent staffing and consulting services
• Atlanta, Georgia, USA
• https://insightglobal.com/
• Founded in 2001
• 1001-5000 employees

Qualifications

• Strong experience with ETL development and data ingestion, including designing, building, and maintaining data pipelines
• Experience creating data extracts and transforming large datasets for downstream reporting, analytics, and client needs
• Strong data quality experience, including validation, reconciliation, troubleshooting, and identifying issues with incoming data
• Experience working with client data dictionaries, mapping documents, and source-to-target specifications to understand and transform incoming datasets
• Hands-on experience working with healthcare data, including claims, pharmacy claims, EHR data, and eligibility data
• Databricks
• SQL / Spark SQL
• PySpark
• ETL Development
• API Integration
• Healthcare Data Experience
• Data Quality & Validation
• Experience supporting Population Health Management programs
• Experience working with behavioral health data
• Experience working with multiple healthcare data sources and integrating them into a centralized data platform
• Dashboard experience (Power BI, Tableau, or Databricks Dashboards)
• Python
• AWS S3

Required skills

• ETL Development, Databricks, SQL, Spark SQL, PySpark, API Integration, Healthcare Data, Data Quality and Validation, Data Mapping, Population Health Management, Python, AWS S3

Preferred skills

• Experience supporting Population Health Management programs, Experience working with behavioral health data, Python, AWS S3

Experience

• Mid level