Senior Analyst, Pharma Reporting

CVS Health; United States; Remote; USD 46,000 - 113,000; Full time

Job summary

CVS Health is seeking a Sr. Analyst, Pharma Reporting to ensure the successful delivery of contractual reporting requirements. This role involves collaboration with internal teams and handling data contracts, analysis, and SQL execution to support pharmaceutical reporting projects. Candidates should possess strong analytical capabilities, SQL skills, and a degree in a relevant field.

Benefits

401(k) plan with company matching

Affordable medical plan options

Employee stock purchase plan

Flexible work schedules

Tuition assistance

Wellness screenings

Confidential counseling

Financial coaching

Qualifications

• 1+ year of SQL experience or relevant programming experience.
• 2+ years in professional services with reporting requirements.
• Knowledge of requirements documentation.

Responsibilities

• Review and redline Pharma's data reporting contracts.
• Collaborate with Specialty Pharmacy systems for data delivery.
• Execute and modify SQL queries for data manipulation.

Skills

SQL

MS Excel

Data Analysis

Communication

Problem Solving

Education

Bachelor's Degree in Information Systems, Mathematics, Computer Science, Statistics, or related field

Tools

Teradata

Google Big Query

Snowflake

Oracle databases

Job description

At CVS Health, we’re building a world of health around every consumer and surrounding ourselves with dedicated colleagues who are passionate about transforming health care.

As the nation’s leading health solutions company, we reach millions of Americans through our local presence, digital channels and more than 300,000 purpose-driven colleagues – caring for people where, when and how they choose in a way that is uniquely more connected, more convenient and more compassionate. And we do it all with heart, each and every day.

Position Summary:
The Sr. Analyst, Pharma Reporting will be responsible for ensuring the successful delivery of pharmaceutical manufacturers' (Pharma) contractual reporting requirements and providing post-production support for Pharma's data and reports. Key responsibilities include:

• Reviewing and redlining Pharma's data reporting contracts to ensure that reporting requirements, including data quality and specifications, are clearly understood and adequately captured within the contract.

• Assessing the feasibility of delivering data according to Pharma's contractual needs by conducting necessary research within our Specialty Pharmacy systems and collaborating with our Specialty data systems partners.

• Collaborating with CVS Specialty & Retail Trade teams to understand upcoming data project needs and product pipelines while providing relevant updates on project implementations and support activities.

• Creating and maintaining business requirements documentation based on Pharma's contractual data specifications and ensuring that the requirements are clearly communicated to the project team and other internal stakeholders.

• Acting as the designated point of contact for Pharma and their third parties (HUBs and Data Aggregators) during contract redlining, project implementation, and ongoing support of Pharma's data and reports. Leading any data-related discussions and addressing data-related questions.

• Thoroughly reviewing and investigating any data issues, concerns, or questions in a timely manner, and ensuring that any data issues are addressed according to contractual SLAs.

• Partnering with external and internal teams as needed to address data questions and issues.

• Conducting root cause analysis of incoming data concerns that do not comply with Pharma contracts to remediate the issue and prevent it from occurring again in the future.

• Executing and modifying simple and moderately complex SQL queries to combine, parse, extract, and manipulate data to aid in the analysis and resolution of complex data requests/issues.

• Collaborating with the development team and Account Managers to analyze and collect meaningful metrics and insights for Quarterly Business Review meetings with Pharma.

• Closely tracking Pharma reporting projects/intake for successful delivery.

• Handling other responsibilities that may arise related to servicing data requests for our Pharma clients.

Primary Duties and Responsibilities:

Creating and reviewing business and technical documents and contract language pertaining to data reporting requests by pharmaceutical manufacturers to demonstrate understanding of data commitments and implications for the business (15%). Ensuring production inquiries are resolved in a timely manner, reviewing, problem-solving, and conducting root cause analysis of incoming data concerns that do not comply with Pharma contracts (20%). Analyzing data and reporting information from data feeds and warehouses to determine the feasibility of data reporting requests from pharmaceutical manufacturers (10%). Tracking project implementations or intake for data-related changes (30%). Executing proper maintenance and centralized storage of key project documentation, including business requirements, technical specifications, design documents, test plans, etc. (10%). Writing and executing simple and moderately complex SQL queries to combine, parse, extract, and manipulate data to aid in data reporting (15%).

Required Skills:

• 1+ year of SQL experience or other relevant programming experience.

• Intermediate MS Excel knowledge.

• 2+ years of experience working in a professional services environment with clients/stakeholders, preferably in reporting requirements, data reconciliation, and root cause analysis.

• Ability to influence and build effective working relationships with all stakeholders.

• Must have a "can do" attitude and effective oral and written communication skills.

• Intermediate analytical and problem-solving skills.

• Knowledge of requirements documentation (business requirements, functional requirements, solution requirements, etc.).

Preferred Skills:

• Experience reviewing and redlining contractual documents.

• 1+ years of healthcare experience; specialty pharmacy experience a plus

• 2+ years of experience working in a client-facing role.

• Knowledge of Teradata, Google Big Query, Snowflake, and Oracle databases.

Education:

Bachelor's Degree with a concentration in Information Systems, Mathematics, Computer Science, Statistics, Analytics, Accounting, or other scientific-related field of study, or 4 years of equivalent work experience.

Anticipated Weekly Hours

40

Time Type

Full time

Pay Range

The typical pay range for this role is:

$46,988.00 - $112,200.00

This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls. The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors. This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above.

Our people fuel our future. Our teams reflect the customers, patients, members and communities we serve and we are committed to fostering a workplace where every colleague feels valued and that they belong.

Great benefits for great people

We take pride in our comprehensive and competitive mix of pay and benefits – investing in the physical, emotional and financial wellness of our colleagues and their families to help them be the healthiest they can be. In addition to our competitive wages, our great benefits include:

• Affordable medical plan options, a 401(k) plan (including matching company contributions), and an employee stock purchase plan.

• No-cost programs for all colleagues including wellness screenings, tobacco cessation and weight management programs, confidential counseling and financial coaching.

• Benefit solutions that address the different needs and preferences of our colleagues including paid time off, flexible work schedules, family leave, dependent care resources, colleague assistance programs, tuition assistance, retiree medical access and many other benefits depending on eligibility.

For more information, visithttps://jobs.cvshealth.com/us/en/benefits

We anticipate the application window for this opening will close on: 06/30/2025

Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.