St. Paul, MN, 55145, USA
15 hours ago
Data & Reporting Analyst / Management Analyst 3
**Working Title: Data & Reporting Analyst** **Job Class: Management Analyst 3** **Agency: Housing Finance Agency** + **Job ID** : 88186 + **Location** : St. Paul + **Telework Eligible** : Yes, up to 50% of scheduled workdays. Teleworking employees are required to live in Minnesota or within 50 miles of the St. Paul office if in Wisconsin. + **Full/Part Time** : Full-Time + **Regular/Temporary** : Unlimited + **Who May Apply** : Open to all qualified job seekers + **Date Posted** : 08/13/2025 + **Closing Date** : 08/19/2025 + **Division/Unit** : Business Operations + **Days of Work** : Monday - Friday + **Travel Required** : No + **Salary Range:** $27.84 - $40.82 / hourly; $58,129 - $85,232 / annually + **Classified Status** : Classified + **Bargaining Unit/Union** : 214 - MAPE + **Supervisor** : Emily Fulton-Foley + **FLSA Status** : Nonexempt + **Re-Posting** : Yes + Designated in Connect 700 Program for Applicants with Disabilities (https://mn.gov/mmb/careers/diverse-workforce/people-with-disabilities/connect700/) : Yes **This position requires an employee to be onsite at 400 Wabasha Street North, St Paul, Minnesota at least 50% of the time, with some opportunity to perform work from a telework location.** + Telework (https://mn.gov/mmb-stat/policies/1422-telework.pdf) is available on a limited basis. + Only candidates residing in Minnesota or a state bordering Minnesota (Iowa, North Dakota, South Dakota, or Wisconsin) within 50 miles of the work address listed above are eligible for telework. + Candidates residing in Minnesota and more than 50 miles from the primary/principal work address above may be eligible to telework more than 50%. + Candidates residing 50 miles or more from the primary/principal work address in a state bordering Minnesota (Iowa, North Dakota, South Dakota, or Wisconsin) are not eligible to be hired, unless planning to relocate within 50 miles of the work location. **The work you'll do is more than just a job.** At the State of Minnesota, employees play a critical role in developing policies, providing essential services, and working to improve the well-being and quality of life for all Minnesotans. The State of Minnesota is committed to equity and inclusion, and invests in employees by providing benefits, support resources, and training and development opportunities. Minnesota Housing is hiring! We’re a mission-focused financial institution looking for a Data & Reporting Analyst to be a hands-on expert directly serving the business staff! The Data and Reporting Analyst position exists to ensure data accuracy, integrity, and usability, helping tell a clear story that drives our work in providing safe, affordable housing. This role offers the opportunity to work with business staff to collaboratively understand their needs – translating questions into data queries and providing information and insights to make smart decisions. This is a unique opportunity for a motivated and collaborative professional who is just as comfortable writing a complex SQL query as they are teaching business staff on data practices. **Essential Job Duties** + Serve as a key data resource and partner directly with business staff to understand their needs. You'll translate their questions into data queries and provide them with the information and insights they need to make smart decisions. + Be a hands-on data expert, using your advanced SQL skills to manage, audit, and maintain data integrity across multiple systems. + Lead the development and maintenance of data quality control procedures and coordinate Multifamily data stewards to conduct regular data reviews and ensure continuous improvement of data practices. + Develop and maintain reports, queries, and dashboards to analyze trends and present actionable insights to stakeholders. + Provide backup support for Request for Proposals (RFP) application development, including coding, testing, and optimizing solutions. + Execute data requests from internal divisions and external stakeholders, maintaining consistent reporting standards and methods. + Assist with implementing quick wins to improve operational efficiency, including preventing data silos and creating prototypes for one-off tools. + Audit, clean, and standardize large datasets, supporting effective data integration and system compatibility. + Deliver training sessions to business staff on topics related to data quality, integrity, and stewardship, helping to build a more data-literate organization. + Perform other duties as assigned. **Minimum Qualifications** **To be qualified for and considered for this position, applicants must meet all of the minimum qualifications listed below. Ensure that your resume contains descriptions of your work experiences sufficient for comparison against the requirements stated below and indicate the beginning and ending month and year for each job held.** **Only applicants whose resumes clearly demonstrate fulfillment of each of these minimum qualifications will be considered for this position.** + Three (3) years of professional experience in data analysis, data stewardship, or data reporting. This experience must include: + Writing and modifying SQL queries to extract and audit data from relational databases. + Participating in ETL (Extract, Transform, Load) processes or managing data across multiple systems. A bachelor’s degree in Data Science, Statistics, Information Systems, or a related field may substitute for up to 18 months of this experience if the candidate has directly performed professional-level data stewardship work. + Experience working with data governance or data management standards, including: + Cleaning and standardizing data. + Ensuring accuracy and consistency across datasets from multiple sources. + Experience designing or building reports or dashboards using tools such as Power BI, Tableau, or similar platforms, including: + Creating visualizations for non-technical audiences. + Writing SQL-based reports or automating reporting workflows. + Proficiency in Microsoft Excel + Creating and maintaining complex workbooks with dynamic formulas, pivot tables, Power Query, and VBA scripting + Developing tools and templates that automate data extraction and aggregation processes from multiple file types and systems. + Experience supporting data quality efforts, such as: + Developing data validation rules or protocols. + Documenting data definitions and business rules. + Collaborating with others to perform regular data reviews. + Strong analytical skills, with the ability to: + Identify and troubleshoot data quality issues. + Recommend and implement process improvements. + Effective communication and collaboration skills, including: + Translating business needs into clear technical requirements. + Explaining technical data concepts to non-technical audiences. + Providing training or guidance to staff on data-related topics. **Preferred Qualifications** + Direct leadership in coordinating periodic data quality review cycles, including designing data quality frameworks, developing documentation and operational tools for data stewards, and facilitating structured, cross-departmental data clean-up initiatives. + Expert-level proficiency in SQL, with a track record of designing, optimizing, and troubleshooting highly complex queries across large, multi-relational datasets, including writing stored procedures, automating data pipelines, and managing performance tuning for reporting environments. + Proven ability to design, develop, and maintain comprehensive data architecture documentation, including data flow diagrams, system integration mappings, data lineage tracking, and metadata repositories, to support enterprise data governance and transparency. + 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. + 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. **Additional Requirements** This position requires successful completion of the following: + Reference Checks. + Job related background checks. + Conflict of Interest Disclosure. AN EQUAL OPPORTUNITY EMPLOYER Minnesota State Colleges and Universities is an Equal Opportunity employer/educator committed to the principles of diversity. We prohibit discrimination against qualified individuals based on their race, sex, color, creed, religion, age, national origin, disability, protected veteran status, marital status, status with regard to public assistance, sexual orientation, gender identity, gender expression, or membership in a local commission as defined by law. As an affirmative action employer, we actively seek and encourage applications from women, minorities, persons with disabilities, and individuals with protected veteran status. Reasonable accommodations will be made to all qualified applicants with disabilities. If you are an individual with a disability who needs assistance or cannot access the online job application system, please contact the job information line at 651-259-3637 or email careers@state.mn.us . Please indicate what assistance is needed.
Por favor confirme su dirección de correo electrónico: Send Email