Sr. Analyst, Payer Data

CVS Health

3d

About The Position

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.

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.

Nice To Haves

• Experience with manipulating large files and working with missing values in Python (using pandas) are preferred.
• Experience with Databricks, SQL Server, or Foundry.

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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees