Business Intelligence & Data Analyst II
About the role
The University of Missouri–St. Louis (UMSL) is seeking a highly analytical and collaborative Business Intelligence & Data Analyst II to support the Office of Institutional Effectiveness & Compliance (OIEC). This position plays a key role in developing and maintaining business intelligence solutions, advancing data-informed decision-making, and supporting institutional reporting, compliance, and data governance initiatives. Reporting to the Director of Institutional Research and Data Analytics, the successful candidate will work closely with campus partners to transform complex data into meaningful insights through dashboards, reports, visualizations, and analytical tools that support strategic planning and operational excellence.
Responsibilities
- Design, develop, deploy, and maintain interactive Power BI dashboards, reports, scorecards, and visualizations that support institutional priorities and strategic initiatives.
- Translate stakeholder requirements into scalable reporting and analytics solutions that address operational, compliance, and decision-support needs.
- Continuously enhance business intelligence products to improve usability, relevance, accessibility, and performance.
- Promote a data-informed culture through innovative reporting solutions and self-service analytics capabilities.
- Design, develop, and maintain Power BI semantic models, datasets, and data pipelines supporting enterprise-wide analytics.
- Develop and optimize SQL queries, data extractions, and transformation processes from institutional data sources.
- Analyze complex data sets to identify trends, opportunities, risks, and actionable recommendations.
- Ensure the accuracy, consistency, and reliability of data used in institutional reporting and analytics.
- Partner with university leadership, academic departments, and administrative units to understand business needs and establish reporting priorities.
- Lead analytics projects through the full lifecycle, including discovery, requirements gathering, development, testing, implementation, and post-deployment support.
- Provide project updates, recommendations, and technical guidance to stakeholders throughout project execution.
- Collaborate with campus partners to improve data collection, retention, governance, and utilization practices.
- Monitor and troubleshoot reporting, dashboard, and data integrity issues to ensure reliable business intelligence solutions.
- Support compliance with institutional data governance standards, policies, and security requirements.
- Collaborate with Institutional Research, Information Technology, Research Administration, Finance Information Systems, HRIS, and UM System partners on data governance, best practices, and enterprise reporting initiatives.
- Participate in cross-functional efforts to enhance institutional data management and decision-support capabilities.
- Develop and maintain user guides, technical documentation, and training materials for business intelligence solutions.
- Deliver workshops and individualized support to enhance data literacy and effective use of reporting tools.
- Serve as a resource for end users by providing consultation, troubleshooting assistance, and best-practice recommendations.
Requirements
Bachelor's degree or equivalent combination of education and relevant experience, and at least 4 years of experience from which comparable knowledge and skills can be acquired.