Senior Business Intelligence Analyst

Imagine Pediatrics is a tech-enabled, pediatrician-led medical group reimagining care for children with special health care needs. The Senior Business Intelligence Analyst will work cross-functionally to drive analyses and insights that lead to informed decisions and improved business performance, owning the full business intelligence lifecycle.

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

Requirements:

• 5+ years of experience in data analytics (3+ healthcare data analytics)
• 3+ 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
• 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
• Preferred experience using 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
• 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