Senior Reporting Analyst

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.

CVS Health has an exciting opportunity to join our PBM Customer Reporting group as a Senior Reporting Analyst within our Compliance Pharmacy Payments. CVS Health strives to continuously innovate around how we report and analyze data, improve operational efficiency, and deliver outstanding customer service. 
You will work with a collaborative, close-knit team on pharmacy and member specific claims data including, but not limited to, financial and operational information supporting state and federal compliance reporting. You will be responsible for standard and ad-hoc client and regulatory Prompt Pay and Pharmacy Payment Compliance reporting using SQL and SAS. You will continuously improve quality controls and accuracy of reported data, looking for ways to further automate reporting activities. New team members are onboarded with training in this niche data set, and the team is highly collaborative.
You will report to the Senior Reporting Manager within the Compliance Pharmacy Payments team. To be successful in this role, you need to have solid SQL skills, be comfortable with working in a fast-paced environment, have attention to detail, and be a team player with a strong drive for fostering collaboration, knowledge sharing, and continuous improvement. 
Key Responsibilities

• Develop reports in SQL and SAS.
• Review MCO/Client Requests with internal and external partners to translate them into clear business requirements
• Build relationships with Account Teams, Legal, Compliance, Client Audit, Finance Operations, and others, by providing reporting leadership representation.
• Continuously evaluate/evolve processes, best practices, and tools around data, reporting, and automation.
• Ensure the accuracy and quality of the deliverables, applying high standards for quality control to all reporting and analytic work. Ensure consistent and clear documentation for production-ready reporting solutions.
• Handle, communicate, and escalate issues (as needed) in a timely manner so as not to impact delivery
• Lead by example to inspire a positive attitude, engagement, and professional growth.
• Proactively lead reporting & automation activities, tracking completion of action items, resolving issues, and mitigating risk
• Champion a culture of continuous improvement, curiosity, collaboration, and innovation.
• Constantly work to understand data structures and their business context
• Negotiate and document requirements, agreements and changes with business users

Required Qualifications

• 2+ years of experience supporting reporting, analytics, or automation projects.
• 2+ years of experience writing scripts in SQL and/or SAS.

Preferred Qualifications

• Experience with any of these a plus: Python, R, Alteryx, Trifacta, Linux OS, GCP/ AWS/ Azure.
• Experience working with medical and/or pharmacy claims data.
• Experience in healthcare industry, including health insurance, PBM or pharmacy services.

Education

• Bachelor’s degree or equivalent work experience
• Master’s degree preferred

Anticipated Weekly Hours

Time Type

Pay Range

The typical pay range for this role is:

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, visit https://jobs.cvshealth.com/us/en/benefits

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