, Illinois

Job Description
The 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 reporting

Required 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 Requirements
CVS Health requires its 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, or religious belief that prevents them from being vaccinated.

If you are 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 within the first 10 days of your employment. For the two COVID-19 shot regimen, you will be required to provide proof of your second COVID-19 shot within the first 45 days of your employment. In some states and roles, you may be required to provide proof of full vaccination before you can begin to actively work. Failure to provide timely proof of your COVID-19 vaccination status will result in the termination of your employment with CVS Health.

If you are unable to be fully vaccinated due to disability, medical condition, or religious belief, you will be required to apply for a reasonable accommodation within the first 10 days of your employment in order to remain employed with CVS Health. As a part of this process, you will be required to provide information or documentation about the reason you cannot be vaccinated. In some states and roles, you may be required to have an approved reasonable accommodation before you can begin to actively work. If your request for an accommodation is not approved, then your employment may be terminated.

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 experience

• Bachelor’s Degree required
• MBA, Master’s Degree or equivalent experience preferred

Business Overview
At CVS Health, we are joined in a common purpose: helping people on their path to better health. We are working to transform health care through innovations that make quality care more accessible, easier to use, less expensive and patient-focused. Working together and organizing around the individual, we are pioneering a new approach to total health that puts people at the heart.

We strive to promote and sustain a culture of diversity, inclusion and belonging every day. CVS Health is an equal opportunity and affirmative action employer. We do not discriminate in recruiting, hiring or promotion based on race, ethnicity, sex/gender, sexual orientation, gender identity or expression, age, disability or protected veteran status or on any other basis or characteristic prohibited by applicable federal, state, or local law. We proudly support and encourage people with military experience (active, veterans, reservists and National Guard) as well as military spouses to apply for CVS Health job opportunities. See Job Description

, Illinois

Continue serving and work with a purpose

As a CVS Health colleague, you'll find career opportunities across the organization and at every stage of your career. More important, your work will have an impactful purpose on someone's life, including your own. Learn more about how you can continue serving on your next mission at CVS Health.

Careers for Veterans and Military Spouses


"The military has an ethos that is grounded in purpose-driven service that’s bigger than the individual. The same holds true for us at CVS Health. You can talk to colleagues in any part of our business and they will be able to articulate our company’s purpose. Working here provides an opportunity for service members and military spouses to continue to serve, just in a civvies."

Similar jobs