Data Engineer

Headlight

Data Engineer responsible for building data pipelines and enhancing ETL processes at Headlight Health. Focused on providing real-time data solutions for behavioral healthcare services.

Posted 6/29/2026full-timeRemote • 🇺🇸 United StatesMid-LevelSenior💰 $150,000 - $165,000 per yearWebsite

Tech Stack

Tools & technologies

AzureETLPandasPythonSQL

About the role

Key responsibilities & impact

Own and extend the Python-based ETL job orchestration engine: add new job types, monitor execution, and resolve production failures
Build and maintain data pipelines powering operational reporting for scheduling, finance, credentialing, and clinical operations
Integrate data sources into the warehouse - EHR (NextGen), CRM (HubSpot), HR platforms (ADP, Lever), credentialing (Modio), call center (Five9), and other third-party APIs
Optimize high-frequency SQL workloads
Support and extend custom AI agents
Maintain HIPAA compliance across all data handling: enforce access controls, audit logging, and PHI segregation in pipelines and reporting layers
Write and maintain version-controlled code in the GitHub repository

Requirements

What you’ll need

3+ years of data engineering experience in a production environment
Strong SQL skills: complex stored procedures, CTEs, window functions, temp tables, index optimization, execution plan analysis
Python proficiency for ETL workloads: pandas, pyodbc or SQLAlchemy, REST API consumption, file handling, scheduling
Hands-on experience data warehouse/ETL workloads
Experience building and maintaining scheduled data pipelines with robust error handling, retry logic, and logging
Ability to debug production failures independently, communicate status clearly, and resolve issues quickly under pressure
Comfort working in a HIPAA-regulated environment and handling PHI with appropriate care and controls
Familiarity with Azure Blob Storage or equivalent object storage for ETL staging workflows

Benefits

Comp & perks

W2 role with competitive compensation
Medical, Dental and Vision on the first of the month after employment
Paid Vacation, Sick, and Holiday time
Employee Assistance Program (EAP) provides confidential counseling services, resources, and support to help you navigate personal or professional challenges.
401(k) plan with company contribution
Opportunity to work in a cutting-edge healthcare technology environment
Professional development opportunities and training
Collaborative and supportive work culture
Impactful role contributing to the enhancement of patient care and healthcare processes

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETL Job OrchestrationSQL OptimizationData Warehouse ManagementComplex Stored ProceduresPandasPyodbcSQLAlchemyREST API ConsumptionError HandlingDebugging Production Failures

Soft Skills

Clear CommunicationProblem Solving Under Pressure