Senior Pharmacist Data Analyst

RedSail Technologies, LLC; South Carolina; Hybrid; USD 150,000 - 180,000; Full time

Benefits offered by this job

Paid time off

Medical insurance

Dental insurance

Vision insurance

401(k) with company match

Fitness bonus

Professional development opportunities

Job summary

RedSail Technologies, LLC seeks a Senior Pharmacist Data Analyst to design, measure, and continuously improve clinical programs across its pharmacy network. You will encode clinical logic for eligibility, targeting, interventions, outcomes, and billing into governed data assets and dashboards.

Reporting to the Director, Enterprise Data Solutions, you will mentor analysts, ensure HIPAA compliance, and build Power BI/Sigma dashboards and AI-validated semantic layers for trusted clinical data.

Qualifications

• PharmD required with active license preferred.
• Minimum 3 years in analytics, data science, or analytics engineering, preferably in healthcare.
• Experience in clinical programs and data governance is valued.

Responsibilities

• Define eligibility, targeting, interventions, outcomes, and billing semantics for clinical programs.
• Build and maintain curated datasets, semantic views, and reusable metrics in Snowflake/Sigma.
• Lead evaluation frameworks and produce program performance reports for stakeholders.
• Translate clinical guidelines and pharmacy data into governed business logic for dashboards and AI agents.
• Mentor analysts on SQL, analytics, and data governance practices.

Skills

Advanced SQL

Power BI

Sigma BI

Clinical domain

Mentoring

Analytical skills

Communication

Education

Doctor of Pharmacy (PharmD)

Pharmacist license

Master's in Data Science/Health Informatics

Tools

Snowflake

dbt

Git

Python

Job description

Job Summary

The Senior Pharmacist Data Analyst brings pharmacist clinical expertise to the design, measurement, and continuous improvement of the clinical programs RedSail Technologies deploys across its pharmacy network, and to the analytics engineering that makes clinical program data trustworthy. Reporting to the Director, Enterprise Data Solutions within the RedSail Technologies Advantage Solutions Business Unit, this role owns the clinical logic behind program eligibility, targeting, intervention, outcome, and billing measures and encodes it in governed datasets, semantic layers, dashboards, and AI agents so that every consumer of clinical program data receives the same clinically sound answer.

Key Duties

• Serve as the clinical subject matter expert for RedSail clinical programs, including adherence, medication management, immunization, manufacturer-sponsored, and value-based programs, defining eligibility, targeting criteria, interventions, outcomes, and billing events in clinically sound and measurable terms.
• Design and maintain the analytics engineering assets that power clinical program analytics, including SQL transformations, curated datasets, semantic view definitions, and reusable metric definitions in Snowflake, following the architecture, layering, and naming standards set by the Clinical Data Solutions Architect.
• Lead clinical program foundational insight, designing evaluation frameworks (baselines, cohorts, pre/post comparisons, and control groups), analyzing enrollment, engagement, adherence, clinical, and financial outcomes, and producing recurring program performance reporting.
• Translate clinical guidelines, drug reference data (e.g., Medi-Span, NDC, GPI), and pharmacy transaction semantics (e.g., claims, fills, reversals, days supply, cost basis) into consistent, documented business logic that is applied uniformly across datasets, dashboards, and AI agents.
• Support new program design and campaign configuration with data, including opportunity sizing, targeting analyses, criteria audits, and post-launch monitoring, and recommend adjustments that improve clinical and financial results.
• Partner with the Clinical Data Scientist on predictive and prescriptive models for program targeting and outcomes, providing clinical validation of features, cohorts, assumptions, and results.
• Build and maintain clinical program dashboards and reports in Power BI and Sigma for internal stakeholders, pharmacy clients, and pharmaceutical partners, and contribute semantic descriptions, verified queries, and clinical validation of AI agent responses.
• Establish and operate data quality checks for clinical program data feeds, reconciling program activity and billing against source systems, investigating anomalies, and coordinating fixes with the Architect and data engineering team.
• Communicate findings, insights, and recommendations to clinical, executive, and client audiences through clear reports, presentations, and data storytelling, and support client-facing program reviews and partner reporting.
• Mentor Pharmacist Data Analysts and Clinical Data Solutions Analysts on clinical logic, SQL, and analytics engineering practices, and review their work for clinical accuracy and consistency with governed definitions.
• Ensure all data usage complies with HIPAA, data privacy regulations, and RedSail data governance policies, including appropriate handling of PHI in analyses, reports, and agent workflows, while maintaining high ethical standards.
• Keep current with trends in pharmacy clinical services, value-based care, healthcare analytics, and data science, and bring relevant practices into the team's clinical program work.
• Performs other duties as assigned by RedSail Technologies leadership.

