Financial Planning & Analysis Analyst III

This position supports the National Medicare & Medicaid Finance (NMF) Department's Analytic Services team in delivering Medicare Advantage forecasts, performance analysis, and bid and strategy support. The ideal candidate will have experience in finance, forecasting, budgeting, accounting, and variance reporting, with the ability to analyze complex data and provide actionable business insights. Advanced Excel skills are required, including the ability to work with large datasets and develop reporting solutions; experience with PowerQuery and Power BI is highly preferred. Project management experience is a plus, as this role partners with cross-functional teams to support key financial and strategic initiatives.

Job Summary:

This individual contributor is primarily responsible for supporting financial planning, modeling, analysis, and forecasting, identifying and preparing reports on financial and budgeting trends, assisting in analysis of operational performance, and gathering and preparing recommendations on financial activities and plans.

Essential Responsibilities:

Pursues self-development and effective relationships with others by proactively providing resources, information, advice, and expertise with coworkers and customers; influencing others through technical explanations and examples; providing occasional mentoring to team members; listening and responding to, seeking, and addressing performance feedback; creating plans to capitalize on strengths and develop weaknesses; anticipating and responding to the needs of others; and adapting to and learning from change, difficulties, and feedback.

Completes work assignments by applying up-to-date expertise in subject area to generate creative solutions; ensuring all procedures and policies are followed; leveraging an understanding of data, and resources to support projects or initiatives; collaborating cross-functionally to solve business problems; identifying and monitoring priorities, deadlines, and expectations; communicating progress and information; identifying, recommending, and implementing ways to address improvement opportunities; and escalating issues or risks as appropriate.

Supports the evaluation of the business environment by conducting financial assessments (e.g., Situational, Strengths/Weaknesses/Opportunities/Threats, Opportunity-Based Strategic Planning, system value chain analysis); and generating reports summarizing business, financial, or economic data.

Completes costing activities by identifying cost avoidance and cost recovery opportunities.

Supports improving financial performance by identifying financial trends; using results of analyses; calling attention to operational issues that need to be addressed to improve performance; and partnering with the business to address operational performance issues.

Supports business modeling by developing best-practice models; analyzing risk alternatives; and developing what-if scenarios and forecasts using in-house models or software.

Supports reporting of region/business unit financial information by evaluating financial trends, data analysis reports, and forecasts of income and expense; reviewing assets, liabilities, revenues, and expenses; and using data/inputs from region/business unit systems to support analyses (e.g., membership and utilization reports, volume reporting, day sales inventory, analysis spreadsheets, investment schedules).

Supports assessment of the business vision, objectives, and strategic initiatives by conducting research to assess financial impact of strategies and initiatives.

Creates budgets and/or forecasts under the guidance of others in accordance with business strategic initiatives by analyzing budgeting trends; preparing budget and forecasting; and coordinating with others to develop department/regional budgets.

Evaluates performance/operations/ financial state by using and implementing templates (e.g., cash flow, RFA process, weekly unit case report) and computer applications; conducting complex financial analyses (e.g., operating cash flow analyses, pro forma P&L, line item walk forwards, volume building blocks, NPV, IRR, Discounted Cash Flow, statistical analyses, economic analyses); and completing complex variance analysis (e.g., volume, P&L line item, cost of goods, rate).

Supports internal and external audits by assisting with preparation of audit schedules and review of audit results.

Supports field operations by analyzing their operational/financial performance.

Supports Financial Statement Analysis of business partners (e.g., suppliers, customers, co-packers, acquisition targets) by using software systems (Internet, Bloomberg, and D&B), annual reports, and/or interviews; determining the financial status (viability) of business partners; and assessing risk implications.

Supports others in advising region/business unit leaders on strategic fiscal matters by preparing regular and special reports for both financial and statistical matters in order to facilitate financial management throughout the organization; and organizing regular meetings with leadership to review financial results for their areas.

Supports strategic financial planning by performing and evaluating financial, utilization, and benchmark analytics.

Supports strategic financial planning by gathering and preparing recommendations for financial plans, acquisition activity, financial requirements, and operating forecasts; and applying financial concepts for financial planning and control.

Knowledge, Skills and Abilities: (Core)

Ambiguity/Uncertainty Management

Attention to Detail

Business Knowledge

Communication

Critical Thinking

Cross-Group Collaboration

Decision Making

Dependability

Diversity, Equity, and Inclusion Support

Drives Results

Facilitation Skills

Health Care Industry

Influencing Others

Integrity

Learning Agility

Organizational Savvy

Problem Solving

Short- and Long-term Learning & Recall

Teamwork

Topic-Specific Communication

Minimum Qualifications:

Bachelors degree in finance, business, or related field and Minimum three (3) years Financial Planning & Analysis experience, or directly related business experience. Additional equivalent work experience in a directly related field may be substituted for the degree requirement.

Preferred Qualifications:

One (1) year experience in a leadership role with or without direct reports.

One (1) year project management experience.

PrimaryLocation : Colorado,Greenwood Village,Greenwood Plaza IT

HoursPerWeek : 40

Shift : Day

Workdays : Mon, Tue, Wed, Thu, Fri

WorkingHoursStart : 08:00 AM

WorkingHoursEnd : 05:00 PM

Job Schedule : Full-time

Job Type : Standard

Employee Status : Regular

Employee Group/Union Affiliation : NUE-PO-01|NUE|Non Union Employee

Job Level : Individual Contributor

Job Category : Accounting, Finance & Actuarial Services

Department : Po/Ho Corp - Nat'l Medicare Medicaid Financ - 0308

Travel : Yes, 5 % of the Time

Colorado Residents: In any materials you submit, you may redact or remove age-identifying information such as age, date of birth, or dates of school attendance or graduation. You will not be penalized for redacting or removing this information.