Senior BI Analyst: Tableau, SQL & dbt | Healthcare

Imagine Pediatrics; United States; Remote; USD 115,000 - 130,000; Full time

Benefits offered by this job

Medical, dental, vision

401(k) with match

HSA

Short/Long-term disability

Life insurance

PTO + holidays

Parental leave

Employee equity program

Job summary

Imagine Pediatrics is a tech-enabled, pediatrician-led medical group reimagining care for children with special health care needs. The Senior BI Analyst will own the full BI lifecycle, building scalable data models and dashboards to drive insights across clinical, operational, and financial functions.

You will design and maintain Tableau dashboards, collaborate with stakeholders to translate workflows into metrics, and ensure data quality from claims, EHR, and HIE sources.

Qualifications

• 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.
• Preferred experience using dbt for data modeling with an engineering-minded approach: building reusable models, standardizing metric definitions, and reducing duplicated logic.
• 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

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 KPIs needed to monitor it
• Navigate ambiguous project requirements with limited information, recommendsolutions 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
• 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

Data storytelling

Stakeholder communication

Analytic thinking

Project ownership

Tools

Tableau

SQL

dbt

Job description

Imagine Pediatrics is a tech-enabled, pediatrician-led medical group reimagining care for children with special health care needs. The Senior BI Analyst will own the full BI lifecycle, building scalable data models and dashboards to drive insights across clinical, operational, and financial functions.

You will design and maintain Tableau dashboards, collaborate with stakeholders to translate workflows into metrics, and ensure data quality from claims, EHR, and HIE sources.