About the Department

The Programmer/Analyst – Student Data Systems and BI Reporting is a technical expert within University Analytics and Institutional Research (UAIR) responsible for building, maintaining, and optimizing the university’s student data infrastructure. This role focuses on SQL development, data automation, and Power BI optimization to deliver accurate, timely, and accessible reporting that supports institutional decision-making, student success initiatives, and compliance with federal and state reporting requirements.
The Programmer/Analyst works closely with UAIR analysts to design, review, clean, and automate SQL code, creating reliable and scalable queries, stored procedures, and ETL workflows. This position also leads efforts to develop and maintain customized student data reports for internal and external stakeholders, ensuring that reports meet institutional standards, accreditation needs, and regulatory mandates.
In addition, this role is responsible for enhancing and maintaining Power BI dashboards to ensure data accuracy, real-time refresh capabilities, role-based security, and intuitive visualization. The Programmer/Analyst partners with the Office of Technology and other teams to manage system integrations and data pipelines, leveraging APIs and advanced automation tools to maintain a unified and efficient institutional data ecosystem.
This position requires a deep understanding of relational database design, query optimization, data governance practices, and business intelligence tools to provide campus leadership, regulatory agencies, and other stakeholders with actionable insights that inform enrollment management, retention strategies, and overall student success efforts.

Position Duties

Essential Responsibilities:

Data Systems Development & Programming

Design, develop, and maintain complex SQL scripts, stored procedures, ETL processes, and APIs to extract, transform, and load student data from institutional systems such as Banner, Workday, or other enterprise platforms.
Write, optimize, and document custom code and automation scripts in SQL, Python, R, or other supported programming languages to streamline reporting and analytics.
Implement and maintain secure, scalable, and efficient data models to support student success and institutional analytics.
Serve as a subject matter expert on database architecture and integration, ensuring systems are configured and maintained to support long-term analytics needs.

Business Intelligence & Dashboard Management

Design, implement, and manage Power BI dashboards and visualizations to provide actionable insights on enrollment, retention, graduation, and other student success metrics.
Regularly update and validate dashboard data sources to ensure accuracy and consistency.
Collaborate with analysts, leadership, and campus stakeholders to create self-service data tools and visualizations.
Evaluate emerging BI tools and features, recommending upgrades or enhancements to existing solutions.

Reporting, Analytics, & Data Quality

Build and maintain automated reporting pipelines to deliver accurate and timely reports for internal and external stakeholders (e.g., IPEDS, state and federal agencies).
Conduct audits and data integrity checks to ensure the accuracy and consistency of institutional student data.
Partner with institutional leaders to create predictive models and actionable reporting to inform enrollment management, retention, and strategic initiatives.
Translate technical processes into user-friendly documentation and guides to ensure transparency and consistency.

Collaboration, Support & Innovation

Work closely with Information Technology Services to maintain secure access, role-based permissions, and governance standards for all data systems and dashboards.
Provide technical consultation, training, and support to UAIR team members and campus partners to improve their use of data and reporting tools.
Participate in cross-functional data governance and analytics committees, contributing technical expertise to university-wide data strategy efforts.
Stay current on industry best practices in business intelligence, data engineering, and analytics to continuously improve UAIR’s data infrastructure.

Reporting & Presentation

Prepare well-organized, accessible reports, presentations, and proposals that clearly communicate key findings and insights.
Utilize statistical tools and data visualization software to effectively summarize and present data.

Process Improvement & Documentation

Recommend and implement enhancements to data management systems and processes.
Maintain comprehensive documentation for all data analysis, management, and reporting activities.

Institutional & External Data Reporting

Analyze and interpret data for institutional and external reporting, ensuring accuracy and consistency.
Develop and maintain reports and dashboards to support decision-making across the institution.

Ad-hoc Analysis & Dashboards

Assist in developing self-service reports and dashboards for institutional stakeholders, enhancing access to accurate data.
Perform ad-hoc data collection and analysis to meet the needs of various constituents across the institution.

Project Management & Collaboration

Manage multiple complex projects concurrently while ensuring timely completion and high-quality results.
Work independently and collaboratively with team members on data analysis and reporting tasks.

Documentation & Efficiency

Maintain documentation of data processes, ensuring transparency and repeatability.
Propose process improvements to enhance efficiency in data management and reporting.

Minimum Qualifications

Education:

Bachelor’s degree from an accredited institution of higher education in business, computer science, CIS, economics, statistics, mathematics, or related field required.

Master’s degree in business, statistics, economics, CIS, computer science, mathematics, student affairs, higher education, or related field preferred.

Experience:

Minimum of two years of experience utilizing evaluation and analytic software (for example, Excel, SPSS, Qualtrics, Survey Monkey, etc) required.
Expertise in Microsoft Excel, including advanced features such as pivot tables, VLOOKUP/XLOOKUP, data visualization tools, and formula creation (required).
Expertise in PL/SQL development, including writing and optimizing scripts, stored procedures, and complex queries for enterprise-level systems (required).
Experience designing and managing Power BI dashboards, reports, and data models with a focus on accuracy, security, and accessibility (required).
Demonstrated project management experience and attention to detail
Demonstrated ability in statistical analysis and interpretation
Demonstrated ability in data presentation
Demonstrated strong interpersonal and verbal communication skills
Demonstrated proficiency in written communication skills
Demonstrated ability to work with diverse groups/populations
Thorough knowledge of statistics and the ability to understand and analyze qualitative and quantitative information required
Experience with sophisticated information management tools required
Experience in data manipulation required
Advanced proficiency in Excel preferred
Experience with BANNERLMS preferred
Experience completing or contributing to IPEDS and other federal reports for National Center for Education Statistics (NCES) preferred.

