Analyze large-scale PBM datasets including pharmacy claims, eligibility, formulary, utilization, rebate, and pricing data.
Support executive, clinical, and operational decision-making through data-driven recommendations.
Design, develop, and optimize analytics solutions using Google BigQuery, Cloud Storage, and GCP-native tools.
Build and maintain performant SQL queries, views, and datasets for PBM performance, KPIs, and regulatory reporting.
Ensure data quality, integrity, and compliance across cloud-based data pipelines.
Develop and maintain Power App.
Utilize Power Automate to streamline workflows and data refresh processes.
Collaborate on Power Apps solutions to support operational and analytical use cases.
Work closely with operations, finance, clinical teams, compliance, and IT.
Partner with data engineering teams to optimize data ingestion and modeling strategies.
Translate business requirements into technical and analytical solutions.
Present complex analytical findings in clear, actionable formats to non-technical audiences.
Document data definitions, metrics, and business logic to support transparency and audit readiness.

Requirements

5+ years of data analytics experience, with direct PBM or pharmacy healthcare experience.
Solid experience in SQL, especially for large-scale analytical datasets.
Hands-on experience with Google Cloud Platform, particularly BigQuery.
Advanced experience with Power App, Power Automate.
Knowledge of SAS, vbs or Python for advanced analytics.
Experience with cloud data warehousing and analytics at scale.
Solid understanding of PBM concepts such as: Pharmacy claims processing, Formularies and utilization management and Specialty pharmacy and adherence metrics.

Benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLGoogle BigQueryPower AppPower AutomateSASPythondata analyticsdata warehousingdata pipelinesdata modeling

Soft Skills

data-driven decision makingcollaborationcommunicationpresentation skillsdocumentationtransparencyaudit readiness