Data Analyst - Enrollment Management Shared Services

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

• 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: o 30 semester hours equals one (1) year o Associate’s Degree (60 semester hours) equals eighteen months o 90 semester hours equals two years o Bachelor’s Degree (120 semester hours) equals three years.

• Demonstrated experience with SQL.
• Demonstrated experience in data analysis and/or software development., * 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.

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

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.

Champaign-Urbana