ALM and Financial Forecasting Analyst II

Federal Home Loan Bank of Indianapolis•Indianapolis, IN

2d•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, with a focus on financial forecasting, income simulation, fixed-income analysis, and what-if analysis. The role combines process execution, financial analysis, data management, reporting, documentation, and technology, and offers an opportunity to develop understanding of fixed-income instruments, financial performance, model assumptions, and the interaction between market conditions and projected results. The position is part of the Enterprise Risk Management department, which identifies, measures, monitors, and reports organizational risk. The analyst supports financial forecasting, income simulation, and market risk reporting; researches changes in projected results; maintains and improves forecasting and reporting systems; collaborates with stakeholders; supports model validation and development; and helps ensure regulatory compliance. The role is expected to stay current with analytical techniques and trends in market risk management and to help implement new analytical capabilities. The position follows a hybrid workforce model, with three days per week onsite and two days remote. The Bank also offers remote flex days. The hiring range is $85,000–$100,000, excluding annual incentive opportunities and the value of retirement, health, welfare, and other ancillary benefits.

Requirements

Master’s degree in Mathematics, Quantitative Analysis, Statistics, Financial Engineering, or another quantitative field; alternatively, a Finance or Economics master’s degree with a background or focus in Mathematics, Statistics, Quantitative Analysis, or Engineering.
One year of experience, which may include graduate research assistant work, performing 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.
High degree of interest in fixed income, derivatives, balance sheet analysis, and valuation analysis.
Detail-oriented and flexible in supporting management and regulatory reporting.
Ability to prioritize 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 certifications 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 on pro-forma projections, risk analytics, data issues, market information, risk modeling, and testing and implementation of models and systems.
Perform or assist with ad-hoc analyses in a timely manner.
Support review of financial forecasting and income simulation results using quantitative tools.
Assist with maintenance, improvement, and automation of the financial forecasting and reporting environment, including spreadsheets, databases, scripts, SQL queries, reporting tools, testing processes, and redesign efforts.
Maintain ongoing 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 review, 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 clear documentation on market risk processes and controls to meet Model Risk Management Group standards and regulatory FHFA modeling Advisory Bulletins.
Stay current with technical enhancements, methodologies, statistical, mathematical, analytical, and computational techniques, and market risk management trends.
Research, understand, and implement next-generation analytical capabilities in Enterprise Risk Management and market risk core functions to support risk management understanding, regulatory testing, and lines of business needs.

Benefits

Flexible hybrid workforce model: onsite three days a week and remote two days a week, with remote flex days.
Competitive pay and total rewards.
401(k) match of 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 Bank pays employees to volunteer.
Summer hours program.
Dress-for-your-day dress code.