Sr Data Analyst Mortgage Analytics & Insights

FHLBank Chicago; Chicago (IL); On-site; USD 90,000 - 151,000; Full time

Benefits offered by this job

401(k) and Pension

Medical, dental and vision insurance

Lifestyle Spending Account

PTO 5 weeks

11 paid holidays

Job summary

FHLBank Chicago is seeking a Senior Data Analyst to transform complex mortgage and business data into actionable insights. This role supports MPF leadership with portfolio analysis, risk monitoring, forecasting, and data-driven recommendations.

You will develop dashboards, monitor performance, and collaborate with Risk, Finance, BI, Data Management, and Mortgage Operations to drive strategic decisions across the MPF program.

Qualifications

• Bachelor’s degree in a quantitative field.
• 4+ years in data analytics, BI, or financial analysis.
• Direct mortgage portfolio or housing finance experience preferred.
• Strong analytical and problem-solving capabilities with attention to detail.
• Translate large datasets into actionable insights and recommendations.
• Strong business acumen and strategic thinking.
• Intellectual curiosity to understand business drivers.
• Advanced SQL skills required.
• Advanced dashboarding and data visualization in Tableau/Power BI.
• Experience with Python, R, SAS preferred.
• Familiarity with AI or automation techniques is a plus.
• Proficiency in Excel, PowerPoint, Word.
• Excellent written and verbal communication; senior stakeholder presentations.
• Ability to communicate with both technical and non-technical audiences.
• Strong stakeholder management and multi-priority focus.
• Self-motivated and collaborative.

Responsibilities

• Identify trends, portfolio risks, and opportunities through advanced analysis of mortgage data.
• Develop scalable analytical solutions, dashboards, and performance metrics.
• Deliver insights to improve portfolio performance and risk oversight.
• Lead portfolio monitoring frameworks and advanced analyses for MPF.
• Analyze large mortgage datasets to support strategic initiatives.
• Design executive dashboards and visualizations for leadership.
• Automate data analyses, reporting workflows, and governance practices.
• Collaborate with Risk, Finance, BI, Data Management, and Mortgage Operations.
• Stay current on mortgage industry developments and analytics methods.

Skills

Advanced SQL

Analytical thinking

Communication

Stakeholder management

Problem-solving

Attention to detail

Time management

Business acumen

Education

Bachelor’s degree in Data Science, Business Analytics, Economics, Finance, Statistics, Mathematics, Computer Science, or related quantitative field

Tools

Tableau

Power BI

Python

R

SAS

Excel

Job description

At the Federal Home Loan Bank of Chicago, employees come first - that's why we offer a highly competitive compensation and bonus package, and access to a comprehensive benefits program designed to meet the needs of our employees.

• Collaborative, in-office operating model
• Retirement program (401k and Pension)
• Medical, dental and vision insurance
• Lifestyle Spending Account
• Competitive PTO plan

11 paid holidays per year

Who we are

Our mission at FHLBank Chicago: To partner with our members in Illinois and Wisconsin to provide them competitively priced funding, a reasonable return on their investment, and support for their community investment activities.

Simply said, we're a bank for banks and other financial institutions, focused on being a strategic partner for our members and working together to reinvest in our communities, from urban centers to rural areas. Created by Congress in 1932, FHLBank Chicago is one of 11 Federal Home Loan Banks, government sponsored in support of mortgage lending and community investment.

What it’s like to work here

At FHLBank Chicago, we bring people together. We are committed to a high performing, engaged workforce, and to supporting the communities we serve across Illinois and Wisconsin. Our Buddy Program pairs new hires with tenured employees to guide their onboarding. Our professional development and training opportunities through upskilling, mentorship programs, and tuition reimbursement allow employees to grow their career with us. Our collaborative, in-office operating model brings teams together to foster innovation, connection, and shared success. To support balance and flexibility, employees are provided with an allocation of remote days to use as needed throughout the year.

What you’ll do

The Senior Data Analyst serves as a trusted partner to Mortgage Partnership Finance (MPF) leadership by transforming complex mortgage and business data into actionable insights. This role supports strategic decision-making through in-depth portfolio analysis, risk monitoring, performance measurement, forecasting, and data-driven recommendations that enhance the effectiveness of the Bank’s national whole loan mortgage purchase program.

How you’ll make an impact

• Identify emerging trends, portfolio risks, and business opportunities through advanced analysis of mortgage performance and operational data, enabling proactive management of the MPF program.
• Develop scalable analytical solutions, dashboards, and performance measurement frameworks that support strategic decision-making by senior management and external stakeholders.
• Deliver actionable insights and recommendations that improve portfolio performance, strengthen risk oversight, and enhance business outcomes.

