> Markdown version of [/jobs/ext/2661461-data-reporting-analyst-for-post-closing-systems-management-analyst-3](https://www.wearedevelopers.com/jobs/ext/2661461-data-reporting-analyst-for-post-closing-systems-management-analyst-3). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data & Reporting Analyst for Post-Closing Systems / Management Analyst 3 - **Company:** State of Minnesota - **Location:** Saint Paul, MN, United States (Remote available) - **Experience:** Experienced - **Salary:** $59,800.0 - $87,693.0 - **Contract:** Permanent contract - **Skills:** Microsoft Access, Microsoft Excel, Business Analytics Applications, Data Analysis, Information Systems, Databases, Data Auditing, Data Governance, Data Integrity, Extract Transform Load (ETL), Data Mining, Relational Databases, Document-Oriented Databases, Enterprise Content Management, Python (Programming Language), Meta-Data Management, Microsoft Office, Pivot Tables, Power BI, SQL Databases, Tableau (Software), Link Control Protocol, Freeform SQL, Powerquery, Vba Programming Language, Data Management, Tools for Reporting, Data Pipelines, Custom Reports - **Published:** August 2, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=1b5948a2891f6b2d ## About the Role * 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. ## Description 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 ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)