Pharmacy Sr Business Analyst

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 is a technical analytics role requiring strong proficiency in data engineering, SQL development, and business intelligence tools. This position is responsible for designing, building, and validating a logical data layer, pipelines and analytic datasets, not solely interpreting existing data. The analyst independently develops data sources from systems such as Epic Clarity and other enterprise data platforms, performs rigorous data validation, and delivers high-quality dashboards and reporting solutions. This role owns the full lifecycle of analytics projects—from requirements gathering through technical development and visualization—and requires a candidate who is equally strong in technical execution and stakeholder engagement.

Located in Boston and the surrounding communities, Dana-Farber Cancer Institute is a leader in life changing breakthroughs in cancer research and patient care. We are united in our mission of conquering cancer, HIV/AIDS, and related diseases. We strive to create an inclusive, diverse, and equitable environment where we provide compassionate and comprehensive care to patients of all backgrounds, and design programs to promote public health particularly among high-risk and underserved populations. We conduct groundbreaking research that advances treatment, we educate tomorrow's physician/researchers, and we work with amazing partners, including other Harvard Medical School-affiliated hospitals.

• Responsible for working on multiple (2‑3) projects simultaneously, supporting multiple business stakeholders
• Collaborate with manager to identify high level business need, develop project charter, and consult with the business stakeholder to define scope
• Lead business requirements gathering
• Identify data source(s) and develop technical data design requirements
• Develop viz wireframes and leverage BI tools to craft visualizations and dashboards
• Write SQL queries to develop data sources
• Collaborate with internal teams and stakeholders for Quality Assurance and End User Acceptance Testing
• Contribute to development of analytic assets that can be used institute wide
• Conduct end-user training as necessary
• Share knowledge within ED&A and train analysts on common tasks
• Address stakeholder feedback, concerns and aim to deliver a high‑level of customer service

KNOWLEDGE, SKILLS, AND ABILITIES REQUIRED:

• Communicates in a professional manner with others inside and outside the department (i.e., staff, patients, providers, other institutions)
• Works effectively as a member of a unit team and cross functional teams
• Has working knowledge of and is able to use all technology and software required to perform primary job functions
• Prioritizes and adapts to change; accepts additional responsibilities based on the changing needs of the work setting
• Resolves problems and escalates as appropriate

MINIMUM JOB QUALIFICATIONS:

The position requires a bachelor’s degree in science, technology, engineering, mathematics, or a related field. Candidates must have 5 years of relevant experience, including at least 3 years in healthcare and 2 years in pharmacy. Tableau and Clarity Data model experience are preferred. Tableau and Willow certifications must be obtained within 6 months of hire.

SUPERVISORY RESPONSIBILITIES: None

PATIENT CONTACT: None

At Dana-Farber Cancer Institute, we work every day to create an innovative, caring, and inclusiveenvironment where every patient, family, and staff member feels they belong. As relentless as we are in our mission to reduce the burden of cancer for all, we are committed to having faculty and staff who offer multifaceted experiences. Cancer knows no boundaries and when it comes to hiring the most dedicated and compassionateprofessionals, neither do we.

Dana-Farber Cancer Institute is an equal opportunity employer and affirms the right of every qualified applicant to receive consideration for employment without regard to race, color, religion, sex, gender identity or expression, national origin, sexual orientation, genetic information, disability, age, ancestry, military service, protected veteran status, or other characteristics protected by law.

EEO Poster

.

Pay Transparency Statement

The hiring range is based on market pay structures, with individual salaries determined by factors such as business needs, market conditions, internal equity, and based on the candidate’s relevant experience, skills and qualifications.

For union positions, the pay range is determined by the Collective Bargaining Agreement (CBA).

$98,600.00 - $112,500.00