What you can expect

Mortgage Portfolio Analytics & Business Insights

• Lead the development of portfolio monitoring frameworks and perform advanced analyses to assess volume, credit performance, operational effectiveness, loan quality, and emerging risks across the MPF portfolio.
• Analyze large, complex mortgage, financial, and operational datasets to identify trends, evaluate portfolio performance, assess risk exposures, and support strategic initiatives.
• Conduct ad hoc and exploratory analyses to address evolving business questions and provide actionable recommendations to leadership.

Reporting & Visualization

• Design and maintain executive-level dashboards, scorecards, and visualizations that communicate complex analytical findings in a clear and compelling manner.
• Develop reporting solutions that provide timely visibility into portfolio performance, operational metrics, PFI activity, and key risk indicators.
• Present analytical findings and recommendations to senior management and stakeholders, translating technical results into business insights.

Data Management & Automation

• Develop automated data analyses, reporting solutions, and analytical workflows that improve efficiency, scalability, and data reliability.
• Extract, transform, validate, and analyze data from multiple internal and external sources to support business and regulatory reporting.
• Establish and maintain data quality standards, validation controls, and governance practices to ensure the accuracy, consistency, and integrity of analytical outputs.
• Identify opportunities to leverage emerging technologies, advanced analytics, and automation to improve business processes and decision support capabilities.

Leadership & Collaboration

• Collaborate with cross-functional teams including Risk, Finance, Business Intelligence, Data Management, Member Services, and Mortgage Operations to address business needs and improve processes.
• Foster a collaborative, data-driven culture by sharing knowledge, and promoting analytical best practices to junior analysts and interns.
• Stay current on mortgage industry developments, housing finance trends, regulatory changes, analytical methodologies, and emerging technologies.

What you’ll bring

• Bachelor’s degree in Data Science, Business Analytics, Economics, Finance, Statistics, Mathematics, Computer Science, or a related quantitative field.
• 4+ years of experience in data analytics, business intelligence, financial analysis, or a related analytical discipline.
• Direct experience analyzing performance and risk of mortgage portfolios, mortgage-backed securities, or housing finance programs is strongly preferred.
• Strong analytical, quantitative, and problem-solving capabilities with exceptional attention to detail.
• Experience translating large, complex datasets into actionable business insights and recommendations.
• Strong business acumen with the ability to connect analytical work to organizational objectives and strategic priorities.
• Intellectual curiosity with a desire to understand underlying business drivers and root causes.
• Advanced SQL skills, including experience querying, transforming, validating, and analyzing large datasets in a business and professional environment are required.
• Advanced dashboarding and data visualization skills, including experience with Tableau, Power BI, or similar business intelligence tools, are strongly preferred.
• Experience using analytical and statistical programming tools such as Python, R, SAS, or similar platforms is strongly preferred.
• Familiarity with advanced analytics, artificial intelligence, or process automation techniques is preferred.
• Advanced proficiency in Microsoft Excel, PowerPoint, and Word is required.
• Excellent written, verbal, presentation, and listening skills.
• Experience preparing senior management-level presentations and data-driven business recommendations.
• Demonstrated ability to communicate effectively with both technical and non-technical audiences.
• Strong stakeholder management skills with the ability to build credibility and influence decisions through objective analysis.
• Self-motivated and collaborative, with a proven ability to manage multiple priorities and meet deadlines in a dynamic environment.

The Perks

At FHLBank Chicago, we believe in rewarding our high performing workforce. We offer a highly competitive compensation and bonus package, and access to a comprehensive benefits program designed to meet the needs of our employees. Our retirement program includes a 401(k) and pension plan. Our wellbeing program supports employees at work and in their personal lives: Our PTO plan provides five weeks of vacation for new employees and 11 paid holidays per year; our Lifestyle Spending Account provides an annual stipend for employees to support wellbeing activities; and our central downtown location at the Old Post Office provides easy access to public transportation and breathtaking views from our award-winning rooftop. Visit FHLBCbenefits.com for additional details about our benefits. Step into a brighter future with us.

Salary Range:

$90,400.00 - $150,700.00

The above represents the expected salary range for this job requisition. Ultimately, in determining your pay, we may also consider your experience, and other job-related factors. In addition to the base salary, we offer a comprehensive benefits package which can be found here: https://hrportal.ehr.com/fhlbc