Business Intelligence Engineer

Summary

Imagine Pediatrics is a tech-enabled, pediatrician-led medical group reimagining care for children with special health care needs through virtual-first and in-home medical, behavioral, and social care. The Business Intelligence Engineer partners cross-functionally to deliver trusted analytics solutions, build dashboards and data models, and generate insights that improve business performance and support informed decision-making.

Responsibilities

• 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

Skills

• 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

Qualifications

Must Haves

• 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

Nice to Haves

• 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

Benefits

• Annual bonus incentive
• Eligibility to participate in an employee equity purchase program (as applicable)
• 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