Data Analyst - Enrollment Management Shared Services

University of Illinois at Urbana-Champaign; Urbana (IL); On-site; USD 60,000 - 65,000; Full time

Job summary

University of Illinois Urbana-Champaign is hiring a Data Analyst in Enrollment Management Shared Services to support data integration, automation, and reporting. The role ensures data accuracy through daily ETL monitoring, incident triage, and end-user reporting support for EM operations.

The position emphasizes data quality, security compliance (FERPA), and collaboration with project teams to design solutions while not owning full project implementation.

Qualifications

• Two (2) years of IT-related experience or closely related field.
• Demonstrated experience with SQL.
• Demonstrated experience in data analysis and/or software development.

Responsibilities

• Monitor, maintain, and support data pipelines and ETL processes for reliable data delivery.
• Fulfill internal and external data requests and deliver ad hoc reports.
• Design, develop, and maintain operational reports and dashboards for daily EM activities.

Skills

SQL

Data analysis

Automation

FERPA compliance

Education

High school diploma or equivalent

Bachelor's degree in Information Systems or related field

Tools

SSMS

SSIS

Power BI

Python

SQL Server

Job description

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 meetings and discussions and contribute to clear, constructive communication.
• Commitment to customer service and user experience.
• Ability to work reliably and efficiently, manage time effectively, and meet deadlines while maintaining accuracy and quality.
• Possess innovative problem-solving abilities and excellent attention to detail.
• Ability to identify and anticipate problems, evaluate alternative solutions, and take appropriate action.
• Ability to work with high autonomy in managing daily operational priorities, proactively triaging data discrepancies, troubleshooting pipeline disruptions, and delivering dependable ad-hoc reports under tight deadlines.

Appointment Information

This is a 100% full-time Civil Service 5031 - Information Technology Technical Associate position. The expected start date is as soon as possible after the close of the search. The salary range for this position is $60,000 to $65,000 annually. We strive to provide a competitive salary, considering factors such as available market data, internal equity, candidate experience and qualifications, collective bargaining agreements, and budget constraints. The final salary offer will be determined through a thorough assessment of these elements.

This position is not eligible for any type of sponsorship for work authorization.

Application Procedures & Deadline Information

Applications must be received by 6:00 pm (Central Time) on October 19, 2026. For full consideration, application materials should include a cover letter, current resume (including month/year employment dates), contact information for three professional references, and (if applicable) transcripts or proof of degree(s). This may include professional, academic, volunteer, or other applicable experience that aligns with the responsibilities of this role.

In order to be considered as a transfer candidate, you must apply for this position. Applications not submitted through https://jobs.illinois.edu will not be considered. If required by the position, transcripts or other documentation of credentials are to be provided no later than the first day of employment. For further information about this specific position, please contact Doug Greene at [e-mail]. For questions regarding the application process, please contact 217-333-2137.

Champaign-Urbana

Artificial Intelligence (AI) tools may be used in some portions of the candidate review process for this position; however, all employment decisions will be made by a person.

This position is intended to be eligible for benefits. This includes Health, Dental, Vision, Life Insurance, a Retirement Plan, Paid time Off, and Tuition waivers for employees and dependents.

The University of Illinois System is an equal opportunity employer, including but not limited to disability and/or veteran status, and complies with all applicable state and federal employment mandates. Please visit Required Employment Notices and Posters to view our non-discrimination statement and find additional information about required background checks, sexual harassment/misconduct disclosures, and employment eligibility review through E-Verify.

Applicants with disabilities are encouraged to apply and may request a reasonable accommodation under the Americans with Disabilities Act (2008) to complete the application and/or interview process. Accommodations may also be requested on the basis of pregnancy, childbirth, and related conditions, or religion. Requests may be submitted through the reasonable accommodation portal, or by contacting the Office for Access & Equity at 217-333-0885, option #1, or [e-mail].