Financial Analyst

Company: CVS Health
Location: Richmond
Posted on: September 23, 2022

Job Description:

Job DescriptionThe Financial Analyst will support Aetna's ability to achieve its financial and strategic goals through effective support of financial closing, planning, and forecasting processes. This role will function as key collaborator with the plan CFO and other departments in the local market to achieve plan financial results. This employee will ensure that all financial reporting is accurate and will maintain financial and operational control of the business. Direction is to provide financial analysis and recommendations in support of management's evaluation of strategic and business initiatives. Advanced finance position performing complex assignments requiring strong analytical and technical skills. May serve as Subject Matter Expert for the unit participating in and sometimes leading special projects and ad hoc reporting requests as needed.Job Responsibilities:- Provide data and analysis to support the unit's mission- Assist with analysis of key components of financial results and address questions as needed- Manage data from multiple sources using relational databases and write scripts to drive reporting- Collaborate with Actuaries, Medical Economics and plan personnel to identify/measure medical savings opportunities- Prepare financial reports due per the state contract, including but not limited to minimum MLR calculations and rate setting.- Prepare large claims reserves in conjunction with the monthly IBNR process- Prepare complex ad hoc monthly reports as needed for expenses, staffing and key performance metrics- Streamline processes for efficiency and identify cost savings opportunities within defined scope - Prepare monthly market share reporting for delivery to plan management team- Represent the Finance team in all plan/provider meetings requiring Finance participationPay RangeThe typical pay range for this role is:Minimum: 43,700Maximum: 97,400Please keep in mind that this range represents the pay range for all positions in the job grade within which this position falls. The actual salary offer will take into account a wide range of factors, including location.Required Qualifications-3+ years of experience with financial planning and analysis-3+ years of experience with MS Excel using pivot tables and v-lookup -3+ years of experience with relational databasesCOVID 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- 3-5 years experience in relevant industries such as healthcare, managed care, or insurance- Knowledge of Relational Databases- Experience with SQL and SQL Server- Ability to manipulate large amount of data into concise analytical reports- Experience creating Data Visualizations- Project Management experience- Ability to collaborate with functional areas to drive results- Ability to create and deliver presentations to internal and external customersEducationBachelor's degree or equivalent experience requiredPreferring degrees in Finance, Accounting, Actuarial Science, Math, Data Science, Computer Science, or related disciplines. Master's degree (i.e. MBA) preferred.Business 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.PDN-96c3d0c1-ca50-4b40-bded-5e4b99127e8e

Keywords: CVS Health, Ogden , Financial Analyst, Professions , Richmond, Utah