Lead Treasury Analyst – IRR Forecasting, Analytics

Jobtailor; Illinois; On-site; USD 90,000 - 140,000; Full time

Job summary

Jobtailor in Illinois seeks an experienced Treasury/ALM Analyst to support interest rate risk management, forecast IRR metrics, and perform model runs for risk assessment. You will model the balance sheet in QRM to analyze funding, liquidity, and capital while collaborating with data teams to improve inputs and automation.

You will apply Python and SQL for automation, conduct sensitivity tests, and present insights with strong storytelling to drive strategic discussions on hedging and balance

Qualifications

• 2+ years of banking or financial services experience with exposure to ALM or IRR
• Strong financial modeling and analytical skills, with the ability to work with complex models
• Bachelor’s Degree in Finance, Economics, Mathematics, or related field
• Advanced Excel skills with experience in quantitative analysis
• Experience with ALM platforms such as QRM or Empyrean
• Experience enhancing or supporting modeling environments and data integration
• Experience with Python, SQL, or similar tools for data analysis and automation
• Experience with financial reporting systems (e.g., Workday, Essbase)
• Exposure to presenting analytical results and developing storytelling skills
• Strong teamwork, organization, and ability to manage multiple priorities
• Problem-solving mindset with focus on continuous improvement
• Strong analytical curiosity and interest in Treasury and quantitative risk management
• Ability to break down complex models and communicate insights clearly

Responsibilities

• Support interest rate risk management and forecast IRR metrics, including exposure measurement, hedging analysis, and stress testing
• Execute portions of the monthly IRR production process, including model runs, input validation, and output analysis
• Model the balance sheet in QRM to support interest rate risk, funding, liquidity, and capital analysis
• Partner with data and technology teams to support model inputs and improve process execution
• Evaluate and sensitivity test key model assumptions and assess impact on results
• Perform detailed post-model analysis using Excel and other tools to interpret trends and drivers
• Support validation of new data sources and framework enhancements
• Identify and implement automation opportunities using Python, SQL, or similar tools
• Ensure appropriate documentation and adherence to internal controls
• Work with oversight groups and participate in governance routines
• Participate in the Treasury Strategy Committee (ALCO subcommittee)
• Maintain awareness of market and economic conditions and reflect insights in analysis
• Drive process improvements and identify efficiency opportunities
• Create clear, concise presentation materials that translate complex outputs into business insights
• Present results and key drivers, clearly communicating risks and implications
• Support strategy discussions around hedging and balance sheet management
• Enhance reporting through improved visualization and usability

Skills

ALM cash flow forecasting

Financial modeling

Python data analysis

Advanced Excel skills

Data analysis

Automation

Quantitative analysis

Modeling environments

Financial reporting systems

Workday

Essbase

Education

Bachelor’s Degree in Finance/Economics/Mathematics

Tools

QRM

Empyrean

Python

SQL

Excel

Workday

Essbase

Job description

• Support interest rate risk management and forecast IRR metrics, including exposure measurement, hedging analysis, and stress testing
• Execute portions of the monthly IRR production process, including model runs, input validation, and output analysis
• Model the balance sheet in QRM to support interest rate risk, funding, liquidity, and capital analysis
• Partner with data and technology teams to support model inputs and improve process execution
• Evaluate and sensitivity test key model assumptions and assess impact on results
• Perform detailed post-model analysis using Excel and other tools to interpret trends and drivers
• Support validation of new data sources and framework enhancements
• Identify and implement automation opportunities using Python, SQL, or similar tools
• Ensure appropriate documentation and adherence to internal controls
• Work with oversight groups and participate in governance routines
• Participate in the Treasury Strategy Committee (ALCO subcommittee)
• Maintain awareness of market and economic conditions and reflect insights in analysis
• Drive process improvements and identify efficiency opportunities
• Create clear, concise presentation materials that translate complex outputs into business insights
• Present results and key drivers, clearly communicating risks and implications
• Support strategy discussions around hedging and balance sheet management
• Enhance reporting through improved visualization and usability

Requirements

• Strong knowledge of ALM cash flow forecasting and valuation software (QRM or similar)
• 2 or more years of banking or financial services experience with exposure to ALM or IRR
• Strong financial modeling and analytical skills, with the ability to work with complex models
• Bachelor’s Degree required; preferred background in Finance, Economics, Mathematics, or related field
• Advanced Excel skills with experience in quantitative analysis
• Strong communication skills with the ability to simplify complex concepts
• Experience with ALM platforms such as QRM or Empyrean
• Experience enhancing or supporting modeling environments and data integration
• Experience with Python, SQL, or similar tools for data analysis and automation
• Experience with financial reporting systems (e.g., Workday, Essbase)
• Exposure to presenting analytical results, with strong interest in developing storytelling skills
• Strong teamwork, organization, and ability to manage multiple priorities
• Problem-solving mindset with focus on continuous improvement
• Strong analytical curiosity and interest in Treasury and quantitative risk management
• Ability to break down complex models and communicate insights clearly

Core Competencies

Demonstrates strong expertise in Interest Rate Risk Management, Financial Modeling, and ALM cash flow forecasting using QRM. Proficient in data analysis and automation with Python and SQL, while effectively communicating complex financial insights.

Highest-signal resume keywords

• Interest Rate Risk Management
• Financial Modeling
• ALM Cash Flow Forecasting
• Python Data Analysis
• Advanced Excel Skills

ATS Optimization Keywords

Hard Skills

• Interest Rate Risk Management
• Financial Modeling
• ALM Cash Flow Forecasting
• Data Analysis
• Automation
• Quantitative Analysis
• Modeling Environments
• Financial Reporting Systems
• Sensitivity Testing
• Documentation

Soft Skills

• Strong Communication Skills
• Teamwork
• Organization
• Problem-Solving Mindset
• Analytical Curiosity

Industry Keywords

• Banking
• Financial Services
• Treasury
• Quantitative Risk Management
• Governance

Tools & Technologies

• QRM
• Empyrean
• Python
• SQL
• Excel
• Workday
• Essbase