Business Intelligence & Data 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

Hiring Department

Office of Institutional Effectiveness & Compliance

Job Description

The University of Missouri–St. Louis (UMSL) is seeking a highlyanalytical and collaborative Business Intelligence & DataAnalyst II to support the Office of Institutional Effectiveness& Compliance (OIEC). This position plays a key role indeveloping and maintaining business intelligence solutions,advancing data-informed decision-making, and supportinginstitutional reporting, compliance, and data governanceinitiatives.

Business Intelligence Development & Reporting(35%)

• Design, develop, deploy, and maintain interactive Power BIdashboards, reports, scorecards, and visualizations that supportinstitutional priorities and strategic initiatives.
• Translate stakeholder requirements into scalable reporting andanalytics solutions that address operational, compliance, anddecision-support needs.
• Continuously enhance business intelligence products to improveusability, relevance, accessibility, and performance.
• Promote a data-informed culture through innovative reportingsolutions and self-service analytics capabilities.

Data Modeling, Integration & Analytics (30%)

• Design, develop, and maintain Power BI semantic models,datasets, and data pipelines supporting enterprise-wideanalytics,
• Develop and optimize SQL queries, data extractions, andtransformation 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.

Stakeholder Consultation & Project Management(20%)

• Partner with university leadership, academic departments, andadministrative 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 technicalguidance to stakeholders throughout project execution.
• Collaborate with campus partners to improve data collection,retention, governance, and utilization practices.

Data Governance, Quality & Collaboration (10%)

• Monitor and troubleshoot reporting, dashboard, and dataintegrity issues to ensure reliable business intelligencesolutions.
• Support compliance with institutional data governancestandards, policies, and security requirements.
• Collaborate with Institutional Research, InformationTechnology, 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.

Training, Documentation & User Support (5%)

• Develop and maintain user guides, technical documentation, andtraining materials for business intelligence solutions.
• Deliver workshops and individualized support to enhance dataliteracy 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.

Shift

Monday-Friday, 40+ hours per week

Minimum Qualifications

Bachelor's degree or equivalent combination of education andrelevant experience, and at least 4 years of experience from whichcomparable knowledge and skills can be acquired.

Preferred Qualifications

• Four or more years of experience developing Power BIdashboards, reports, data models, and analytics solutions.
• Proficiency in SQL, data transformation, and businessintelligence 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 bestpractices.
• Strong project management, stakeholder engagement, andcommunication skills.

Anticipated Hiring Range

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

Grade: GGS-012

University Title: DATA ANALYST II

Sponsorship Information

Employment visa sponsorship is not available for this position.

Other Information

Application materials must include 2–3 screenshots or PDFs ofdashboards you have personally developed with a brief description(1 page maximum per dashboard) that explains the following:

• Business problem being solved
• Intended audience
• Data sources used
• Key metrics/KPIs displayed
• Your specific role in development
• Actions taken based on dashboard insights, if known

Location: Onsite with some flexibility on an ad hoc basis

Benefit Eligibility

This position is eligible for University benefits. As part of yourtotal compensation, the University offers a comprehensive benefits package, including medical, dental and vision plans, retirement,paid time off, short- and long-term disability, paid parentalleave, paid caregiver leave, and educational fee discounts for allfour UM System campuses. For additional information on Universitybenefits, please visit the Faculty & Staff Benefits website at https://www.umsystem.edu/departments-staff/human-resources/benefits-retirement

Equal Employment Opportunity

The University of Missouri is an Equal Opportunity Employer.

To request ADA accommodations, please email the Office of Human Resources at [e-mail].