Senior Pharmacist Data Analyst

RedSail Technologies, LLC; United States; Hybrid; USD 150,000 - 180,000; Full time

Benefits offered by this job

Paid time off

Medical, dental, vision insurance

401(k) with 5% match

Fitness bonus

Professional development opportunities

Well-being programs

Job summary

RedSail Technologies is seeking a Senior Pharmacist Data Analyst to apply clinical expertise to design and improve clinical programs across the pharmacy network. You will own program eligibility, targeting, interventions, outcomes, and billing measures, encoding them in governed datasets, semantic layers, dashboards, and AI agents for consistent clinical answers.

Reporting to the Director of Enterprise Data Solutions, you will lead analytics engineering, mentor others, ensure HIPAA compliance,

Qualifications

• Minimum 3 years of experience in pharmacy/healthcare with direct involvement in clinical programs.
• Advanced SQL skills with CTEs, window functions, and performance-aware design on Snowflake.
• Experience building curated datasets and transformation logic under version control.

Responsibilities

• Serve as clinical SME for RedSail programs, defining eligibility, targeting, interventions, and outcomes.
• Design and maintain analytics assets: SQL transformations, curated datasets, and semantic views.
• Lead program insight: cohorts, baselines, pre/post comparisons, and performance reporting.
• Translate guidelines and drug data into consistent business logic for datasets and dashboards.
• Support new program design with data, opportunity sizing, targeting analyses, and audits.
• Build and validate clinical program dashboards in Power BI and Sigma BI for stakeholders.

Skills

SQL

Snowflake

Power BI

Sigma BI

Pharmacy data

Communication

Mentoring

Problem solving

Education

PharmD

Active Pharmacist License Preferred

Tools

Power BI

Sigma BI

Snowflake

Job description

• Pay or shift range: $150,000 USD to $180,000 USD The estimated range is the budgeted amount for this position. Final offers are based on various factors, including skill set, experience, location, qualifications and other job-related reasons.

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

Qualifications

Education

Preferred

PhD or better in Health Profession/Clincal or related field.

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.