ALM and Financial Forecasting Analyst II

Federal Home Loan Bank of Indianapolis•Indianapolis, IN

22h•$85,000 - $100,000•Hybrid

About The Position

The ERM, ALM and Financial Forecasting Analyst II provides financial and analytical information to bank management to support risk- and business-related decision-making. The role focuses on financial forecasting, income simulation, fixed-income analysis, and what-if analysis, combining process execution, financial analysis, data management, reporting, documentation, and technology. It offers the opportunity to develop understanding of fixed-income instruments, financial performance, model assumptions, and how market conditions affect projected results. The position is part of the Enterprise Risk Management department, which identifies, measures, monitors, and reports organizational risk levels and trends. The analyst supports financial forecasting, income simulation, and market-risk reporting; analyzes model assumptions and market conditions; and helps maintain and improve forecasting and reporting systems. The role also supports model validation and development, collaborates with stakeholders, documents processes and controls, and responds to regulatory reviews. The position follows a hybrid workforce model, with three days onsite and two days remote each week, plus remote flex days. The stated hiring range is $85,000–$100,000 in base salary; annual incentive opportunities and benefits are not included in that range.

Requirements

Master’s degree in Mathematics, Quantitative Analysis, Statistics, Financial Engineering, or another quantitative field; alternatively, a Master’s degree in Finance or Economics with a background or focus in Mathematics, Statistics, Quantitative Analysis, or Engineering.
One year of experience, which may include graduate research-assistant work, in quantitative risk or related analysis or research in quantitative finance, applied mathematics, optimization or mathematical programming, fixed-income analysis, or econometrics.
Experience with at least one of the following languages or applications: Python, VBA, SQL/T-SQL, R, PowerBI, Microsoft Fabric, Scala, MATLAB, Javascript, SAS, Stata, SPSS, or C/C++/C#.
Demonstrated curiosity and interest in fixed income, financial performance, forecasting, data, and what-if analysis.
Advanced analytical skills to develop and support complex financial, quantitative, and market-risk reports and analyses.
Ability to identify potential concerns, analyze and solve problems, and work effectively and independently to resolve issues.
Strong interest in fixed income, derivatives, balance-sheet analysis, and valuation analysis.
Detail-oriented and flexible in supporting management and regulatory reporting.
Ability to prioritize multiple competing objectives with initiative and independence.
Ability to work as required to meet deadlines.
Verbal, written, and interpersonal skills to communicate effectively with all levels of Bank personnel.
Must not have been convicted of a civil or criminal charge that would suggest a risk to bank security.
Ability to work full-time, with three days per week in the office and two days remote.
Ability to uphold and model the Bank’s Guiding Principles.

Nice To Haves

Experience with asset/liability and valuation software or models such as Polypaths, QRM, ZMDesk, or Principia.
Strong understanding of fixed-income principles, including mortgage-backed securities and derivatives.
Professional certification such as CFA (Chartered Financial Analyst), FRM (Financial Risk Manager), or PRM (Professional Risk Manager).
Experience with Git/GitHub or another version-control and code-collaboration platform.

Responsibilities

Support production of financial forecasting, income simulation, and market-risk reporting, including data preparation, model execution, reconciliations, balance-sheet and income-statement forecasting, balance-sheet risk analysis, stress testing, sensitivity analysis, and analysis of fixed-income instruments and derivatives.
Produce timely, accurate, and relevant reporting.
Research changes in projected results and evaluate the effects of model assumptions and market conditions; prepare information explaining changes in financial performance.
Serve as a resource for pro forma projections, risk analytics, data issues, market information, risk modeling, testing, and implementation of new models and systems.
Perform or assist with ad hoc analyses and support quantitative review of financial forecasting and income simulation results.
Maintain, improve, and automate the financial forecasting and reporting environment, including spreadsheets, databases, scripts, SQL queries, reporting tools, testing processes, and redesign efforts.
Maintain processes related to model changes, validation recommendations, and remediation activities.
Communicate technical details about market-risk management and model assumptions to management, team members, and supporting staff across the organization.
Participate in model and reporting enhancements, assumption reviews, user acceptance testing, and output validation.
Document operational changes, model results and behaviors, and identified issues.
Interact with market-risk validators and other reviewers regarding forecasting and market-risk processes, controls, and documentation, demonstrating adherence to applicable regulations and internal policies.
Write documentation on market-risk processes and controls in accordance with Model Risk Management Group standards and FHFA modeling Advisory Bulletins.
Stay current with technical enhancements, methodologies, analytical and computational techniques, and market-risk management trends; research, understand, and implement next-generation analytical capabilities in Enterprise Risk Management and market-risk functions.

Benefits

Flexible hybrid workforce model with three onsite days and two remote days per week, plus remote flex days.
Competitive pay and total rewards.
401(k) match up to 6%, plus an additional 4% contribution.
Tuition reimbursement assistance.
Student loan repayment assistance.
Medical, dental, and vision benefits.
Pet insurance.
Vacation and paid federal holidays.
Birthday-month floating holiday.
Volunteer day; the company also says it pays employees to volunteer.
Summer hours program.
“Dress for your day” dress code.