Business Intelligence & Data Analyst II

Hiring Department

Office of Institutional Effectiveness & Compliance

The University of Missouri–St. Louis (UMSL) is seeking a highlyanalytical 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 supportinginstitutional reporting, compliance, and data governance initiatives.

• Design, develop, deploy, and maintain interactive Power BIdashboards, reports, scorecards, and visualizations that supportinstitutional 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 improveusability, 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-wideanalytics,
• 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 usedin institutional reporting and analytics.

• Partner with university leadership, academic departments, and administrative units to understand business needs and establishreporting priorities.
• Lead analytics projects through the full lifecycle, includingdiscovery, 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 intelligencesolutions.
• 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 enhanceinstitutional data management and decision-supportcapabilities.

• 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.

As with all positions, may perform other job-related responsibilities as needed to support departmental and campus-wide needs.

Monday-Friday, 40+ hours per week

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.

• Four or more years of experience developing Power BIdashboards, reports, data models, and analytics solutions.
• Proficiency in SQL, data transformation, and business intelligence reporting.
• Experience with Microsoft Fabric, Azure analytics services, orsimilar cloud-based analytics platforms.
• Experience in higher education or another complexorganizational environment.
• Knowledge of data governance and data quality best practices.
• Strong project management, stakeholder engagement, and communication skills.

$75,000 - $90,000 commensurate with education and experience beyondminimum qualifications of the position

Grade: GGS-012

Un…