Healthcare FP&A Data Advisor - The Cigna Group
Chicago, IL
About the Job
The Healthcare FP&A Data Advisor role will support the unique data, modeling, and analysis needs of the FP&A team. They will have stewardship of curated input/output data sets from the FP&A quarterly projection and monthly financial close models (including scheduling/running certain periodic ETL processes). Stewardship includes maintaining data documentation and working with the more general data and analytics teams to ensure alignment and interoperability. They will also act as a consultant to others in the MA FP&A space on best practices for model/data governance and deep dive root cause analysis on emerging financial results. The advisor will work with various teams including, but not limited to, FP&A centralization, Market Finance, Pricing, Reserving, Operations, and external Audit Firms.
Responsibilities:
+ Understand, document, and maintain the FP&A database and data ecosystem.
+ Run or automate/schedule periodic ETL processes (some of which may be models owned by peer teams).
+ Develop new analytical tools and resources.
+ Enhance the team model governance framework and support the FP&A team in adhering to the framework.
+ Consult on optimizing and troubleshooting complex MS Excel and SQL-based models.
+ Assist in coordinating and documenting financial analysis projects and/or financial reporting.
+ Help peer teams analyze and identify trends, variances, and key issues.
+ 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 Actuarial Science, Business, Economics or Finance preferred.
+ ASA, FSA, MBA, or CPA are a plus (but not required).
+ 4+ years in a financial or a highly analytical position
+ Experience working with medical claims data within healthcare, health services or insurance industries
+ Must have experience with data extraction/manipulation via SQL and strong Excel modeling/analysis skills. Familiarity with R or Python are a plus (but not required).
+ Excellent judgment, communication, interpersonal, and organizational 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._
_Qualified applicants with criminal histories will be considered for employment in a manner_ _consistent with all federal, state and local ordinances._
Responsibilities:
+ Understand, document, and maintain the FP&A database and data ecosystem.
+ Run or automate/schedule periodic ETL processes (some of which may be models owned by peer teams).
+ Develop new analytical tools and resources.
+ Enhance the team model governance framework and support the FP&A team in adhering to the framework.
+ Consult on optimizing and troubleshooting complex MS Excel and SQL-based models.
+ Assist in coordinating and documenting financial analysis projects and/or financial reporting.
+ Help peer teams analyze and identify trends, variances, and key issues.
+ 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 Actuarial Science, Business, Economics or Finance preferred.
+ ASA, FSA, MBA, or CPA are a plus (but not required).
+ 4+ years in a financial or a highly analytical position
+ Experience working with medical claims data within healthcare, health services or insurance industries
+ Must have experience with data extraction/manipulation via SQL and strong Excel modeling/analysis skills. Familiarity with R or Python are a plus (but not required).
+ Excellent judgment, communication, interpersonal, and organizational 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._
_Qualified applicants with criminal histories will be considered for employment in a manner_ _consistent with all federal, state and local ordinances._
Source : The Cigna Group
