Power BI & Data Analytics Analyst II

University of Missouri, St. Louis; Clayton (MO); On-site; USD 75,000 - 90,000; Full time

Job summary

The University of Missouri–St. Louis (UMSL) is seeking a highly analytical and collaborative Business Intelligence & DataAnalyst II to support the Office of Institutional Effectiveness & Compliance. This role designs and maintains BI solutions, enabling data-informed decisions and robust institutional reporting.

Responsibilities include BI development, data modeling, governance, and stakeholder collaboration, with a focus on Power BI, SQL, and cloud analytics. Onsite with some flexibility.

Qualifications

• Bachelor's degree or equivalent combination of education and relevant experience, and at least 4 years of experience.
• Four or more years of experience developing Power BI dashboards, reports, data models, and analytics solutions.
• Proficiency in SQL, data transformation, and business intelligence reporting.
• Experience with Microsoft Fabric, Azure analytics services, or similar cloud-based analytics platforms.
• Experience in higher education or another complex organizational environment.
• Knowledge of data governance and data quality best practices.
• Strong project management, stakeholder engagement, and communication skills.

Responsibilities

• Design, develop, deploy, and maintain Power BI dashboards, reports, scorecards, and visualizations.
• Translate stakeholder requirements into scalable reporting and analytics solutions.
• Continuously enhance BI products to improve usability, relevance, accessibility, and performance.
• Promote a data-informed culture through innovative reporting solutions and self-service analytics.
• Design, develop, and maintain Power BI semantic models, datasets, and data pipelines.
• Develop and optimize SQL queries, data extractions, and transformation processes.
• Analyze complex data sets to identify trends, risks, and actionable recommendations.
• Ensure the accuracy, consistency, and reliability of data used in reporting and analytics.
• Partner with university leadership to understand reporting priorities.
• Lead analytics projects through the full lifecycle from discovery to deployment.
• Provide project updates and technical guidance to stakeholders.
• Collaborate with campus partners on data governance and enterprise reporting initiatives.
• Develop and maintain user guides, documentation, and training materials.
• Deliver workshops and end-user support for BI tools.

Skills

Power BI dashboards/reports

Data modeling & analytics

SQL & data transformation

Stakeholder engagement & PM

Data governance & quality

Education

Bachelor's degree or equivalent combination of education and relevant experience

Tools

Power BI

Microsoft Fabric

Azure analytics services

Cloud analytics platforms

Job description

The University of Missouri–St. Louis (UMSL) is seeking a highly analytical and collaborative Business Intelligence & DataAnalyst II to support the Office of Institutional Effectiveness & Compliance. This role designs and maintains BI solutions, enabling data-informed decisions and robust institutional reporting.

Responsibilities include BI development, data modeling, governance, and stakeholder collaboration, with a focus on Power BI, SQL, and cloud analytics. Onsite with some flexibility.