Treasury Modeling Analyst III

Job Description

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.

Essential Functions

• CECL Modeling:
  • 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.
• Capital Planning Modeling Support:
  • 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.
  • Cook up liquidity assumptions and ALM/IRR linkages with Treasury.
• Bank Secrecy Act:
  • Remains cognizant of and adheres to Wings policies and procedures, and regulations pertaining to the Bank Secrecy Act.

Qualifications

• Minimum Formal Qualifications for this Position:
  • Bachelor's Degree in Finance, Accounting, Economics, Statistics, Mathematics, or related quantitative field required.
  • Master's Degree in Business Administration or similar preferred.
  • 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.
• Technical Or Specialized Knowledge/Skills:
  • 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.
  • Demonstrated experience executing or supporting a CECL/ACL model in production (preferred).
  • Working knowledge of ASC 326 (CECL), the interagency policy statement on the ACL, and NCUA Part 702 Subpart C capital planning and stress testing requirements (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).

Additional Information

PAY RANGE: $49 to $57 per Hour (S17), plus 15% annual target bonus. Final compensation for this position will be determined by various factors such as relevant work experience, specific skills and competencies, education, certifications, location and internal pay equity.

Benefits:

• Generous 401(k) match
• Discretionary Profit Sharing
• Health Insurance
• Dental Insurance
• Vision Insurance
• Life Insurance
• Short Term and Long Term Disability
• Health Savings Account with company contribution
• Employee Assistance Program
• Paid Vacation, Sick, Floating Holidays and Volunteer Time Off
• Paid Holidays
• Tuition Reimbursement
• Paid Parental Leave

We anticipate this position to close on 07/20/2026. Please submit your application at your earliest convenience to be considered.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities.