← Back to jobsJob ID col-cmvze2zj1055k42b963kwxry4

C2Q Health SolutionsPosted 30+ days ago

PHARMACY DATA AND REPORTING ANALYST

Full-time
Hybrid
3–5 years
$85K – $90K/yr
Posted 30+ days ago

Centerlight Management Services, LLC is hiring a Pharmacy Data and Reporting Analyst to analyze pharmacy claims and clinical program data and deliver recurring and ad hoc reporting. The role supports regulatory compliance, audit readiness, pharmacy quality initiatives, and data-driven clinical and financial decision-making.

Posted
30+ Days Ago
Source
centerlight.wd5.myworkdayjobs.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • Extract, compile, and analyze pharmacy claims data from the Pharmacy Benefit Manager (PBM) and internal data warehouse systems to support departmental reporting and monitoring needs
  • Develop, maintain, and distribute recurring and ad hoc reports, dashboards, and pivot table analyses (e.g., drug spend trends, high-utilizer caseloads, therapeutic class and HICL/GPI-level utilization) using Excel, SQL
  • Prepare monthly and quarterly utilization, cost, and trend reports to support pharmacy leadership, clinical programs (e.g., palliative care, homebound, high-risk/high-impact reviews), and interdepartmental stakeholders
  • Validate data quality and integrity across pharmacy claims platforms, the Enterprise Data Warehouse (EDW), and clinical documentation systems, identifying and resolving discrepancies
  • Support timely and accurate completion of CMS Part D reporting requirements, including enrollment/disenrollment, Medication Therapy Management (MTM), grievances, coverage determinations/redeterminations/reopenings, and Drug Utilization Review (DUR) controls
  • Assist in the administration of the Drug Management Program (DMP) by compiling OMS/MARx data, tracking At-Risk and Potentially At-Risk Participant (ARB/PARB) case management timelines, and preparing required notices and supporting documentation
  • Collect and prepare pharmacy-related data for NYSDOH, OMIG, and CMS inquiries, audits, and submissions, ensuring accuracy, completeness, and compliance with regulatory deadlines
  • Support formulary transition activities and manufacturer discount program workflows, including tracking and reporting on rebate and discount data accuracy
  • Monitor and report on Star Ratings and Part D quality measures (e.g., medication adherence, medication safety) to support performance improvement initiatives
  • Lead the analysis, validation, monitoring, and reporting of Medicare Part D Prescription Drug Event (PDE) data submitted through the CMS Drug Data Processing System (DDPS). Support data quality initiatives, regulatory compliance, encounter data integrity, operational reporting, and stakeholder engagement to ensure accurate processing and submission of Part D pharmacy claims data
  • Assist management with timely and accurate responses to internal and external audit inquiries, including those from government agencies (OMIG, CMS, DOH)
  • Investigate discrepancies or anomalies in pharmacy claims and reporting data, conduct root cause analysis, and recommend process improvements to enhance accuracy and efficiency
  • Maintain clear documentation of data collection methods, reporting processes, and workflows to support audit readiness and knowledge continuity
  • Collaborate with Clinical Pharmacy, Compliance, Quality, and IT teams to identify reporting needs, refine data extracts, and build sustainable reporting solutions
  • Maintain a high level of customer service for internal and external stakeholders, addressing data and reporting inquiries promptly and professionally
  • Other duties as assigned

Qualifications

  • Bachelor's degree required
  • 3-5 years of healthcare experience, managed care setting is required
  • Proficiency in data analytics, i.e. SAS, SQL is required
  • Knowledge of Medicaid and Medicare benefits, enrollment and billing, and provider contracting is required
  • Knowledge of CPTs, ICD 9/ICD 10, HCPC, DRG, Revenue, RBRVS
  • Proficiency in MS Excel, Word, PowerPoint, and experience using a claims processing system or comparable database software
  • Effective oral, written, and interpersonal communication skills are required
  • Able to multitask efficiently, effectively, and timely
  • Strong organizational skills and work ethic
  • Detail-oriented, professional and collaborative, a great team player
  • Must be able to demonstrate good decision-making, reasonableness, cognitive ability, rational processing, and analysis to satisfy essential functions of the job

Preferred

  • Certified Professional Coder a plus
  • Claims adjudication and understanding of claims PPS is strongly preferred
  • Certified Professional Coder (CPC)
  • Claims PPS Knowledge

Required skills

Certified Professional CoderClaims AdjudicationHealthcare Managed CareMedicaid and Medicare BenefitsProvider ContractingSASSQL

Full job description

Centerlight Management Services, LLC is hiring a Pharmacy Data and Reporting Analyst to analyze pharmacy claims and clinical program data and deliver recurring and ad hoc reporting. The role supports regulatory compliance, audit readiness, pharmacy quality initiatives, and data-driven clinical and financial decision-making.

