Business Intelligence Engineer

Job description

**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** Reporting to the Manager, Business Intelligence, the Business Intelligence Engineer is responsible for working cross-functionally with stakeholders across the organization (e.g. clinical, operational, product, finance, and beyond) to drive analyses and insights that lead to more informed decisions and improved business performance. This role owns the full business intelligence lifecycle: understanding a stakeholder’s workflow, defining the metrics that monitor it, and delivering trusted, reusable analytical solutions from prototype through production. This role will be part of a fast-growing, fast-paced technology organization working to create bespoke solutions to support medically complex children on Medicaid, increasing safe days at home. You will:  - Design, build, and maintain Tableau dashboards that are user-friendly, performant, meet production standards, and enable data-driven decision making across the organization - Design dbt models as reusable data products rather than one-off, dashboard-specific logic; check for and reuse existing models, metrics, and semantic definitions before building new ones, and own the consistency of what you introduce - Partner with stakeholders across organization to gather requirements, understand how their workflow operates, and translate that understanding into the metrics and key performance indicators needed to monitor it - Navigate ambiguous project requirements with limited information, recommend solutions and adapt to evolving business priorities and project types - Own the full business intelligence lifecycle end-to-end: prototyping and validating an approach with stakeholders, building the underlying data model and dashboard, QA testing for accuracy and edge cases, and user testing to confirm the solution meets stakeholders' expectations before it ships - Proactively flag metric or logic inconsistencies you encounter across domains, even ones outside your immediate project, rather than working around them - Use SQL and other tools to collect, process, and analyze large datasets from claims, EHR, HIE, and other programmatic and operational sources - Support self-service analytics by building dashboards and semantic layer components that stakeholders can confidently explore and extend on their own, reducing one-off reporting requests - Complete analytic ticket requests and ad-hoc reporting needs, communicating with stakeholders on status and relaying priorities - Partner with Analytics Engineering, Health Care Economics, Data Science on shared models, upstream data quality, and new tools and capabilities that improve consistency and efficiency across the analytics stack - Perform other duties as assigned **What You Bring & How You Qualify** First and foremost, you’re passionate and committed to reimagining pediatric health care and creating a world where every child with complex medical conditions gets the care and support they deserve. You will need: - 3+ years of experience in business intelligence, data analytics, analytics engineering or related disciplines; strong experience in healthcare - 2+ years of experience with Tableau demonstrating advanced use of calculations, parameters, performance tuning and interactivity - Strong SQL skills and the ability to build analytic tools quickly to generate actionable insights from large-scale data in Snowflake or similar cloud data warehouses - Strong dbt for data modeling with an engineering-minded approach: building reusable models, standardizing metric definitions, and reducing duplicated logic rather than treating each dashboard as an isolated deliverable - Systems thinking; you naturally consider how a dashboard, metric, or model fits into the broader analytics ecosystem, and design for downstream dependencies and future reuse rather than solving only the request in front of you - Demonstrated use of modern engineering practices including version control, CI/CD, testing, and code reviews - Comfort owning a project end-to-end, from gathering requirements directly from stakeholders, prototyping and stakeholder validation through build, QA testing, and user testing - Proven ability to communicate findings effectively through data storytelling that connects insights with business goals and impact - Familiarity with semantic layer concepts, self-service analytics enablement, or AI-assisted analytics tooling is a strong plus - Familiarity with healthcare data sources (e.g., claims, EHR, health information exchange) is a strong plus **What We Offer (Benefits + Perks)** The role offers a base salary range of $115,000 - $145,000 in addition to an 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