Programmer​/Analyst – Student Data Systems and BI Reporting

Description

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.

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