Senior Financial Planning and Analysis Analyst - Workforce Planning & Operations Analytics (Hybrid)
PURPOSE
The Senior Analyst, FP&A Workforce Planning & Operations Analytics develops long-range operational forecasts, workforce capacity models, and analytical tools that guide staffing, budgeting, and service-level decisions. The role combines financial planning, data analytics, and workforce modeling to deliver clear insights that optimize staffing and labor costs.
Essential Functions
Forecasting & Demand Modeling: Develop driver-based demand forecasts using enrollment, product changes, seasonality, regulatory shifts, digital adoption, and other operational trends/drivers. Translate business growth (membership, product launches, group movement) into actionable operational workload across all teams in operations such as Call center, Claims, Enrollment, Billing, SIU etc. Provide forecasting insights, variances, and scenarios for Operations and Finance.
Workload, Efficiency & Capacity Modeling: Model AHT, processing time, productivity, case duration, and other efficiency metrics across workflows. Convert workload into monthly/quarterly FTE requirements incorporating shrinkage, utilization, attrition, and rampup curves. Apply Erlang C or equivalent methods to ensure staffing meets service-level targets (Average Speed of Answer / Service Level). Build Base/High/Low staffing scenarios for budget planning.
Governance, Collaboration & FP&A support: Lead monthly forecast refreshes of models and contribute to quarterly capacity planning reviews with Operations, Finance, and Workforce Management. Translate staffing needs into labor cost forecasts for monthly outlooks, quarterly forecasts, and annual budget. Partner with Workforce Management, Finance, Ops and HR to align hiring plans and staffing strategy. Performs MAPE (Mean Absolute Percentage Error) back testing of the models, variance analysis, and data reconciliation across systems.
Analytical Insights & Reporting Solutions: Ingest and transform data from multiple systems to support accurate and timely forecasting and capacity planning by using SQL, Python, and other analytical tools. Build clear, insight-driven dashboards and reports (Power BI & Excel) that highlight demand trends, staffing needs, service-level risks, and financial impacts. Maintain a structured Data Dictionary to ensure consistent definitions for volumes, AHT, FTE, shrinkage, and other key planning metrics across Operations, HR, Finance, and Workforce teams.
AdHoc & Strategic Projects: Support special analytical projects across FP&A, Operations, Cost of Care, and other health insurance business functions. Provide deep dive insights into operational efficiency, productivity, digital adoption, and performance improvements.
Success Indicators
Forecast accuracy (MAPE) within target.
Staffing variance maintained within 5%.
High adoption of dashboards and modeling outputs.
Ontime delivery of FP&A and operational planning insights.
Demonstrated partnership across Operations, HR, Finance, Workforce management and other relevant stakeholders.
Qualifications
Education Level: Bachelor's Degree in Finance, Business Administration or related field OR in lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.
Experience: 5 years experience in a finance or analytical role within the finance sector or quantitative analysis.
Preferred Qualifications: MBA/MS, preferably in a quantitative and analytical discipline. Specific experience building Excel-based financial models. Understanding of healthcare marketplace dynamics and healthcare financial and operational reporting. Strong proficiency in SQL, Excel, Power BI, Python and Azure/MS Fabric. Familiarity with ETL/ELT workflows and BI semantic layer design. Ability to model complex datasets and translate findings into actionable insights. Knowledge, Skills And Abilities (KSAs): Ability to manage long-term projects meeting deadlines and ensuring compliance. Ability to prepare ad-hoc analysis, experience studies and reports. Must demonstrate flexibility, innovation and problem-solving skills and resourcefulness. Ability to express technical and financial analysis in a clear, concise manner on both written and oral form. Strong mathematical acumen with a solid understanding of financial and accounting principles. Excellent communication and influencing skills, able to interface with senior leaders in the business. Proficient in Excel, VBA, PowerPoint, and data analysis software (e.g., SAS, Access). Good analytical skills, highly detail oriented and a thorough understanding of general economic theory as it relates to the lending and business environment.
Sponsorship in US
Must be eligible to work in the U.S. without Sponsorship.
Federal Disc/Physical Demand Note
The incumbent is required to immediately disclose any debarment, exclusion, or other event that makes him/her ineligible to perform work directly or indirectly on Federal health care programs. Physical Demands: The associate is primarily seated while performing the duties of the position. Occasional walking or standing is required. The hands are regularly used to write, type, key and handle or feel small controls and objects. The associate must frequently talk and hear. Weights up to 25 pounds are occasionally lifted.
Department
Financial Planning & Analysis
Equal Employment Opportunity
CareFirst BlueCross BlueShield is an Equal Opportunity (EEO) employer. It is the policy of the Company to provide equal employment opportunities to all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information.
Sponsorship in US
We are an Equal Opportunity Employer. We consider applicants without regard to race, color, religion, national origin, sex, age, disability, veteran status, genetic information, sexual orientation, gender identity or any characteristic protected by law.