Treasury Modeling Analyst III

Wings Credit Union•Apple Valley, MN

3d•$110,000 - $130,000

About The Position

This role supports Wings' financial strength by helping produce reliable CECL reserve forecasts and capital planning projections across major loan portfolios. It ensures that loan-level data, assumptions, model outputs, and documentation are accurate, well-controlled, and ready for audit, examiner, committee, and board review. The position connects credit risk modeling with broader balance sheet, income, provision, liquidity, and capital stress planning so leadership can understand how portfolio changes and economic stress may affect reserves and capital. It also partners with Credit Risk, Treasury, IT, Risk Management, and Internal Audit to improve data quality, validate assumptions, and support effective challenge of modeling results. Overall, this is a quantitative risk and finance role that helps the credit union make informed decisions about credit loss reserves, capital adequacy, and financial resilience.

Requirements

Bachelor's Degree in Finance, Accounting, Economics, Statistics, Mathematics, or related quantitative field required
5+ years of progressive experience in credit risk, ALM, capital planning, or financial analysis at a bank, credit union, or financial services firm required
3+ years experience in financial forecasting or modeling required
Strong proficiency in Excel (advanced formulas, pivots, Power Query), SQL, and large-data manipulation.
Experience with model documentation standards
Strong analytical, quantitative, and problem-solving skills with attention to detail.
Excellent written and verbal communication; ability to translate complex modeling concepts for executive audiences.
Ability to operate independently with sound judgment and to challenge assumptions constructively.
Project management skills with ability to manage competing deadlines
Working knowledge of ASC 326 (CECL), the interagency policy statement on the ACL, and NCUA Part 702 Subpart C capital planning and stress testing requirement required.

Nice To Haves

Master's Degree in Business Administration or similar preferred
Demonstrated experience executing or supporting a CECL/ACL model in production, preferred.
Experience with Moody's modeling products, Empyrean, Axiom, Databricks, Python, R, or SAS for data engineering and model analytics preferred.
Prior exposure to NCUA examinations or external model validations preferred.

Responsibilities

Support the Credit Forecasting Manager in executing the monthly CECL run within Moody's Impairment including loan-level data loads, segmentation validation, scenario application, and reserve calculation across consumer, mortgage, auto, credit card, and commercial portfolios.
Perform data integrity checks, source-to-report reconciliations, exception reporting, and document data lineage for audit and examiner review.
Run ad hoc CECL impact analyses.
Help to maintain model documentation including methodology memos, assumption inventories, model change logs, back-testing results, and sensitivity analyses.
Work closely with IT partners to improve the quality, accuracy, and reliability of data used in CECL modeling and reporting.
Investigate material or unusual changes in key credit data, such as risk ratings, portfolio mix, balances, and loss activity, in partnership with relevant lines of business.
Prepare CECL reporting packages for the Credit Risk Committee (CRC), ALCO, Finance Committee/Board, and the Risk Board Committee.
Support the annual capital plan development by preparing balance sheet, income, and provision forecasts.
Help develop and document baseline and stress assumptions for loan growth, deposit growth, betas, non-interest income/expense, and credit loss overlays under supervisory and idiosyncratic scenarios.
Assist with stress forecasting, sensitivity analysis, reverse stress testing, and interconnected risk analysis as part of the Capital Planning Working Group deliverables.
Tie CECL outputs into capital stress scenarios, ensuring consistency between reserve forecasts and provision expense projections in the capital plan.
Quantify the capital impact of CECL volatility under adverse macroeconomic conditions to support contingency capital action planning.
Partner with Risk Management on effective-challenge sessions and with Internal Audit on capital planning process reviews and CECL model validation process.
Coordinate with Treasury on liquidity assumptions and ALM/IRR linkages.
Remains cognizant of and adheres to Wings policies and procedures, and regulations pertaining to the Bank Secrecy Act.