NEOGOV · 3 months ago
Programmer/Analyst – Student Data Systems and BI Reporting
UCMO - Warrensburg, MO
Full-time
Onsite
Entry, Mid Level
$59K/yr - $59K/yr
2+ years expNEOGOV is a division of the University of Central Missouri (UCM) focused on analytics and institutional research. The Programmer/Analyst – Student Data Systems and BI Reporting is responsible for building, maintaining, and optimizing the university’s student data infrastructure, focusing on SQL development, data automation, and Power BI optimization to support institutional decision-making and student success initiatives.
GovTechHuman ResourcesInformation TechnologySoftware
Responsibilities
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
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
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
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
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
Recommend and implement enhancements to data management systems and processes
Maintain comprehensive documentation for all data analysis, management, and reporting activities
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
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
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
Maintain documentation of data processes, ensuring transparency and repeatability
Propose process improvements to enhance efficiency in data management and reporting
Qualification
Required
Bachelor's degree from an accredited institution of higher education in business, computer science, CIS, economics, statistics, mathematics, or related field required
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
Preferred
Master's degree in business, statistics, economics, CIS, computer science, mathematics, student affairs, higher education, or related field preferred
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
Health, dental, vision, life insurance, AD & D, long-term disability
3 weeks paid vacation per year
3 weeks of accrued sick leave per year
13 paid holidays
Retirement
Generous education assistance for an employee, spouse and dependent children taking classes at UCM
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
Company
NEOGOV
NEOGOV is the leading provider of workforce management software uniquely designed for the public sector, education, and public safety.
501-1000 employees
H1B Sponsorship
NEOGOV has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (13)
2024 (10)
2023 (10)
2022 (18)
2021 (14)
2020 (16)
Funding
Current Stage
Late StageTotal Funding
$700MKey Investors
Warburg Pincus
2025-07-28Secondary Market· $700M
2025-07-28Acquired
2021-06-02Private Equity
Leadership Team
Shane Evangelist
CEO
Brandon McDonald
Head Of Marketing
Recent News
Canada NewsWire
2025-11-14
2025-11-14
Government Technology US
2025-10-31
Company data provided by crunchbase