Sql Financial Analyst Virtual Jobs in Iowa (NOW HIRING)

At FHLB Des Moines, we work each day to develop an inclusive culture that supports and leverages the complexity of a diverse workforce. This enables us to effectively serve the needs of our members and help them succeed.

The Senior Capital Markets Analyst position performs quantitative analytics used to effectively execute the Bank's portfolio management, asset liability management, mortgage loan origination, debt issuance, and liquidity management strategies. This role assesses strategic opportunities and risks identified within the Bank's profitability and cash flow forecasting process, interest rate and prepayment modeling and/or mortgage pricing models, and evaluates the impact of various interest rate scenarios and market conditions. This role is a key contributor in the development, implementation, and cross-departmental coordination of value-add quantitative analytical activities that drive the Capital Markets division's forward-looking decision-making process, pricing models, hedging strategies, and overall balance sheet and portfolio management.

Accountabilities:

Key Responsibilities:

• Perform quantitative analytics used in balance sheet management, portfolio management and pricing models, including mortgage pricing and prepayment modeling, balance sheet funding and hedging, liquidity management and/or income forecasting
• Develop analytical methods and models that measure and analyze the Bank's exposure to changes in interest rates and other market and business factors under numerous scenarios
• Understand key drivers of risks including interest rate, prepayment, liquidity, capital management, and income risks and provide forward-looking recommendations to improve financial performance
• Analyze and recommend hedging strategies for the Bank's mortgage loan portfolio, including the mortgage pipeline
• Analyze market, housing and macro-economic trends and collaborate with internal traders and external sell-side institutions to obtain relevant market information
• Conduct research and financial analysis using fixed income analytics tools such as Polypaths, Principia, and Quantitative Risk Management (QRM)
• Assess model performance and develop quantitative analysis to recommend and support changes, as appropriate
• Implement and maintain asset and liability modeling systems to ensure the utilization of the best analytics systems for the Bank
• Research, design and implement new quantitative models and reports
• Manage, develop, and implement efficiencies and effective controls related to departmental EUC's, models, processes related to portfolio management, asset liability management, mortgage loan origination, and debt issuance
• Represent the Capital Markets Team in Bank-wide projects while gathering key requirements, coordinating cross- department initiatives, performing appropriate testing, finding solutions, and obtaining model validation
• Develop, enhance, and present committee reports for various senior management and Board committees
• Other duties and projects as assigned

Requirements:

• Bachelor's degree in finance, economics, mathematics, statistics or other quantitative/computing fields
• At least 2-3 years of experience related to balance sheet management, fixed income, complex financial instruments such as mortgages or derivatives, or financial modeling and reporting
• Advanced degree (Masters) or CFA charter holder or similar certification preferred
• Highly proficient computer skills in Excel, Word, and Visual Basic
• Experience running ALM, capital markets, balance sheet management and/or other financial software preferred, such as QRM or Polypaths
• Experience with scripting/programming languages such as SQL, R or Python preferred
• Experience with dashboard tools such as Power BI preferred
• Strong interpersonal and communication (both written and verbal) skills that allow proactive working relationships in a team-oriented environment
• Excellent ability to effectively prioritize work and meet deadlines
• Excellent attention to detail with robust analytical, decision-making, and problem solving skills

Compensation Range:

Annual Salary: $102,210.00 - $121,374.00

This salary range represents the Bank's good faith and reasonable estimate of possible compensation at the time of hire. Offer to be determined by selected applicant's education, experience, knowledge, skills & abilities, as well as internal equity and alignment with market data.This role is also eligible to participate in the Bank's annual incentive plan.
As part of our competitive Total Rewards package, the Bank offers 11 paid holidays, 5 weeks of PTO and a work culture that values work/life balance. Most roles are eligible for our hybrid work schedule. We match 100% of the first 6% you contribute to your 401(k) and provide an additional 4% non-discretionary contribution to your 401(k) at the end of year. More information on our Total Rewards program can be found here.

At FHLB Des Moines, we work to create an inclusive culture. This enables us to effectively serve the needs of our members and help them succeed. FHLB Des Moines is proud to be an Equal Opportunity Employer. We prohibit discrimination on the basis of race, color, religion, sex (including pregnancy, sexual orientation or gender identity), national origin, age, disability, veteran status, genetic information (including family medical history), status as a parent or any other characteristic protected by federal, state or local law.