Data Analyst - Enrollment Management Shared Services Job Urbana area,Illinois USA,IT/Tech

Data Analyst - Enrollment Management Shared Services

University of Illinois Urbana-Champaign

Join our team! Enrollment Management Shared Services is accepting applications for a Data Analyst. The Data Analyst is a mid-level position responsible for supporting and advancing Enrollment Management (EM) operations through data integration and automation, data requests, and reporting. The role ensures the accuracy, reliability, and availability of EM data through daily pipeline and ETL monitoring, incident triage, fulfillment of ad-hoc data requests, and end-user reporting support.

The analyst may also provide operational insights and data consultation during the design of new initiatives without assuming responsibility for project implementation.

Duties & Responsibilities Data Integration & Automation

Monitor, maintain, and support existing data pipelines to facilitate seamless integration between internal and external systems (Banner, Slate, and other EM systems), ensuring scheduled data loads (applications, test scores) run accurately and on time.
Serve as an operational subject matter expert, providing contextual data knowledge and consulting to project teams during design discussions, while focusing primarily on day-to-day data quality, accuracy, and operational reliability.
Identify and implement minor operational automations and troubleshooting fixes to eliminate recurring production glitches, improve data integrity, and streamline routine tasks.

Data Requests

Fulfill internal and external data requests, providing ad hoc reports to EM's supervisory staff, colleges, departments, and other external campus entities.
Ensure all data provision is in compliance with FERPA regulations and other confidentiality requirements.
Assist the Director with conducting annual security access audits and ensure all active users are compliant with FERPA training and confidentiality documents.

Reporting

Design, develop, and maintain operational reports and dashboards to address routine functional needs and support daily EM activities, while troubleshooting existing reporting solutions and providing dependable end-user data support.

Minimum Qualifications

High school diploma or equivalent.
Two (2) years of work experience in IT-related functions such as hardware/software support, programming, network design, network engineering, IT systems integration, or closely related field.
- College coursework which includes Information Technology (IT), IT Management, Programming, IT systems, or a closely related discipline may be substituted as follows:
  - 30 semester hours equals one (1) year
  - Associate's Degree (60 semester hours) equals eighteen months
  - 90 semester hours equals two years
  - Bachelor's Degree (120 semester hours) equals three years.
Demonstrated experience with SQL.
Demonstrated experience in data analysis and/or software development.

Preferred Qualifications

Bachelor's degree in Information Systems or a related field.
At least two years of progressively responsible work experience in data analysis or software development, or similar technical role OR a role focused on data usage and functionality within an Admissions & Enrollment Management CRM system (e.g. Slate).
Demonstrated experience with Slate's functionality and using its data for reporting and analysis.
Demonstrated experience with Excel.
Extensive experience in developing, maintaining, and troubleshooting SQL queries and stored procedures, particularly with tools like SSMS.
Experience with programming languages such as Python for scripting and automation tasks.
Experience with MS SQL server Integration Services (SSIS).
Experience with data visualization and dashboard tools like Power BI.

Knowledge,

Skills and Abilities

Higher education knowledge.
Familiarity with data integration processes (ETL) and tools.
A foundational understanding of cloud services and modern data warehousing, such as those within the Azure Data platform (e.g., Data Factory, Azure Functions).
Proficiency in writing, analyzing, and troubleshooting SQL queries and stored procedures in relational databases.
An ability to learn and grow in the field of data analysis, including acquiring skills in programming languages like Python and data visualization tools like Power BI.
Competence in Excel and Office 365.
Ability to communicate complex technical ideas to a non-technical audience.
Strong interpersonal and communication skills, with the ability to collaborate effectively in a high-performance team environment.
Ability to participate effectively in…