Data Analyst - Enrollment Management Shared Services

Laseagrant; Urbana (IL); On-site; USD 60,000 - 65,000; Full time

Job summary

University of Illinois Urbana-Champaign is seeking a Data Analyst for Enrollment Management Shared Services. The role supports data integration, automation, and reporting to ensure accurate, reliable EM data and daily operations.

Responsibilities include maintaining data pipelines, responding to data requests, and developing dashboards. Preference for experience with SQL, Python, Power BI, and Excel, with a focus on data quality and confidentiality.

Qualifications

• High school diploma or equivalent.
• Two years of IT-related work experience in areas like hardware/software support, programming, or IT systems integration.
• Demonstrated experience with SQL.
• Demonstrated experience in data analysis and/or software development.

Responsibilities

• Data Integration & Automation: monitor and support data pipelines for seamless integration across systems like Banner and Slate, ensuring timely data loads.
• Data Requests: fulfill internal and external data requests with ad hoc reports while complying with FERPA and confidentiality requirements.
• Reporting: design, develop, and maintain operational reports and dashboards to support daily Enrollment Management activities.

Skills

SQL

Data analysis

Software development

IT knowledge

Data consultation

Education

Bachelor's Degree in Information Systems

Tools

SSMS

Python

Power BI

SSIS

Excel

Job description

Data Analyst - Enrollment Management Shared Services

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.
For more information on Civil Service classifications, please visit the SUCSS web site at https://www.sucss.illinois.gov/pages/classspec/default.aspx.

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

At the University of Illinois Urbana-Champaign - the state's flagship public university and one of the world's leading research institutions - every staff member helps shape what's next. Founded in 1867, Illinois is home to a vibrant community of 59,000 students from all 50 states and 129 countries, supported by 15 colleges and instructional units, more than 20 research institutes, and one of the most comprehensive student service ecosystems in the nation. Whether you're empowering first-generation students, fueling breakthrough innovation, or strengthening communities across Illinois and beyond, your work here has a far-reaching and deeply meaningful impact. The university offers a highly competitive benefits package designed to support your well-being, growth, and financial security. Join a top 10 public university that has launched over 330 startups and continues to redefine excellence - where the Illinois Value Proposition ensures that your contributions are recognized, your potential is nurtured, and your career can thrive.

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

Looking for more University of Illinois Positions?

We invite you to search for positions at each of the University of Illinois' locations, the University of Illinois System Office and the University of Illinois Foundation. The University of Illinois System Office supports the primary missions of teaching, research, public service, and economic development for all of the Universities and offers positions in all locations. The University of Illinois Foundation is the official fundraising and private gift-receiving agency for the University of Illinois and also offers position in all locations. Click the links below to search for other University of Illinois positions.