Senior Data Engineer

Imagine Pediatrics

Senior Data Engineer at Imagine Pediatrics designing and building scalable data models and ELT pipelines. Collaborating across teams to enhance pediatric healthcare with effective data solutions.

Posted 6/25/2026full-timeRemote • 🇺🇸 United StatesSenior💰 $150,000 - $180,000 per yearWebsite

Tech Stack

Tools & technologies

CloudSQL

About the role

Key responsibilities & impact

Design and build scalable, well-tested DBT models.
Develop and maintain scalable ELT pipelines, ensuring observability and reliability across workflows while leveraging multiple languages and frameworks.
Write performance-aware SQL, understand query execution, and identify and resolve bottlenecks in queries and pipelines.
Improve existing patterns in the codebase and establish new ones.
Partner with product managers, engineers, and stakeholders to understand data needs and provide actionable paths forward. Work closely with engineers across teams to resolve dependencies, facilitate alignment on technical decisions, and mentor other engineers.
Document logic, business rules, and methodology to promote transparency and enable teammates to reference and build on your work.

Requirements

What you’ll need

5–7+ years of healthcare data engineering or analytics engineering experience, with expert-level SQL proficiency and strong data modeling fundamentals.
Strong experience with dbt and orchestration tools.
Experience with cloud data warehouses, preferably Snowflake, including performance-aware SQL development and query optimization.
Experience designing scalable data models, including incremental approaches, and implementing comprehensive testing strategies.
Comfort working with the command line and modern engineering practices, including version control, CI/CD, testing, and code review.
Proven ability to troubleshoot complex data issues across ingestion, transformation, and warehouse layers, and to communicate findings and solutions effectively to technical and non-technical audiences.
Proven ability to reason about the downstream analytical impact of pipeline and model design, including data freshness, grain, and transformation behavior.

Benefits

Comp & perks

Competitive medical, dental, and vision insurance
Healthcare and Dependent Care FSA; Company-funded HSA
401(k) with 4% match, vested 100% from day one
Employer-paid short and long-term disability
Life insurance at 1x annual salary
20 days PTO + 10 Company Holidays & 2 Floating Holidays
Paid new parent leave
Additional benefits to be detailed in offer

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

SQLdbtdata modelingELT pipelinesquery optimizationperformance-aware SQLincremental data modelstesting strategiestroubleshootingdata transformation

Soft Skills

communicationmentoringcollaborationproblem-solvingtransparency