Hybrid Strategic FP&A Analyst: Mandates & Forecasts

Blue Shield of California; California (MO); Hybrid; USD 112,000 - 167,000; Full time

Job summary

Blue Shield of California is seeking a Financial Analyst, Consultant to partner with the Mandates FP&A team, manage budgets, forecast expenses, and provide strategic recommendations across a $60M project portfolio. The role reports to the manager of Strategic Initiatives FP&A and involves creating financial models, scenario analyses, and monthly variance reporting.

The position emphasizes hybrid work with in-office collaboration, strong financial modeling, and extensive Excel proficiency, along

Qualifications

• Requires a bachelor's degree or equivalent experience.
• Requires at least 7 years of prior relevant experience.
• Requires strong financial modeling skills.
• Requires strong experience and expertise with Excel.
• Requires knowledge and experience with accounting accruals and reclasses.
• Desired experience with Project Management methodologies.
• Desired experience with Planview Project Management Software.
• Desired experience with state and federal mandates.

Responsibilities

• Summarize detailed revenue/expense data and compare summarized claim data against fee schedules and contracts.
• Produce contract performance reports, modeling of reimbursement rates, evaluation of financial contract modifications and compiling and monitoring key managed care statistics.
• Collect and evaluate data, develop and maintain financial models, analyze results and conduct scenario analyses to forecast balance sheet, cash flow and regulatory capital.
• Follow and conduct audit processes and review internal controls to ensure financial transactions are accurate, timely and comply with accounting standards, principles and company policy.
• Provide policy guidance and interpretation to ensure financial records are consistent and comply with company policies and GAAP.
• Partner with project teams to help manage budgets, create expense forecasts and explain variances.
• Create financial models in partnership with project teams to forecast benefits, and track actual achievement against those forecasts.
• Track and create mitigation plans for project risks, and communicate that risk to senior leadership.
• Review governmental mandates for complexity and implementation cost.
• Partner with mandates team on intake and ongoing cost support.
• Monthly reporting of YTD and MTD variances as well as development of full year forecast.
• General FP&A maintenance of the Mandates portfolio.

Skills

Financial modeling

Excel

Forecasting

Budgeting

GAAP knowledge

Education

Bachelor's degree or equivalent experience

Tools

Planview Project Management Software

Job description

Blue Shield of California is seeking a Financial Analyst, Consultant to partner with the Mandates FP&A team, manage budgets, forecast expenses, and provide strategic recommendations across a $60M project portfolio. The role reports to the manager of Strategic Initiatives FP&A and involves creating financial models, scenario analyses, and monthly variance reporting.

The position emphasizes hybrid work with in-office collaboration, strong financial modeling, and extensive Excel proficiency, along