Benefits

Our faculty and staff are the university’s most valuable asset, and our goal is to provide a robust Total Rewards Program designed to help them maintain a happy, healthy, and productive lifestyle.

Highlights from UCM's total rewards package for full-time employees include:

30.25% (staff) and 6% (faculty) defined retirement contribution, paid by the university;
Voluntary Tax-Sheltered Annuity (TSA) programs (403(b) and 457(b)) that allow eligible employees to make additional pre-tax contributions to a retirement plan;
Employees can earn up to full tuition (15 credit hours) for themselves per academic year. Full-time employees are also eligible for up to $175 towards non-credit courses each fiscal year. Employees can earn up to full tuition for their dependents;
Comprehensive medical, dental, and vision plans that begin on the first of the month following your date of hire. Basic dental and vision insurance paid at 100% by the university;
Available Health and Dependent Flexible Spending Accounts;
University-paid basic life insurance (including accidental death and dismemberment) and short-term and long-term disability insurance coverage;
Generous leave accruals that begin accruing on your start date, plus 14 paid holidays per year.
The UCM Childcare Center on the Warrensburg campus can provide faculty, staff, and students quality care for their children ages six weeks to 10 years.
The Student Recreation and Wellness Center (SRWC) is free for all employees and is located on the Warrensburg campus.
An Employee Assistance Program is available to all employees and their immediate family members to help assist with personal challenges you may face in your daily life;
UCM offers an Employee Discount Program through Working Advantage.

To learn more about the wonderful benefits available as a University of Central Missouri employee, visit our benefits page!

Supplemental Questions

Do you have a Bachelor's degree or higher in the field of business, computer science, CIS, economics, statistics, mathematics, or a closely related field?

How many years of experience utilizing evaluation and analytic software (for example, Excel, SPSS, Qualtrics, Survey Monkey, etc) do you currently have?

Less than 1 year of experience.
More than 1 year, but less than 2 years of experience.
More than 2 years, but less than 3 years of experience.
More than 3 years, but less than 4 years of experience.
More than 4 years, but less than 5 years of experience.
More than 5 years of experience.

Please explain your experience utilizing evaluation and analytic software (for example, Excel, SPSS, Qualtrics, Survey Monkey, etc) in great detail.

How many years of experience with Microsoft Excel, including advanced features such as pivot tables, VLOOKUP/XLOOKUP, data visualization tools, and formula creation, do you currently have?

Less than 1 year of experience.
More than 1 year, but less than 2 years of experience.
More than 2 years, but less than 3 years of experience.
More than 3 years, but less than 4 years of experience.
More than 4 years, but less than 5 years of experience.
More than 5 years of experience.

Please explain you Microsoft Excel, including advanced features such as pivot tables, VLOOKUP/XLOOKUP, data visualization tools, and formula creation experience in great detail.

How many years of experience with PL/SQL development, including writing and optimizing scripts, stored procedures, and complex queries for enterprise-level systems do you currently have?

Less than 1 year of experience.
More than 1 year, but less than 2 years of experience.
More than 2 years, but less than 3 years of experience.
More than 3 years, but less than 4 years of experience.
More than 4 years, but less than 5 years of experience.
More than 5 years of experience.

Please explain your PL/SQL development, including writing and optimizing scripts, stored procedures, and complex queries for enterprise-level systems experience in great detail.

How many years of experience designing and managing Power BI dashboards, reports, and data models with a focus on accuracy, security, and accessibility do you currently have?

Less than 1 year of experience.
More than 1 year, but less than 2 years of experience.
More than 2 years, but less than 3 years of experience.
More than 3 years, but less than 4 years of experience.
More than 4 years, but less than 5 years of experience.
More than 5 years of experience.

Please explain your experience with designing and managing Power BI dashboards, reports, and data models with a focus on accuracy, security, and accessibility in great detail.

Please describe your experience in developing Business Intelligence reporting platforms such as Power BI, Google Looker, or Tableau in great detail.

Please describe your experience with designing, developing, and maintaining complex SQL scripts, stored procedures, ETL processes, and APIs to extract, transform, and load data from institutional systems such as Banner, Workday, or other enterprise platforms in great detail.

Will you now or in the future require employer sponsorship to acquire or maintain U.S. work authorization? This would include items such as OPT, CPT, H-1B, or employer-sponsored permanent residency.

This role requires full-time, on-site work at our Warrensburg, Missouri campus and is not eligible for full-time remote work. Are you able to work on-site in Warrensburg, Missouri each day?

Yes, I am able to work on-site in Warrensburg, Missouri each day, as required, and understand that this role requires full-time, on-campus presence. This position is not a remote position.
No, I am looking for a remote position, and I am unable to report to on-site work in Warrensburg, Missouri, each day, as expected.

Required Question

Agency Information

Employer: University of Central Missouri (UCM)
Address: PO Box 800

Warrensburg, Missouri, 64093-5299
Phone: (660) 543-4255
Website: https://www.ucmo.edu/