Senior Business Intelligence Analyst

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

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 Senior Business Intelligence Analyst 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 thatmonitorit, 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, andmaintainTableau dashboards that are user-friendly, performant, meet production standards, and enable data-driven decision making across the organization

• Designdbtmodels 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 workflowoperates, and translate that understanding into the metrics and key performance indicators needed tomonitorit

• Navigate ambiguous project requirements with limited information, recommendsolutionsand adapt to evolving business priorities and project types

• Own the full business intelligence lifecycle end-to-end: prototyping andvalidatingan approach with stakeholders, building the underlying data model and dashboard, QA testing for accuracy and edge cases, and user testing to confirm thesolution meetsstakeholders’expectations beforeit ships

• Proactively flag metric or logic inconsistencies youencounteracross 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:

• 5+ years of experience in data analytics (3+healthcare data analytics)

• 3+ years of experience with Tableaudemonstratingadvanced use of calculations, parameters, performancetuningand 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 usingdbtfor 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 - $130,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.

• 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.