Affirmative Action Data Analyst

Office for Access and Equity

Job Summary
Support the development, implementation, and monitoring of data for the Affirmative Action Analytics and Planning Division in the Office for Access & Equity (OAE).

Duties & Responsibilities

Develop and maintain dashboards, reports, and databases to improve functionality, accessibility, data sharing, and visualization in and/or among the various data, communications, and systems managed by the division. Understand campus’ primary data source systems, including table and data model relationships. Use that understanding to develop standard and ad-hoc reports that accurately answer questions from leadership.
Analyze and prepare data and materials for the affirmative action plan. This includes but not limited to affirmative action meetings and audit responses/submissions to the Office of Federal Contract Compliance Program (OFCCP). Run reports including employee data, application information, hires, promotions, and terminations.
Conduct project-specific data analysis that includes analyzing and mapping required data
Design, develop, and maintain logical and physical data infrastructure to meet new and changing business requirements within the division.
Design workflows and forms that improve efficiency and effectiveness using standard campus tools (form builder, webtools, etc.).
Regularly audit and ensure data integrity in data systems.
Identify and explore useful new technologies that fit within the division’s strategic direction.
Assist division with effective data collection and storage processes.
Maintain documentation on procedures associated with these roles.
Perform other duties as assigned to further the mission of the Office for Access and Equity.

Minimum Qualifications

Two years of progressively more responsible work experience in an Information Technology (IT) related profession. College course work which included Information Technology (IT), IT Management, or a closely related discipline may be substituted as follows: 60 semester hours or associate degree equals one (1) year, 90-120 semester hours or Bachelor’s Degree equals two (2) years. Professional business, financial, and /or managerial work experience analyzing and reporting data to identify issues, trends. Demonstrated experience creating and working with relational data models and query language. Experience with other programming or markup language.

Preferred Qualifications

Preferred Experience: Advanced Excel skills, including but not limited to: vlookup/xlookup, switch, conditional logic, stats (stddeve, median) and experience working with affirmative action plans and regulations.

Knowledge, Skills and Abilities

Ability to analyze data, problem solve, and clearly communicate
Demonstrated ability to creatively solve data, process, or organizational problems
Strong discretion in dealing with confidential and sensitive data
Excellent written and verbal communication skills
Strong commitment to diversity, affirmative action, and equal employment opportunity
Excellent interpersonal skills and ability to work in a collaborative and diverse environment
Strong organizational, planning, analytical and problem-solving skills
Demonstrated ability to manage high volume and time-sensitive workload
Appointment Information
This is a 100% full-time Civil Service 5031 – Information Technology Technical Associate position, appointed on a 12-month basis. The expected start date is as soon as possible after 9/26/2022. Salary is commensurate with experience.

Application Procedures & Deadline Information
Applications must be received by September 26, 2022. Apply for this position using the Apply Now button at the top or bottom of this posting. In order to be considered as a transfer candidate, you must apply for this position. Applications not submitted through this website will not be considered. For further information about this specific position, please contact Heidi Johnson (johnso19@illinois.edu). For questions regarding the application process, please contact 217-333-2137.


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, COVID-19 vaccination requirements, 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. Requests may be submitted through the reasonable accommodations portal, or by contacting the Accessibility & Accommodations Division of the Office for Access and Equity at 217-333-0885, or by emailing accessibility@illinois.edu.

Tagged as: affirmative action plan, conditional logic, data mapping, IT, ofccp, statistics, vlookup/xlookup