Sr. Mortgage Analytics Data Analyst (CHICAGO)

Post Date

Mar 24, 2025

Location

Chicago,
Illinois

ZIP/Postal Code

60607
US
Jul 13, 2025 Insight Global

Job Type

Perm

Category

Data Warehousing

Req #

CHI-770075

Pay Rate

$90k - $130k (estimate)

Job Description

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 youll 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 teams analytical efforts by generating reporting to monitor volumes, quality, performance, and risk of the Banks 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 Banks 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.

We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com. The EEOC "Know Your Rights" Poster is available here.

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Required Skills & Experience

5-10 years of Data Analyst experience
Must be local to Chicago, coming on site Tuesdays Thursdays and they pick the 3rd on site day
Strong background in data analysis in the mortgage industry
Ability to build Tableau reports from scratch
Strong presentation skills on data findings
Write SQL scripts from scratch to access data, dig and edit the scripts when necessary

Nice to Have Skills & Experience

Alteryx

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.