Sr. Analyst, Payer Data

We’re building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you’ll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger – helping to simplify health care one person, one family and one community at a time.

Role Description

The Payer Data Analyst will be responsible for aiding the Business Intelligence team in acquiring, ingesting and monitoring data quality for payer data sent to Oak Street Health. This is a new position to the organization, and functions alongside several business units to leverage health plan relationships and data for the benefit of Oak Street patients. While day-to-day activities will be variable and highly dependent on each health plan, common over-arching tasks include: negotiation with health plans for standard files, business analysis of incoming files, reconciliation of data for both internal and external audit purposes, and functioning as an internal SME for a specific payer data subject area.

Responsibilities

• Aid or lead conversations with health plans for data acquisition

• Aid, lead and/or perform UAT for all new datasets coming to Oak Street Health

• Research and suggest solutions for data quality and governance issues related to payer data as used in both data warehouse processes and business decision making

• Function as a SME for the subject area specifically hired into

• Establish relationships with internal and external partners to obtain and validate quality data

• Assist in creating uniform business rules and policies that will be used for Oak Street Health

• Other duties as assigned

Minimum Requirements:

• 3 years of relevant healthcare work experience.

• Proficient in writing SQL queries and reading stored procedures on large data sets with complex data models.

• Advanced Microsoft Excel skills (PowerPivot, functions, VBA).

• Database fundamentals experience: knowledgeable in database rules, writing queries, and relational database theory and management (table creation, querying, relational structures).

• Ability to manage deadlines, deliverables, and communication with relevant stakeholders.

• Strong written and verbal communication. 

Preferred Requirements:

• Experience with manipulating large files and working with missing values in Python (using pandas) are preferred.

• Experience with Databricks, SQL Server, or Foundry.

Education:

• Bachelor’s degree preferred; preferably in Business Administration, Health Administration, Public Health or Computer Science.

Anticipated Weekly Hours

40

Time Type

Full time

Pay Range

The typical pay range for this role is:

$46,988.00 - $122,400.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, depend