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 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.
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 opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their 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 or uniformed service member status, 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.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 or loan 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 1st 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.