Senior Financial Planning and Analysis Analyst - ...

Resp & Qualifications PURPOSE The Senior Analyst, FP&A Workforce Planning & Operations Analytics develops longrange operational forecasts, workforce capacity models, and analytical tools that guide staffing, budgeting, and servicelevel decisions. The role combines financial planning, data analytics, and workforce modeling to deliver clear insights that optimize staffing and labor costs. This position is ideal for a datasavvy analyst looking to deepen FP&A and operational strategy experience while applying advanced technical skills (SQL, Excel, Python, Power BI, MS Fabric/Azure) 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 servicelevel 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 contributes to quarterly capacity planning reviews with Operations, Finance, and Workforce Management. + Translate staffing needs into laborcost 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, insightdriven dashboards and reports (Power BI & Excel) that highlight demand trends, staffing needs, servicelevel 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 healthinsurance 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. SUPERVISORY RESPONSIBILITY: Position does not have direct reports but is expected to assist in guiding and mentoring less experienced staff. May lead a team of matrixed resources. 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., AdvancedMust be able to meet established deadlines and handle multiple customer service demands from internal and external customers, within set expectations for service excellence. Must be able to effectively communicate and provide positive customer service to every internal and external customer, including customers who may be demanding or otherwise challenging. Salary Range: $80,280 - $159,445 Salary Range Disclaimer The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the work is being performed. This compensation range is specific and considers factors such as (but not limited to) the scope and responsibilities of the position, the candidate's work experience, education/training, internal peer equity, and market and business consideration. It is not typical for an individual to be hired at the top of the range, as compensation decisions depend on each case's facts and circumstances, including but not limited to experience, internal equity, and location. In addition to your compensation, CareFirst offers a comprehensive benefits package, various incentive programs/plans, and 401k contribution programs/plans (all benefits/incentives are subject to eligibility requirements). 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. Where To Apply Please visit our website to apply: 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. Sponsorship in US Must be eligible to work in the U.S. without Sponsorship #LI-CB1 REQNUMBER: 21779

Created: 2026-02-12