Responsibilities

  • Extract, compile, and analyze pharmacy claims data from the Pharmacy Benefit Manager (PBM) and internal data warehouse systems to support departmental reporting and monitoring needs
  • Develop, maintain, and distribute recurring and ad hoc reports, dashboards, and pivot table analyses (e.g., drug spend trends, high-utilizer caseloads, therapeutic class and HICL/GPI-level utilization) using Excel, SQL
  • Prepare monthly and quarterly utilization, cost, and trend reports to support pharmacy leadership, clinical programs (e.g., palliative care, homebound, high-risk/high-impact reviews), and interdepartmental stakeholders
  • Validate data quality and integrity across pharmacy claims platforms, the Enterprise Data Warehouse (EDW), and clinical documentation systems, identifying and resolving discrepancies
  • Support timely and accurate completion of CMS Part D reporting requirements, including enrollment/disenrollment, Medication Therapy Management (MTM), grievances, coverage determinations/redeterminations/reopenings, and Drug Utilization Review (DUR) controls
  • Assist in the administration of the Drug Management Program (DMP) by compiling OMS/MARx data, tracking At-Risk and Potentially At-Risk Participant (ARB/PARB) case management timelines, and preparing required notices and supporting documentation
  • Collect and prepare pharmacy-related data for NYSDOH, OMIG, and CMS inquiries, audits, and submissions, ensuring accuracy, completeness, and compliance with regulatory deadlines
  • Support formulary transition activities and manufacturer discount program workflows, including tracking and reporting on rebate and discount data accuracy
  • Monitor and report on Star Ratings and Part D quality measures (e.g., medication adherence, medication safety) to support performance improvement initiatives
  • Lead the analysis, validation, monitoring, and reporting of Medicare Part D Prescription Drug Event (PDE) data submitted through the CMS Drug Data Processing System (DDPS). Support data quality initiatives, regulatory compliance, encounter data integrity, operational reporting, and stakeholder engagement to ensure accurate processing and submission of Part D pharmacy claims data
  • Assist management with timely and accurate responses to internal and external audit inquiries, including those from government agencies (OMIG, CMS, DOH)
  • Investigate discrepancies or anomalies in pharmacy claims and reporting data, conduct root cause analysis, and recommend process improvements to enhance accuracy and efficiency
  • Maintain clear documentation of data collection methods, reporting processes, and workflows to support audit readiness and knowledge continuity
  • Collaborate with Clinical Pharmacy, Compliance, Quality, and IT teams to identify reporting needs, refine data extracts, and build sustainable reporting solutions
  • Maintain a high level of customer service for internal and external stakeholders, addressing data and reporting inquiries promptly and professionally
  • Other duties as assigned

Preferred

  • Certified Professional Coder a plus
  • Claims adjudication and understanding of claims PPS is strongly preferred
  • Certified Professional Coder (CPC)
  • Claims Adjudication
  • Claims PPS Knowledge

Benefits

  • Hybrid work arrangement

Company

  • Administrative management services for healthcare providers
  • https://www.c2qhealthsolutions.com/
  • Founded in 2025
  • 201-500 employees

Qualifications

  • Bachelor's degree required
  • 3-5 years of healthcare experience, managed care setting is required
  • Proficiency in data analytics, i.e. SAS, SQL is required
  • Knowledge of Medicaid and Medicare benefits, enrollment and billing, and provider contracting is required
  • Knowledge of CPTs, ICD 9/ICD 10, HCPC, DRG, Revenue, RBRVS
  • Proficiency in MS Excel, Word, PowerPoint, and experience using a claims processing system or comparable database software
  • Effective oral, written, and interpersonal communication skills are required
  • Able to multitask efficiently, effectively, and timely
  • Strong organizational skills and work ethic
  • Detail-oriented, professional and collaborative, a great team player
  • Must be able to demonstrate good decision-making, reasonableness, cognitive ability, rational processing, and analysis to satisfy essential functions of the job
  • Certified Professional Coder a plus
  • Claims adjudication and understanding of claims PPS is strongly preferred
  • 3-5 years of healthcare experience, managed care setting is required.

Required skills

  • CPT, ICD-9/ICD-10, HCPCS, DRG, Revenue, and RBRVS, Certified Professional Coder, Claims Adjudication, Healthcare Managed Care, Medicaid and Medicare Benefits, Provider Contracting, SAS, SQL

Preferred skills

  • Certified Professional Coder a plus

Experience

  • 3-5 years

Job details

Employment type

Full-time

Seniority level

3–5 years

Date posted

Oct 21, 2026

Work mode

Hybrid

Job source

centerlight.wd5.myworkdayjobs.com

Company

C2Q Health Solutions

Information Technology & AI

Administrative management services for healthcare providers

See all 2 jobs from C2Q Health Solutions →

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Analyst jobs in Bronx

NYC Department of Health and Mental Hygiene

6d ago

Data Visualization Analyst Level II

Full-timeHybridBronx, NY$90K/yr

The Bronx County District Attorney’s Office (BXDA) is hiring a Data Visualization Analyst Level II for its Strategic Planning & Analytics Bureau.

Why similarSame roleSQLBronx

Finance

4d ago

Senior Analyst, Investment Risk and Data Science

Full-timeHybridNew York, NY$150K – $175K/yr

Harbor Capital Advisors is seeking a Senior Analyst for its Investment Risk and Data Science team. The role analyzes portfolio performance, positioning, characteristics, and risk; supports due diligence on current and prospective subadvisors; and develops…

Why similarSame roleSQLNew York

Guardian

4d ago

Compliance Lead, Data Analyst

Full-timeHybridNew York, NY$101K – $166K/yr

The Guardian Life Insurance Company of America is hiring a Compliance Data Analyst to turn complex compliance questions into meaningful analytics and actionable insights.

Why similarSame roleSQLNew York

Get new Data Analyst jobs in Bronx by email

Create job alert

PHARMACY DATA AND REPORTING ANALYST

C2Q Health Solutions · $85K – $90K/yr

Apply on company site