Data Engineer

Job not on LinkedIn

🔥 49 minutes ago

🇺🇸 United States – Remote

💵 $150k - $165k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

🚰 Data Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Headlight

WebsiteLinkedInAll Job Openings

201 - 500 employees

Founded 2020

⚕️ Healthcare Insurance

☁️ SaaS

Healthcare Insurance • Mental Health • SaaS

Headlight is a mental health service provider that offers various therapeutic treatments, including Acceptance and Commitment Therapy (ACT), Cognitive Behavioral Therapy (CBT), and Dialectical Behavior Therapy (DBT). Their team of licensed clinicians provides personalized care tailored to individual needs, with both in-person and virtual sessions available. Headlight is committed to making mental health care accessible and affordable, working in-network with most major insurance providers to serve a diverse clientele seeking a brighter path forward in their mental health journey.

📋 Description

• 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

• 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

• 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