Lead Director FP&A (SQL, Data Analytics)

CVS Health•Massachusetts, MA

29d•$100,000 - $231,540•Remote

About The Position

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.This position is classified as remotePosition SummaryThe Lead Director Financial Reporting & Analytics will report directly to the Chief Financial Officer in a capacity that leads the Financial Analytics and Reporting Team. Role responsibility is to lead the strategy for the analytical activities for identifying medical cost initiatives on behalf of the Health Plan completing complex medical cost analysis and presenting findings to cross functional leadership team. Work with constituent areas in the local market, finance, actuarial, growth partners and MEU leadership to execute and influence actionable items to mitigate medical cost drivers, lead cost of care initiatives and drive leadership for scorable action item achievement of targets. Champion ongoing communication with key stakeholders to maximize collaboration and drive impact. Lead the coordination of complex financial and claims analytics to determine the impact and support local market decisions. Position entails discussing the financial data and impact and assisting the local market to make strategic savings decisions to help lower medical costs. Additional responsibilities include leading the financial validations efforts needed to onboard provider and vendor relationships related to their payment structure and performance evaluations needed to establish KPIs.The candidate needs to lead a team of technical and financial subject matter experts and provide development and mentorship.

Requirements

Knowledge of:Healthcare/Insurance KPIs
Financial Modeling and Variance Analysis
Contract interpretation and adaptation
Basic Database design, data modeling, and ETL automation processes
Demonstrates strong ability to communicate technical concepts and implications to business partners
Demonstrates proficiency in building dashboards using AI, BI Tools such as visual studios, SQL, Tableau or SSRS
Healthcare sector experience preferred
Skill In: Strong analytical ability and familiarity with advanced financial and healthcare concepts.
10+ years of a combination of consulting and financial experience and managing projects or process.
10+ years in finance, analyzing cost, budgets, forecasting, and P&L
10+ years of experience with SQL or other Statistical and Database warehouses.
7+ years of experience with Excel (Reporting & Modeling), Tableau, or SSRS/SSIS/SSAS.
Strong verbal/written communication and data presentation skills.
Strong people leadership skills
Ability To: Maintain continuous learning curiosity.
Develop analytical tools and models.
Build, analyze, and communicate the story using data stored in reporting warehouse. This can include preparing easy-to-understand charts, tables, graphs, and other related documents for diverse audiences.
Effective communication and presentation skills with Leadership.
Experience leading cross-functional teams and departments to reporting and automation solutions that are easy to understand and effective..

Nice To Haves

Knowledge of:Managed Medicaid experience in complex Medicaid market.
Accounting and Basic GAAP as it relates to treatment of revenue and expense items on profit and loss, income statement and balance sheet.
Hyperion/S4 Hana/SQL/AI.
Demonstrated experience in defining and designing KPI metrics.
Deep understanding of the various business initiatives across the organization.
Skill in:Managing an engaging and accomplished team of Consultants.
Ability To:Advanced Financial modeling.
Partner with the business leaders to define operational KPIs (e.g. Cost, & Financial) to be used to manage operational & business performance.

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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume