Network Strategy Analyst

CVS Health•Work At Home-Illinois, IL

6d•$66,330 - $145,860

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. CVS Health is positioned as the nation’s premier health innovation company. Through our health services, insurance plans and community pharmacists, we’re pioneering a bold new approach to total health. As a CVS Health colleague, you’ll be at the center of it all! Position Summary: The manager-level analyst of Networks Strategy will be responsible for analyzing, building, and maintaining financial and operational tools to support organizational understanding of the network value and its flow into underwriting modeling. The motivated and detail-oriented manager will deploy capabilities to increase both automation and data accuracy. A candidate on this team will perform a variety of ad-hoc analyses in response to specific business questions and will have the opportunity to present to and work in collaboration with internal business partners, such as Network Development, Pricing/Underwriting, Operations, and Finance.

Requirements

5+ years of analytical experience in network, contracting, pricing, and/or finance
3+ years experience in Specialty Pharmacy, PBM, or related healthcare field
Experience utilizing Excel, including formulas, VLOOKUP's, pivot tables
Experience with SQL and Data Visualization

Nice To Haves

3+ years of experience in Pharmaceutical data management
3+ Advanced Excel knowledge including formulas, VLOOKUP's, pivot tables
3+ Experience with BigQuery/SQL, Dataiku programming languages (Python/R), and Data Visualization
3+ Demonstrated proficiency in MS Office Suite Products (Word, Outlook, Excel, PowerPoint)
Ability to work independently, meet deadlines, and manage competing demands
Experience working cross-functionally in an organization.
Reporting and data analytics experience

Responsibilities

Create and maintain BigQuery / SQL processes to integrate with master claims tables to fit the needs of cost of goods modeling. Create standard data summary outputs that will help understand trends.
Develop and support Excel and Tableau based financial impact reports or dashboards that assist in leadership decision making and strategy.
Build Excel models to answer business questions and help model and quantify network value.
Other ad hoc financial modeling and duties as assigned