Sr Senior Consultant - Financial Planning

Job Descriptionhe Financial Planning and Analysis Senior Consultant will report directly to the Director of FP&A and Risk Adjustment and will support the end-to-end analysis of profit & loss statements, reporting and budget & forecasting for the Aetna Better Health of Illinois Market. This covers 20% of the total Aetna Medicaid business revenue of $2.7 Billion and a membership of 400K (15% of state program). You will: Manage the Risk Adjustment Program and review and report updates to the program to the Senior FP&A Adviser for presentation to the Director, Market CFO, and Market CEO for enterprise submission Manage risk adjustment gap closure programs, including reporting out on key metrics such as chart chase, telehealth and face to face health assessments Work on projected risk scores for quarterly forecast and annual budget Create and support requisite and supplemental materials to assist in Risk Adjustment program explanations and/or updates to the Executive Leadership and Enterprise Advise on the latest updates from the state regarding risk adjustment and will support analysis of the financial impact Support the EUM quarterly submissions to the state and subsequently interacting with the Encounters team and other Departments as necessary Help with inquiries by both the state and the Illinois Association of Medicaid Health Plans regarding Risk Adjustment and data submission for the purpose of risk adjustment state program updates Support Premium with analysis of any/all adjustments and updates to risk scores by rate cell and product Support the monthly calculation of Risk Corridor/MLR Rebate position of the Plan for internal and external reportingRequired Qualifications 3+ years of experience in risk adjustment 3+ years of experience navigating through large data sets using tools like Excel (queries, formula and report building)COVID RequirementsCOVID-19 Vaccination RequirementCVS Health requires certain colleagues to be fully vaccinated against COVID-19 (including any booster shots if required), where allowable under the law, unless they are approved for a reasonable accommodation based on disability, medical condition, religious belief, or other legally recognized reasons that prevents them from being vaccinated. You are required to have received at least one COVID-19 shot prior to your first day of employment and to provide proof of your vaccination status or apply for a reasonable accommodation within the first 10 days of your employment. Please note that in some states and roles, you may be required to provide proof of full vaccination or an approved reasonable accommodation before you can begin to actively work.Preferred Qualifications Basic accounting and GAAP experience as it relates to treatment of revenue and expense items on profit and loss, income statement and balance sheet Managed Care experience Managed Care State Reporting Knowledge of complex Database and Datawarehouse extraction Experience with Hyperion/S4 Hana and SQL Ability to read/write queries for data interpretation Ability to communicate and present financial information to management Budget and forecasting experience Variance analysis and financial modeling experienceEducation Bachelor's Degree required MBA, Master's Degree or equivalent experience preferredBusiness OverviewBring your heart to CVS HealthEvery one of us at CVS Health shares a single, clear purpose: Bringing our heart to every moment of your health. This purpose guides our commitment to deliver enhanced human-centric health care for a rapidly changing world. Anchored in our brand - with heart at its center - our purpose sends a personal message that how we deliver our services is just as important as what we deliver.Our Heart At Work Behaviors support this purpose. We want everyone who works at CVS Health to feel empowered by the role they play in transforming our culture and accelerating our ability to innovate and deliver solutions to make health care more personal, convenient and affordable. We strive to promote and sustain a culture of diversity, inclusion and belonging every day. CVS Health is an affirmative action employer, and is an equal opportunity employer, as are the physician-owned businesses for which CVS Health provides management services. We do not discriminate in recruiting, hiring, promotion, or any other personnel action based on race, ethnicity, color, national origin, sex/gender, sexual orientation, gender identity or expression, religion, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.

Created: 2026-03-07