"Alerted.org

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 Human Resources Request Form (https://airtable.com/app21VjYyxLDIX0ez/shrOg4IQS1J6dRiMo) . The EEOC "Know Your Rights" Poster is available here (https://www.eeoc.gov/sites/default/files/2023-06/22-088\_EEOC\_KnowYourRights6.12ScreenRdr.pdf) .

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/ .

Skills and Requirements

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 Alteryx null

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].