Senior Data Analyst, Mortgage Analytics & Insights

The Federal Home Loan Bank of Chicago; Chicago (IL); Hybrid; USD 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a Senior Data Analyst to join their dynamic team. In this role, you will analyze mortgage-related data and provide insights that drive strategic decisions. You will create compelling dashboards and reports, ensuring stakeholders are well-informed on trends and risks. This innovative firm offers a hybrid working model and a comprehensive benefits package, including a competitive PTO plan and a supportive work environment focused on employee growth. If you're passionate about data analytics and looking to make a significant impact, this opportunity is for you.

Benefits

401k and Pension

Medical, Dental and Vision Insurance

Lifestyle Spending Account

Competitive PTO Plan

11 Paid Holidays

Hybrid Working Model

Qualifications

• 3-5 years of experience in data analysis or analytical reporting.
• Direct experience with mortgage loan portfolios is preferred.

Responsibilities

• Analyze mortgage-related data to drive informed decision making.
• Create and maintain dashboards and reports to visualize key metrics.

Skills

Data Analysis

Problem-Solving

Communication Skills

Attention to Detail

Continuous Learning

Education

Bachelor's in Data Science

Bachelor's in Business

Bachelor's in Economics

Tools

Tableau

SQL

Microsoft Excel

Microsoft PowerPoint

Microsoft Word

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.

• Retirement program (401k and Pension)

• Medical, dental and vision insurance

• Lifestyle Spending Account

• Competitive PTO plan

• 11 paid holidays per year

• Hybrid working model

Visit FHLBCbenefits.com for additional details about our benefits.

Who we are:

FHLBank Chicago partners with our members in Illinois and Wisconsin to provide them competitively priced funding, a reasonable return on their investment in the Bank, and support for their community investment activities. We are one of 11 Federal Home Loan Banks created by Congress in 1932 as a government sponsored enterprise to support mortgage lending and community investment. We are member owned and member focused. Our members include banks, credit unions, insurance companies and CDFIs.

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.

What you'll do:

In this role you will play a critical role in analyzing mortgage-related data to drive informed, data-driven decision making and ensure Mortgage Partnership Finance (MPF) stakeholders are well informed on the trends and risks within the program.

How you'll make an impact:

• The Senior Data Analyst, Mortgage Analytics & Insights will work on discovering and extracting valuable insights, identifying trends, and streamlining the current reporting suite for both Chicago and all MPF stakeholders.

• The information provided will equip senior leaders and management with the necessary understanding of key issues and risks in the mortgage industry, enabling them to move the program forward successfully.

What you can expect:

• Support the team's analytical efforts by generating reporting to monitor volumes, quality, performance, and risk of the Bank's national whole loan mortgage portfolio.

• Create and maintain compelling dashboards and comprehensive reports to visualize key metrics and communicate insights effectively.

• Extract, manipulate, and analyze complex data sets to perform detailed analysis on the Bank's mortgage portfolio, products, and participating financial institutions

• Design and maintain automated processes for data extraction and transformation to create operational efficiencies.

• Implement consistent data quality checks through data validation and maintenance

• Conduct ad-hoc analysis and present findings to address specific business initiatives and challenges.

• Support key regulatory requirements and data requests.

• Stay updated on industry trends, best practices, and emerging technologies in both the mortgage space, data analytics, and business intelligence.

• Collaborate with team members and cross-functional teams to address business needs and refine operational processes.

What you'll bring:

• Bachelor's degree with an emphasis in data science, business, economics, or related field.

• 3-5 years of data analysis or analytical reporting experience.

• Direct experience analyzing mortgage loan portfolios or mortgage-backed securities preferred.

• Strong analytical and problem-solving skills with high attention to detail.

• Continuous learner with an inclination to understand the "why".

• Self-motivated to drive results by collaborating and building relationships with peers, leaders, and stakeholders.

• Ability to prioritize work and meet deadlines in a fast-paced work environment with multiple objectives.

• Strong communication skills (written, verbal, and listening) are required.

• Experience with data visualization tools, such as Tableau required.

• Experience with SQL or other coding languages a plus.

• Microsoft Office (PowerPoint, Excel, Word) proficiency required.

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. #LI-Hybrid