Imagine Pediatrics is a tech-enabled pediatric medical group that provides 24/7 virtual and in-home value-based care for children with special health care needs.
<div class="content-intro"><p><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong><span data-contrast="none">Who We Are</span></strong></span></p> <p><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Imagine Pediatrics is a tech enabled, pediatrician led medical group reimagining care for children with special health care needs. We deliver 24/7 virtual first and in home medical, behavioral, and social care, working alongside families, providers, and health plans to break down barriers to quality care. We do not replace existing care teams; we enhance them, providing an extra layer of support with compassion, creativity, and an unwavering commitment to children with medical complexity.</span></p></div><h2><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">What You'll Do</span></h2> <p><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">As a Senior Data Engineer at Imagine Pediatrics, you will design, build, refactor, and maintain the data models and pipelines that power product, clinical analytics, and operational reporting across the organization. This role requires a mix of technical expertise and analytical thinking, applying engineering best practices to transform raw data from a variety of sources into well-defined, consumable datasets and making them accessible in multiple systems. You will:</span></p> <ul> <li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Design and build scalable, well-tested DBT models.</span></li> <li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Develop and maintain scalable ELT pipelines, ensuring observability and reliability across workflows while leveraging multiple languages and frameworks.</span></li> <li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Write performance-aware SQL, understand query execution, and identify and resolve bottlenecks in queries and pipelines.</span></li> <li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Improve existing patterns in the codebase and establish new ones.</span></li> <li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">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.</span></li> <li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Document logic, business rules, and methodology to promote transparency and enable teammates to reference and build on your work.</span></li> </ul> <h2><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">What You Bring & How You'll Qualify</span></h2> <p><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">You are driven by curiosity and committed to reimagining pediatric healthcare and creating a world where every child with complex medical conditions gets the care and support, they deserve. You thrive in a fast-paced startup environment, embrace change as an opportunity for growth, and bring both engineering depth and a collaborative mindset. You are proactive, identify gaps in your own skillset and take action to improve, and aren't afraid to push back on unclear assumptions.</span></p> <h3><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><em>Required</em></span></h3> <ul> <li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">5–7+ years of healthcare data engineering or analytics engineering experience, with expert-level SQL proficiency and strong data modeling fundamentals.</span></li> <li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Strong experience with dbt and orchestration tools.</span></li> <li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Experience with cloud data warehouses, preferably Snowflake, including performance-aware SQL development and query optimization.</span></li> <li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Experience designing scalable data models, including incremental approaches, and implementing comprehensive testing strategies.</span></li> <li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Comfort working with the command line and modern engineering practices, including version control, CI/CD, testing, and code review.</span></li> <li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">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.</span></li> <li style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">Proven ability to reason about the downstream analytical impact of pipeline and model design, including data freshness, grain, and transformation behavior.</span>