Responsible for managing the ongoing processes of the cash and liquidity ratio forecast model spanning one month to two years or more. Responsible for adjusting forecast projections to align with business/industry changes and trends. Produce reports and presentation material to share forecast projections with senior leadership to support financial decisions and strategies. The role is critical to ensuring BCBSM cash and liquidity forecast projections and results are accurate and readily available to senior leadership; forecast data is key to financial decision-making by leadership. The role requires collaboration with business partners to collect and understand forecast and prior month actual data. An understanding of the forecast data and the ability to run quality checks and raise awareness of potential issues is key to mitigating liquidity issues. The ability to integrate and interpret projections into a comprehensive executive-level report is required. The role requires an understanding of investment risk analysis and proficient presentation skills to present forecast data in a clear and concise manner to senior leaders. * Prepare monthly, quarterly, and multi-year liquidity and cash forecast projections for BCBSM and subsidiaries. * Assess reasonableness of data and investigate outliers. * Collaborate with cross-functional business partners to obtain forecast projections and actual results and align on key factors impacting forecast. * Update forecast data regularly to ensure projections are refreshed in a timely manner. * Ensure key model inputs and assumptions are integrated and align with data provided by business partners to simplify the process of running sensitivity analyses to support the analysis of a range of scenarios. * Analyze liquidity ratio forecasts against historical data to evaluate long-term business trends and prepare forecast reporting packages for review by Treasury leadership; forecast data is also leveraged in capital planning processes. * Prepare monthly variance analysis to highlight considerable differences between forecast and actuals. * Research variances and provide supporting commentary/rationale. * Along with business partners, determine whether projections require an adjustment. QUALIFICATIONS * Bachelor's degree in finance, accounting or related field is required. * A minimum of five (5) years of analytical/forecasting experience is required. * A strong background in financial analysis and reporting is required. * Assist with cash management projects which require implementation of banking products and services as well as enhancements to existing processes, and establishment of new accounts. * Support tasks associated with the credit facility terms and covenants to ensure compliance with timely payment of interest as well as timely delivery of financial documents to administrative agent. * Support audit efforts to provide documentation evidence as it relates to the Enterprise Advisory and DIFS audits. All qualified applicants will receive consideration for employment without regard to, among other grounds, race, color, religion, sex, national origin, sexual orientation, age, gender identity, protected veteran status or status as an individual with a disability.
