Data & Reporting Analyst for Post-Closing Systems / Management Analyst 3

Minnesota Housing is hiring! We’re a mission-focused financial institution looking for a Data and Reporting Analyst for Post-Closing Systems position to serve as the division’s subject matter expert for post-closing data and reporting systems that support construction administration, compliance, loan servicing, and asset management. The role exists to ensure data accuracy, integrity, and usability, supporting critical decision-making and operational efficiency within the Multifamily division while improving reporting processes and system use. This role offers the opportunity to work collaboratively across teams, solve complex data challenges, and make a significant impact by optimizing data management and reporting processes. It’s ideal for someone passionate about transforming raw data into actionable insights and driving organizational success., * Serve as SME for post-closing systems including PORT, MHFA Tracker, LCP Tracker, and related reporting tools, ensuring data integrity and consistent use across the division.

• Conduct complex data extraction, validation, and analysis using SQL, Python, Access, Excel, and Power BI to support compliance, servicing, asset management, and internal reporting.
• Lead preparation of repeatable datasets and submissions for Moody’s, NCSHA, and other external reports; coordinate timelines and reconcile data with PRE, Finance, and program teams.
• Respond to data practices requests, ensuring accurate, timely, audit-ready datasets and adherence to privacy and data governance requirements.
• Maintain and enhance analytical tools, including Access databases, Excel tools, and Power BI dashboards; provide user support and training.
• Document data structures, definitions, lineage, and authoritative sources; identify and resolve system or data issues and recommend workflow or reporting improvements.
• Partner closely with the pre-closing Multifamily Data & Reporting Analyst to ensure lifecycle alignment, standardized reporting methods, and redundancy in critical reporting functions.
• Perform other duties as assigned., * A voluntary confidential program that helps employees and their families with life challenges that may impact overall health, personal well-being, or job performance
• Common sources of stress can be addressed through the EAP: mental health, relationship challenges (personal and work), grief and loss, finances, and legal issues
• Daily Living/Convenience Services: Chore services, home repair, trip planning, child/elder care

• Two (2) years of professional experience in data analysis, data stewardship, and reporting, including advanced use of SQL for data auditing, complex query development, and Extract, Transform, Load (ETL) processes across multiple relational databases.
• A Bachelor’s degree in Data Science, Statistics, Information Systems, may substitute for 12 months of experience - or - a Associate’s degree in the listed fields may substitute for 6 months of experience
• Demonstrated expertise in report design and development, including authoring complex SQL queries, creating dynamic, automated dashboards using business intelligence tools such as Power BI, Tableau, or an equivalent enterprise-grade reporting platform, and optimizing reports for non-technical audiences.
• Advanced proficiency in Microsoft Access including creating and maintaining complex workbooks with dynamic formulas, pivot tables, Power Query, and VBA scripting, as well as developing tools and templates that automate data extraction and aggregation processes from multiple file types and systems.
• Strong analytical and critical thinking skills, with a demonstrated ability to diagnose data discrepancies, identify root causes, implement corrective actions, and enhance data processing workflows for scalability and long-term integrity.
• Excellent communication and collaboration skills, with a proven ability to act as a liaison between business and technical teams. This includes translating business needs into technical requirements for developers and translating complex data concepts into actionable insights for non-technical stakeholders.
• Knowledge of data privacy, confidentiality, and governance principle, * Experience with lifecycle data needs for construction administration, compliance, loan servicing, and asset management.
• Ability to design or refine reporting workflows, automate processes, and recommend system improvements.
• Hands-on experience leveraging enterprise content management (ECM) systems to execute structured document processing workflows, metadata management, and enterprise data governance initiatives, ensuring content compliance and alignment with organizational data policies.
• Experience coordinating or supporting data practices requests, including delivering narrative explanations and audit-ready documentation.
• Demonstrated cultural competency and commitment to equity, with a proven ability to collaborate effectively with individuals and communities from diverse backgrounds, integrate cultural considerations into data practices, and ensure data processes support equitable outcomes in program delivery and decision-making.

Physical Requirements

Requires moving office items such as file folders and small office tools. A certain amount of walking and standing is often necessary in carrying out job duties.

Additional Requirements

This position requires successful completion of the following:

• Reference Checks.
• Job related background checks.
• Conflict of Interest Disclosure.

Pulled from the full job description

• Loan forgiveness
• Tuition reimbursement
• Paid parental leave
• Health insurance
• Vision insurance
• Dental insurance
• Flexible spending account, * Candidates residing in Minnesota within 50 miles of our St Paul office may be eligible to telework up to 50%.
• Candidates residing in Minnesota and more than 50 miles from our office may be eligible to telework more than 50%.
• Candidates residing in Wisconsin within 50 miles of our office may be eligible to telework up to 50%.
• Candidates who do not reside in Minnesota or within 50 miles of the office in Wisconsin are not eligible to be hired, unless planning to relocate within 50 miles of the office., As an employee, you’ll have access to one of the most affordable health insurance plans in Minnesota, along with other benefits to help you and your family be well.

Your benefits may include:

• Paid vacation and sick leave
• 12 paid holidays each year
• Low-cost medical, dental, vision, and prescription drug plans
• Fertility care, including IVF
• Diabetes care
• Dental and orthodontic care for adults and children
• 6 weeks paid leave for parents of newborn or newly adopted children
• Pension plan that provides income when you retire (after working at least three years)
• Employer paid life insurance to provide support for your family in the event of death
• Short-term and long-term disability insurance that can provide income if you are unable to work due to illness or injury
• Tax-free expense accounts for health, dental, and dependent care
• Resources that provide support and promote physical, emotional, social, and financial well-being

Support to help you reach your career goals:

• Training, classes, and professional development
• Student Loan Reimbursement (pilot program)
• Tuition Assistance Program
• Federal Public Service Loan Forgiveness Program (Some positions may qualify for the Public Service Loan Forgiveness Program. For more information, visit the Federal Student Aid website at studentaid.gov)

Employee Assistance Program (EAP) for work/life support

At Minnesota Housing, we know that affordable housing is an essential part of Minnesota’s infrastructure. When you work here, you’re helping to build stronger communities. We have a national reputation as one of the finest housing finance agencies in the country.