BI & Data Analytics Leader — Power BI & SQL

University of Wisconsin Colleges; Milwaukee (WI); Hybrid; USD 85,000 - 97,000; Full time

Job summary

The Data Analytics and Business Intelligence Manager at the University of Wisconsin–Milwaukee's Center for Advancing Student Learning (CASL) leads the design, development, and maintenance of CASL data systems to support unit and institutional decision‑making.

This role integrates data across platforms and delivers high‑quality reports, dashboards, and analyses while overseeing SQL server administration and data security.

Qualifications

• Bachelor’s degree in data analytics, information systems, computer science, statistics, or a related field.
• Three (3) or more years of professional experience in data analysis, business intelligence, database management, or a closely related role.
• Demonstrated experience extracting, integrating, and analyzing data from multiple systems to support programmatic or institutional decision‑making.
• Proficiency in SQL, including writing complex queries, views, and stored procedures.
• Experience developing reports and interactive dashboards using Power BI or comparable business intelligence tools.
• Strong organizational skills and the ability to manage multiple projects, priorities, and deadlines simultaneously.

Responsibilities

• Analyze, plan, and produce data sets, reports, and dashboards to support unit, program, and institutional planning.
• Design, develop, and implement BI and reporting solutions using Power BI and SQL‑based environments.
• Generate recurring and ad hoc reports, including annual reports on identified key outcomes.
• Provide accurate, timely, and actionable data to leadership to support strategic decision‑making.
• Serve as a point of contact for CASL database systems, reporting platforms, and data‑related projects.
• Develop user documentation and facilitate training to support effective use of databases, reports, and dashboards by unit staff and partners.
• Ensure responsible handling of confidential and sensitive data.
• Partner with academic and administrative units across campus to integrate data from multiple systems in support of a unified, institution‑wide view.
• Prepare data sets for analysis, including data cleaning, quality assurance, transformation, restructuring, and integration of multiple data sources.
• Organize data preparation and analysis into reproducible, automated pipelines optimized for performance and scalability.
• Design, develop, build, and maintain one or more database systems and SQL server environments to ensure data availability, integrity, and security.
• Implement and maintain security measures in accordance with institutional policies and data governance standards.
• Identify and resolve routine data and database issues while upholding database‑use guidelines.

Skills

Data analytics

Business intelligence

Database management

SQL

Dashboard development

Education

Bachelor’s degree in data analytics, information systems, computer science, statistics, or related field

Master’s degree (preferred)

Tools

Power BI

SQL Server

ETL processes

Job description

The Data Analytics and Business Intelligence Manager at the University of Wisconsin–Milwaukee's Center for Advancing Student Learning (CASL) leads the design, development, and maintenance of CASL data systems to support unit and institutional decision‑making.

This role integrates data across platforms and delivers high‑quality reports, dashboards, and analyses while overseeing SQL server administration and data security.