Strategic Pharmacy Data & Reporting Analyst

CenterLight Health System; New York (NY); On-site; USD 85,000 - 95,000; Full time

Job summary

CenterLight Health System is seeking a Pharmacy Data and Reporting Analyst to collect, analyze, and report on pharmacy claims and clinical program data. The role supports CMS Part D, NYSDOH, and OMIG reporting requirements and requires strong PBM data knowledge and the ability to translate complex data into actionable insights.

Responsibilities include developing dashboards, monitoring drug utilization and cost trends, and ensuring data quality across multiple systems.

Qualifications

• Bachelor’s degree required; Certified Professional Coder a plus.
• 3–5 years healthcare experience in a managed care setting.
• Strong proficiency in SAS, SQL and MS Excel; experience with a claims processing system or comparable database software.

Responsibilities

• Extract, compile, and analyze pharmacy claims data from PBM and internal data warehouse systems.
• Develop, maintain, and distribute recurring and ad hoc reports, dashboards, and pivot analyses (e.g., drug spend trends).
• Validate data quality across claims platforms, EDW, and clinical systems; identify and resolve discrepancies.
• Support CMS Part D reporting (enrollment, MTM, grievances, UT/UD, etc.) and DMP data administration.
• Assist in responding to audits and inquiries; document data collection methods and workflows.

Skills

SAS

SQL

Data analytics

Education

Bachelor's degree

Job description

CenterLight Health System is seeking a Pharmacy Data and Reporting Analyst to collect, analyze, and report on pharmacy claims and clinical program data. The role supports CMS Part D, NYSDOH, and OMIG reporting requirements and requires strong PBM data knowledge and the ability to translate complex data into actionable insights.

Responsibilities include developing dashboards, monitoring drug utilization and cost trends, and ensuring data quality across multiple systems.