Data Analyst - Mortgage Analytics & Insight

Company: Federal Home Loan Bank of Chicago
Location: Chicago
Posted on: February 13, 2025

Job Description:

Join the FHLBC team!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
• Generous PTO plan
• 11 paid holidays per year
• Hybrid working modelWho we areOur 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 hereAt FHLBank Chicago, we bring people together. Our regular All-Staff meetings keep employees informed and our values drive the work that we do. Our Buddy Program pairs new hires with tenured employees to guide their onboarding. Through our Office of Diversity, Equity and Inclusion (DEI), we host signature and employee-led events to celebrate our differences and learn from each other and identify volunteer opportunities to strengthen our communities; and Employee Resource Groups (ERGs) and culture teams create connections around shared interests and experiences. We offer live and on-demand professional development opportunities to grow your skillset and your career.What You'll doThe Data Analyst, Mortgage Analytics & Insights 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:
  • Extract valuable insights, identify trends, and enhance reporting processes for strategic business initiatives related to the national whole loan mortgage purchase program (Mortgage Partnership Finance-MPF)
  • Use business intelligence and data visualization tools to develop in-depth analytics for internal and external stakeholders to assess evolving business needs and achieve strategic objectives.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 (PFIs).
    • 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.
      • 0-2 years 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, preferred.
      • Experience with SQL or other coding languages a plus.
      • Microsoft Office (PowerPoint, Excel, Word) proficiency requiredThe PerksAt 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 generous 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. Step into a brighter future with us. #LI-Hybrid

Keywords: Federal Home Loan Bank of Chicago, Chicago , Data Analyst - Mortgage Analytics & Insight, Professions , Chicago, Illinois