Extract, analyze, and validate large sets of data used for quarterly projections. Develop new analytical tools and resources. Deliver quarterly projections to Finance leadership and other key business partners. Develop, maintain, and troubleshoot complex MS Excel and SQL-based models. Assist in coordinating and documenting financial analysis projects and/or financial reporting. Analyze and identify trends, variances, and key issues and provide recommendations for adjustment. Prepare and improve ... more details
The Financial Medical Expense Modeling Enablement Advisor will carry out projection and results analysis for core Medical Advantage Part C medical claims expense processed and paid on a fee-for-service (FFS) basis. This includes a quarterly update of projection assumptions based on emerging results and running the models to calculate the proposed GAAP projection. On a monthly basis, results relative to projection are reviewed, and research may be undertaken to explain variances to projection. Outside of core deliverables, the Advisor will implement model enhancements for greater efficiency, granularity, and accuracy. This individual will work with various teams including, but not limited to FP&A centralization, Market Finance, Product, Pricing, Reserving, Operations, and external Audit Firms.
Responsibilities:
Extract, analyze, and validate large sets of data used for quarterly projections.
Develop new analytical tools and resources.
Deliver quarterly projections to Finance leadership and other key business partners.
Develop, maintain, and troubleshoot complex MS Excel and SQL-based models.
Assist in coordinating and documenting financial analysis projects and/or financial reporting.
Analyze and identify trends, variances, and key issues and provide recommendations for adjustment.
Prepare and improve financial analysis and forecasting methodologies.
Assist with ad hoc projects/requests.
Preferred Competencies:
Strong analytical and problem-solving skills.
Advanced data manipulation and analysis skills.
Team player able to work in a matrix environment to meet reporting deadlines.
Ability to utilize independent judgment and discretion, identify variances, and recommend solutions.
A strong desire to learn and innovate.
Ability to communicate results of analysis to a multitude of individuals/groups.
Qualifications:
Bachelor's degree in Finance, Actuarial Science, Business or Economics preferred.
4+ years in a financial, actuarial or a highly analytical position.
ASA, FSA, MBA, or CPA are a plus (but not required).
Must have experience with data extraction/manipulation via SQL and strong Excel modeling/analysis skills.
Excellent judgment, communication, interpersonal, and organization abilities .
Understanding of or experience with financial projections .
Experience in a highly-regulated business environment.
If you will be working at home occasionally or permanently, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 10Mbps download/5Mbps upload.
For this position, we anticipate offering an annual salary of 93,100 - 155,100 USD / yearly, depending on relevant factors, including experience and geographic location.
This role is also anticipated to be eligible to participate in an annual bonus plan.
We want you to be healthy, balanced, and feel secure. That’s why you’ll enjoy a comprehensive range of benefits, with a focus on supporting your whole health. Starting on day one of your employment, you’ll be offered several health-related benefits including medical, vision, dental, and well-being and behavioral health programs. We also offer 401(k) with company match, company paid life insurance, tuition reimbursement, a minimum of 18 days of paid time off per year and paid holidays. For more details on our employee benefits programs, visit Life at Cigna Group.
About Cigna Healthcare
Cigna Healthcare, a division of The Cigna Group, is an advocate for better health through every stage of life. We guide our customers through the health care system, empowering them with the information and insight they need to make the best choices for improving their health and vitality. Join us in driving growth and improving lives.
Qualified applicants will be considered without regard to race, color, age, disability, sex, childbirth (including pregnancy) or related medical conditions including but not limited to lactation, sexual orientation, gender identity or expression, veteran or military status, religion, national origin, ancestry, marital or familial status, genetic information, status with regard to public assistance, citizenship status or any other characteristic protected by applicable equal employment opportunity laws.
If you require reasonable accommodation in completing the online application process, please email: SeeYourself@cigna.com for support. Do not email SeeYourself@cigna.com for an update on your application or to provide your resume as you will not receive a response.
The Cigna Group has a tobacco-free policy and reserves the right not to hire tobacco/nicotine users in states where that is legally permissible. Candidates in such states who use tobacco/nicotine will not be considered for employment unless they enter a qualifying smoking cessation program prior to the start of their employment. These states include: Alabama, Alaska, Arizona, Arkansas, Delaware, Florida, Georgia, Hawaii, Idaho, Iowa, Kansas, Maryland, Massachusetts, Michigan, Nebraska, Ohio, Pennsylvania, Texas, Utah, Vermont, and Washington State.
