ALM and Financial Forecasting Analyst II

Is it a Bank? A cooperative? A leader in affordable housing? We are all those things and more! Our core mission at FHLBank Indianapolis is to provide reliable and readily available liquidity to our member institutions to support housing finance and community development. Simply put, we’re a bank for banks, credit unions, community development financial institutions and insurers across Indiana and Michigan. We also assist in meeting the economic and housing needs of communities and families through grants and subsidized advances that support affordable housing and economic development. But enough about us, let’s talk about you. Are you looking for a company that views their employees as their greatest asset? A company that’s dedicated to making a difference in the community? So much so they pay their employees to volunteer? Do you want to join a talented workforce that prioritizes equal opportunity within an inclusive culture, and promotes learning and development, unique skills/ideas, and employee engagement? If you’ve said yes to these questions, then we might be a match! Here is what we offer: Flexible hybrid workforce model: Onsite three days a week and two days remote. We also offer remote flex days! Fantastic, competitive pay and total rewards Industry-high 401(k) match: up to 6% PLUS…an additional 4% contribution! Tuition reimbursement assistance: To help you continue to develop personally and professionally. Student loan repayment assistance: That’s right, we will help you repay outstanding student loans! Awesome Benefits Package: Medical, dental, vision benefits and even pet (you read that right) insurance! Generous time off: Vacation, paid federal holidays, birthday month floating holiday, volunteer day and summer hours program “Dress for your day” dress code: You choose the appropriate work attire based on what your day looks like. Statistics show that it is less likely for some candidates to submit their application if they don't meet all the criteria within the job description. If this is you, we encourage you to give yourself a chance and submit your application anyway, as you may be the perfect match for this role! ​ Purpose : The ERM, ALM and Financial Forecasting Analyst II is responsible for providing 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 position combines process execution, financial analysis, data management, reporting, documentation, and technology. The role provides an opportunity to develop an understanding of fixed-income instruments, financial performance, model assumptions, and the interaction between market conditions and projected results. The role resides in the Enterprise Risk Management department, whose primary focus is identifying, measuring, monitoring, and reporting the level and trends of risk within the organization. The following statements are intended to describe the general nature and level of work being performed by a person in this job. They are not intended to be an exhaustive list of all responsibilities or abilities required. The Bank reserves the right to alter or amend this description at any time. Specific Responsibilities : Risk measurement, monitoring, and reporting: Supports the 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 related to fixed income instruments and derivatives. Produces timely, accurate, and relevant reporting. Market & Portfolio Analysis: Research changes in projected results, evaluating the effects of model assumptions and market conditions, and preparing information used to explain changes in financial performance. Be a key resource for explaining pro-forma projections, new risk analytics, data issues, market information, risk modeling, testing, and implementing new models and systems, etc. Performs or assists in ad-hoc analyses in a timely manner. Supports the review of financial forecasting and income simulation results using quantitative tools. Systems & Data Management: Assists with the maintenance, improvement, and automation of the financial forecasting and reporting environment, including spreadsheets, databases, scripts, SQL queries, reporting tools, testing processes, and redesign efforts intended to improve efficiency, consistency, and control. Maintains ongoing processes related to model changes, validation recommendations, and remediation activities. Stakeholder Collaboration: Clearly communicates technical details related to market risk management and model assumptions to management, team members, and supporting staff across the organization. Model Validation & Development Support: Participates in model and reporting enhancements, assumption review, user acceptance testing, and output validation. Assists with documenting operational changes, model results and behaviors, and identified issues. Regulatory Compliance: Interacts with market risk validators and other reviewers regarding financial forecasting and market risk processes, controls, and documentation, demonstrating adherence to applicable regulations and internal policies. Writes clear documentation on market risk processes and controls to meet standards set by the Model Risk Management Group, as well as regulatory (FHFA) modeling Advisory Bulletins. Continuous Learning: Stays current with technical enhancements, methodologies, statistical, mathematical, and analytical/computational techniques, and trends related to market risk management. Research, understand, and implement next-generation analytical capabilities in Enterprise Risk Management and market risk core functions to support market risk management understanding, regulatory testing, and lines of business needs. Position Requirements : Master’s degree in Mathematics, Quantitative Analysis, Statistics, Financial Engineering, or any other quantitative field. Alternatively, a Finance/Economics Master's with a background or focus on Mathematics/ Statistics/ Quantitative/Engineering. One year of experience (which may include time as a research assistant during graduate studies) doing quantitative risk or related analysis or research in any of the following areas: quantitative finance, applied mathematics, optimization / mathematical programming, fixed income analysis, or econometrics. Experience in 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 necessary to develop and support complex financial, quantitative, and market risk reports and analyses. Strong ability to identify potential concerns, analyze and solve problems; ability to work effectively and independently to resolve such issues. High degree of interest in fixed income, derivatives, balance sheet analysis, and valuation analysis. Detail-oriented and flexible to support management and regulatory reporting. Ability to prioritize multiple competing objectives with a high degree of initiative and independence. Ability to work as required for meeting deadlines. Verbal, written, and interpersonal skills to communicate effectively with all levels of Bank personnel. Must not have been convicted of any civil or criminal charge that would suggest a risk to bank security. Ability to work full-time with three days per week working from the office and two days remote. Ability to uphold and model the Bank’s Guiding Principles. Not required but a plus: Experience with Asset/Liability and valuation software/models such as Polypaths, QRM, ZMDesk, Principia, etc. A 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. Hiring Range: $85,000-$100,000 Hiring ranges reflect the base salary that the Bank reasonably expects to pay for a given role and is not inclusive of annual incentive award opportunities, retirement benefits or the value of other health and welfare or other ancillary benefits. We consider many factors when determining base salaries such as individual background and experience, the competitive environment, education, particular skill set(s), and industry and institutional knowledge. FHLBank Indianapolis is an Equal Opportunity Employer.