Education/Training

• Doctor of Pharmacy (PharmD) required. An active pharmacist license is preferred.
• At least five (5) years of professional experience, including a minimum of three (3) years in data analytics, analytics engineering, or data science roles, preferably in a pharmacy or healthcare environment.

Required Work Experience/Skills

• Minimum 3 years of experience in the pharmacy, pharmaceutical, or healthcare industries with direct involvement in clinical programs such as adherence, medication therapy management, immunization, manufacturer-sponsored, or value-based programs.
• Advanced SQL skills, including CTEs, window functions, and performance-aware query design on a cloud data platform (Snowflake preferred).
• Experience building curated datasets and transformation logic under version control (Git) with structured review and deployment processes.
• Proficiency with Power BI or Sigma BI, including the ability to build and maintain data models, measures, and clinical program dashboards.
• Demonstrated ability to design outcome measurement for clinical programs, apply appropriate statistical methods, and interpret results for clinical and business audiences.
• Working knowledge of pharmacy claims data, NCPDP transaction standards, and drug reference data.
• Strong analytical and problem-solving skills with an inquisitive mindset and the ability to transform complex healthcare data into concise, actionable datasets.
• Strong written and verbal communication skills, including presenting to executives, pharmacy clients, and pharmaceutical partners.
• Detail-oriented with critical thinking skills and a commitment to data quality and integrity.
• Ability to work independently, lead cross-functional collaboration, and mentor others.

Preferred Work Experience/Skills

• PharmD combined with a Master's degree in Data Science, Analytics, Health Informatics, or a related field, or equivalent data credentials.
• Experience with Sigma (SigmaBI) or another cloud-native BI platform.
• Exposure to Snowflake Cortex (Cortex Analyst, Cortex Agents, semantic views) or comparable AI and agent platforms, including validating natural-language answers against governed data.
• Experience with Python for statistical analysis, cohort construction, or data validation.
• Experience with task-based or dbt-style transformation pipelines and CI/CD for data assets.
• Experience with pharmaceutical manufacturer program reporting, value-based contracts, or payer quality measures (e.g., Star Ratings, PDC adherence measures).
• Board certification or medication therapy management certification.

Discretionary Judgment

• Uses independent judgment and discretion based upon the employee’s experience in the position and knowledge of the products, equipment, and services
• Uses good judgement and possesses ethical work values

Physical Demands, Working Conditions, and General Employment Guidelines

• Moderate or high levels of stress may be experienced in the performance of the job
• Position is performed in a general office environment, home office, or approved remote workspace where physical work includes, but is not limited to, sitting, standing, reaching, kneeling, bending, and lifting to 25 lbs.

Equipment

• Daily use of the Microsoft Teams (phone), computer, printer, and other routine office equipment
• Must maintain reliable internet access

Safety to Self and Others

• Little responsibility for safety of others. Job is performed in an office setting where there are no hazardous materials or equipment

Working Conditions/Hazards

• Position is performed in an open office environment or approved remote work location

Compensation & Total Rewards

• The anticipated base salary range for this position is $150,000 - $180,000 annually. This position is also eligible for an annual target bonus of 4%. Actual compensation will be determined based on factors including relevant experience, skills, qualifications, and geographic location.
• Benefits include paid time off, medical, dental, and vision insurance, a 401(k) with a 5% company match, a fitness bonus, professional development opportunities, and programs that support overall well-being.

Work Location

• Hybrid at a RedSail Office
• Spartanburg, SC
• Irving, TX
• Shreveport, LA
• Oak Brook, IL
• Cranberry Township, PA
• Long Island, NY