Senior Data Engineer

Who We Are 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. What You'll Do 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: 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. What You Bring & How You'll Qualify 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. Required 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. Preferred Proficiency in Python for automation, tooling, or pipeline development. Experience building API-based and event-driven ingestion systems. Experience with AWS services such as Lambda, SQS, SNS, and S3. Experience working with FHIR resources and clinical systems. Experience with high-volume ingestion tools (e.g., Hevo, Fivetran, or similar). What We Offer (Benefits + Perks) The role offers a base salary range of $150,000 - $180,000 in addition to annual bonus incentive, competitive company benefits package and eligibility to participate in an employee equity purchase program (as applicable). When determining compensation, we analyze and carefully consider several factors including job-related knowledge, skills and experience. These considerations may cause your compensation to vary. We provide these additional benefits and 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 What We Live By We’re guided by our five core values: Our Values: Children First. We put the best interests of children above all. We know that the right decision is always the one that creates more safe days at home for the children we serve today and in the future. Earn Trust. We listen first, speak second. We build lasting relationships by creating shared understanding and consistently following through on our commitments. Innovate Today. We believe that small improvements lead to big impact. We stay curious by asking questions and leveraging new ideas to learn and scale. Embrace Humanity. We lead with empathy and authenticity, presuming competence and good intentions. When we stumble, we use the opportunity to grow and understand how we can improve. One Team, Diverse Perspectives. We actively seek a range of viewpoints to achieve better outcomes. Even when we see things differently, we stay aligned on our shared mission and support one another to move forward — together. We Value Diversity, Equity, Inclusion and Belonging We believe that creating a world where every child with complex medical conditions gets the care and support, they deserve requires a diverse team with diverse perspectives. We're proud to be an equal opportunity employer. People seeking employment at Imagine Pediatrics are considered without regard to race, color, religion, sex, gender, gender identity, gender expression, sexual orientation, marital or veteran status, age, national origin, ancestry, citizenship, physical or mental disability, medical condition, genetic information, or characteristics (or those of a family member), pregnancy or other status protected by applicable law.