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.
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.
Examples of Duties
Esse ntial Responsibilities:
Data Systems Development & Programming
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.
Examples of Duties
Esse ntial 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.