Pharmacy BI Lead: Data Pipelines & Dashboards

Dana-Farber Cancer Institute; Boston (MA); On-site; USD 99,000 - 113,000; Full time

Job summary

The Pharmacy Business Intelligence Analyst at Dana-Farber Cancer Institute in Boston leads the full analytics lifecycle, designing data layers and pipelines, developing sources from Epic Clarity, and delivering dashboards and reports with strong data validation.

You will work 2–3 projects, collaborate with stakeholders, perform requirements gathering, write SQL, and create visualizations using BI tools while training analysts and ensuring high-quality, actionable insights across the institute.

Qualifications

• Bachelor’s degree in STEM or related field with 5 years of relevant experience.
• At least 3 years in healthcare and 2 years in pharmacy.
• Tableau and Clarity data model experience; Willow certification within 6 months.

Responsibilities

• Lead multiple projects (2–3) simultaneously with stakeholders.
• Gather requirements and define project scope with business stakeholders.
• Write SQL queries to develop data sources and data pipelines.
• Develop visualizations and dashboards using BI tools; validate data quality.
• Coordinate with QA and End User Acceptance Testing teams.
• Train analysts and share knowledge institute-wide.

Skills

SQL development

Business intelligence

Data modeling

Healthcare experience

Education

Bachelor's degree in STEM or related field

5 years of relevant experience (3 healthcare, 2 pharmacy)

Tools

Tableau

Clarity

Willow certification

Job description

The Pharmacy Business Intelligence Analyst at Dana-Farber Cancer Institute in Boston leads the full analytics lifecycle, designing data layers and pipelines, developing sources from Epic Clarity, and delivering dashboards and reports with strong data validation.

You will work 2–3 projects, collaborate with stakeholders, perform requirements gathering, write SQL, and create visualizations using BI tools while training analysts and ensuring high-quality, actionable insights across the institute.