Data Engineer

Headlight.Health; Salt Lake City (UT); On-site; USD 80,000 - 110,000; Full time

Benefits offered by this job

Medical, Dental and Vision benefits

Paid Vacation, Sick, and Holiday time

401(k) plan with company contribution

Employee Assistance Program

Professional development opportunities

Job summary

Headlight.Health in Salt Lake City is seeking a Data Engineer to enhance our ETL processes and manage data pipelines. The role emphasizes SQL and Python skills, healthcare data familiarity, and entails responsibilities such as integrating various data sources and ensuring HIPAA compliance.

Join a dedicated team committed to transforming mental healthcare with a focus on innovation and effective patient care.

Qualifications

• 3+ years of data engineering experience in a production environment.
• Strong SQL skills: complex stored procedures, CTEs, window functions.
• Python proficiency for ETL workloads: pandas, REST API consumption.
• Experience building and maintaining scheduled data pipelines.
• Comfort working in a HIPAA-regulated environment.

Responsibilities

• Own and extend the Python-based ETL job orchestration engine.
• Build and maintain data pipelines powering operational reporting.
• Integrate various data sources into the warehouse.
• Optimize high frequency SQL workloads.
• Support and extend custom AI agents.

Skills

Data engineering experience

SQL proficiency

Python for ETL

Healthcare data experience

Communication skills

Tools

Azure Blob Storage

GitHub

HubSpot CRM

Job description

About the Role

Join a team that’s transforming mental healthcare. Founded by psychiatrists, Headlight is more than a company: it’s a movement. A movement that exists on the front lines of the mental health crisis, transforming the way people access care and the way clinicians deliver it. In order to help people in their time of need and ensure that every person who comes to us has options, we are transparent about our capabilities, treatments, and coverage, we champion innovation, and we leverage our rich data to continuously implement better ways of delivering care.

Our mission is simple but powerful: Improving lives, one session at a time.

What We Value

• Make things easier.
• Forge genuine connections.
• Elevate the standard.

Responsibilities

• 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.

Qualifications

• 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 with 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.
• HubSpot CRM data integration experience (Contacts, Deals, Tickets, Company hierarchy, API rate limit handling).
• Healthcare data experience: EHR integrations (NextGen, Epic, or Cerner), credentialing systems, claims data, HIPAA BAA contexts.
• Experience building or maintaining AI/LLM‑powered applications (Claude, OpenAI) in a production context.
• Familiarity with voice or telephony data pipelines, conversational AI systems, or patient intake automation.
• Experience with complex provider or resource scheduling systems and the data modeling they require.
• Exposure to CAC, LTV, or patient funnel analytics in a B2C healthcare or SaaS context.
• Strong communication skills – this team works directly with clinical ops, finance, and marketing stakeholders.

Compensation & Benefits

• 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.

Accommodations & Diversity

If you need any accommodations for your interview please email [e-mail] prior to scheduling.

Headlight is committed to the principles of diversity, equity, and inclusiveness and seeks to create a working environment reflective of this commitment. We seek to provide a diverse clinician base to support the diversity of our clients and thrive to be a welcoming, diverse and discrimination‑ and harassment‑free workplace.

By applying for this position, you consent to receive future communications from Headlight via email or text regarding this application and related employment opportunities. You may opt‑out at any time by contacting us directly.