Senior Data Engineer

1. About Our Client:

This organization operates in the pediatric healthcare sector, focusing on children with special healthcare needs. It addresses challenges in care accessibility by providing 24/7 virtual and in-home medical, behavioral, and social services. The organization collaborates closely with families, providers, and health plans to enhance existing care teams, offering additional support aimed at improving care quality for children with medical complexity.

2. About the Opportunity:

The Senior Data Engineer is responsible for designing, building, and maintaining data models and pipelines that support product development, clinical analytics, and operational reporting. This role transforms raw data from diverse sources into accessible, well-structured datasets, directly influencing data-driven decision-making and operational efficiency across the organization.

3. Responsibilities:

• • Design and build scalable, tested DBT data models.
• • Develop and maintain reliable ELT pipelines using various languages and frameworks.
• • Optimize SQL queries for performance and resolve bottlenecks.
• • Enhance existing code patterns and establish new standards.
• • Collaborate with product managers, engineers, and stakeholders to meet data needs and align technical decisions.
• • Document business logic and methodologies to ensure transparency and team collaboration.

4. Requirements:

• • 5–7+ years in healthcare data or analytics engineering with expert-level SQL skills and solid data modeling knowledge.
• • Proficient in dbt and orchestration tools.
• • Experience with cloud data warehouses, preferably Snowflake, including SQL optimization.
• • Skilled in designing scalable data models and implementing testing strategies.
• • Familiarity with command line tools, version control, CI/CD, testing, and code review.
• • Ability to troubleshoot complex data issues and communicate solutions clearly.
• • Understanding of analytical impacts related to pipeline and model design.

Preferred:

• • Proficiency in Python for automation and pipeline development.
• • Experience with API-based and event-driven ingestion systems.
• • Familiarity with AWS services like Lambda, SQS, SNS, and S3.
• • Experience with FHIR resources and clinical systems.
• • Experience using high-volume ingestion tools (e.g., Hevo, Fivetran).

5. Pay Range and Compensation Package:

• • Base salary range of $150,000 - $180,000 plus annual bonus incentives.
• • Eligibility for an employee equity purchase program as applicable.
• • Compensation varies based on knowledge, skills, and experience.

6. Benefits & Perks:

• • Competitive medical, dental, and vision insurance.
• • Healthcare and Dependent Care FSA; Company-funded HSA.
• • 401(k) plan with 4% match, fully vested from day one.
• • Employer-paid short and long-term disability insurance.
• • Life insurance at one times annual salary.
• • 20 days paid time off plus 10 company holidays and 2 floating holidays.
• • Paid new parent leave.

Equal Opportunity Statement: Our client is an equal opportunity employer. They celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, or national origin.

Note:

RemoteHunter is not the Employer of Record (EOR) for this role. Our purpose in this opportunity is to connect exceptional candidates with leading employers. We help job seekers worldwide discover roles that match their goals and guide them to complete their full application directly through the hiring company’s career page or ATS.