Capital Markets Analyst Ii - Hybrid

Don't let our name scare you, we are not your average bank.
With nearly a century of service, FHLBI is one of 11 independent regional cooperative banks across the U.S. Simply put, we're a bank for banks, credit unions, community development financial institutions and insurers across Indiana and Michigan. As a cooperative, we are dedicated to strengthening communities throughout our region.
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 diversity, equity and inclusion, 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 five fully remote weeks per year!
• 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.

Purpose:
Provide operational and decision-making support to the Bank's Investments group related to asset /liability management, investment acquisition, and compliance with all requisite Bank policies.
The following statements are intended to describe the general nature and level of work being performed by persons assigned to the job. They are not intended to be an exhaustive list of all responsibilities or abilities required of persons so classified. The Bank reserves the right to alter or amend this description at any time.
Specific Responsibilities:
Support Investments group's daily operations:

• Completion of daily analysis of the Bank's whole loan mortgage portfolio, including mortgage loan pricing, specified pool payups, income simulation, and Option Adjusted Spread analysis
• Completion of daily analysis for the Mortgage-Backed Securities portfolio, such as trade capacity calculations, monitoring of MBS hedged with interest rate swaps, and trade processing/documentation
• Trade processing for the Bank's short-term portfolio, including Fed Funds, repurchase agreements, and deposits
• Support enhanced monitoring of the Bank's short-term counterparties and intraday unsecured exposures

Responsible for reporting related to the mortgage portfolios and the short-term portfolio to Bank management committees and the Board of Directors:

• Capital Markets Strategies Report to the Bank's Capital Markets Committee
• Market and Balance Sheet Data to the Bank's Asset Liability Committee
• Financial Management Report to the Board of Directors

Support Capital Markets OMWI reporting processes:

• Quarterly Data Reporting to FHFA
• ODEI Metrics report to the Board of Directors
• OMWI Annual Report and Strategic Plan Dashboard

Support configuration, testing, and implementation of the Mortgage-Backed Securities and Short-Term portfolio modernization projects, including necessary updates to Calypso, Data Warehouse, and/or other technology platforms purchased to support these initiatives:

• Test system trade capture and ensure workflow supports a SOX 404 style control environment
• Test system's ability to calculate pre-trade investment compliance and prevent non-compliant trades from being entered
• Work with IT to develop and test reporting capabilities out of new systems

Competencies:
Business

• Job Knowledge

General

• Decision Making/Judgment
• Dependability
• Productivity

People

• Communication

Position Requirements:

• BS with concentration in Finance, Economics, Accounting, or related field.
• 0 - 3 years of experience working in a financial institution.
• Excellent analytical and communication skills.
• Extensive knowledge of Microsoft Office Applications including Excel, PowerPoint, Access, Teams, and Word.
• Experience with Python, Bloomberg, PolyPaths, Calypso, or mortgage prepayment/default models preferred.
• Exceptional attention to detail while coordinating multiple tasks simultaneously.
• Must not have been convicted on any civil or criminal charge that would suggest a risk to Bank security.
• Ability to work full time.
• Ability to uphold and model the Bank's Guiding Principles

FHLBank is an Equal Opportunity Employer.