Student Data Systems & BI Reporting Lead

University of Central Missouri (UCM); Warrensburg (MO); On-site; USD 70,000 - 95,000; Full time

Job summary

University of Central Missouri (UCM) seeks a Programmer/Analyst for Student Data Systems and BI Reporting to build, optimize, and maintain the university’s data infrastructure. You will focus on SQL development, data automation, and Power BI enhancements to deliver accurate, timely reports that support enrollment management and student success.

You will design scalable data models, implement ETL pipelines, and collaborate with UAIR analysts and campus partners to provide self-service dashboards,

Qualifications

• Minimum two years of experience with evaluation/analytic software (Excel, SPSS, Qualtrics, Survey Monkey).
• Expertise in Microsoft Excel, including pivot tables, VLOOKUP/XLOOKUP, and data visualization.
• Expertise in PL/SQL development, including writing and optimizing scripts, stored procedures, and complex queries for enterprise systems.
• Experience designing and managing Power BI dashboards, reports, and data models with focus on accuracy, security, and accessibility.
• Demonstrated project management, attention to detail, and strong communication skills.
• Experience with IPEDS and other federal reports preferred.

Responsibilities

• Design, develop, and maintain SQL scripts, stored procedures, ETL processes, and APIs for student data pipelines.
• Write and document code and automation scripts in SQL, Python, or R to streamline reporting.
• Design secure, scalable data models to support student success analytics.
• Manage Power BI dashboards and visualizations for enrollment, retention, and outcomes.
• Collaborate with stakeholders to create self-service data tools and governance.
• Build automated reporting pipelines for internal/external reporting (IPEDS, NCES).
• Ensure data quality via audits and validation across sources.
• Translate technical processes into user-friendly documentation and guides.
• Partner with IT Services on secure access and role-based permissions.

Skills

SQL development

Python

R

Power BI

ETL

APIs

Data governance

Analytics

Report automation

Data modeling

PL/SQL

Excel advanced

Education

Bachelor’s degree in CS/IT or related field

Master’s degree preferred

Tools

Banner

Workday

BANNER LMS

Job description

University of Central Missouri (UCM) seeks a Programmer/Analyst for Student Data Systems and BI Reporting to build, optimize, and maintain the university’s data infrastructure. You will focus on SQL development, data automation, and Power BI enhancements to deliver accurate, timely reports that support enrollment management and student success.

You will design scalable data models, implement ETL pipelines, and collaborate with UAIR analysts and campus partners to provide self-service dashboards,