University of Illinois
Office of Business & Financial Services
Strategic Procurement
Data Analyst
Urbana Campus
The University of Illinois seeks a Data Analyst to analyze existing information sources and produce reports to assist the decision making of OBFS operational units to improve efficiency, reduce costs, and grow customer satisfaction. The Data Analyst needs to be familiar with data query tools, statistical analysis, and data presentation tools. Additional responsibilities include:
1. Develop reports for executive management, regulatory agencies, audit firms, FOIA requests and compliance assurance; on both a recurring and as-needed basis.
2. Assimilate, aggregate and query financial data to provide recommendations based on statistical analysis.
3. Develop and maintain a University financial systems data dictionary.
4. Monitor data integrity of financial systems and notify appropriate personnel of data impairments.
5. Assist with financial procurement-related data analysis, including:
A. analyzing sourcing trends for generating new revenue streams,
B. conduct market trend research and benchmarking analysis,
C. support Request-For-Proposal bid teams with pricing analysis and evaluation,
D. analyze vendor performance including price and discount verifications,
E. analyze data to determine potential risk exposure,
F. spend categorization & management,
G. operational performance measurement.
6. Assess adequacy of existing data for reporting requests.
7. Develop solutions for automating complex repeatable queries that normalize and cleanse data.
8. Assist customers with troubleshooting technical issues, conducting queries and retrieving data from various systems.
9. Work with other OBFS and university-wide units responsible for systems management to obtain, understand, and interface financial data.
10. Serve on University, campus, and departmental committees/teams as required.
11. Research industry best practices in data mining and financial regulatory data requirements.
Candidates must possess a bachelor's degree in statistics, information systems, business administration or a related field with two years of professional experience in financial reporting, data analysis, information technology, statistical analysis, or business administration. Other requirements include: experience in SAS programming language; knowledge and experience with one or more of the following technical data query and reporting tools: including but not limited to: Oracle PL/SQL, Microsoft Access, Microsoft Excel, Microsoft SharePoint, Quest Toad, and SAP Business Objects; knowledge and experience with statistical analysis techniques; ability to read, analyze and interpret general business periodicals, professional journals, technical procedures, and government regulations; ability to write complex financial reports, business correspondence, and procedure documents; ability to effectively present information and respond to questions from groups of colleagues, vendors, management, and auditors; ability to work independently or as part of the team to meet goals and objectives of each project; strong interpersonal skills that reflect courtesy, diplomacy, and a collaborative approach to develop and maintain effective work relationships; ability to work independently and exercise good judgment and discretion in the performance of all work assignments; ability to multi-task and prioritize work accordingly to meet deadlines while staying on task with daily assignments; excellent verbal and written communication skills to effectively interact with University and departmental officials/staff.
Preferred qualifications include: knowledge on Ellucian Banner Finance ERP system; knowledge on Jaggaer eProcurement software; knowledge on University of Illinois EDW data warehouse; functional knowledge of procurement and contract management procedures; familiarity with Illinois Procurement Code; experience in public sector, within, or in support of a financial operation; NIGP Certified Public Procurement Buyer (CPPB) certification.
This is a full-time, 12-month Academic Professional position. For full consideration, candidates must apply and submit a letter of application, resume, and names/addresses/phone numbers of three professional references by October 10, 2017 athttps://uajobs.hr.uillinois.edu/.
The University of Illinois conducts background checks on all job candidates upon acceptance of a contingent offer of employment. Background checks will be performed in compliance with the Fair Credit Reporting Act.
HR Service Center
449 Henry Administration Building, MC 341
506 South Wright Street
Urbana, IL 61801
(217) 333-2600
The University of Illinois is an affirmative action/equal opportunity employer dedicated to building a community of excellence, equity and diversity. The System Offices welcome applications from women, underrepresented minorities, individuals with disabilities, protected veterans, sexual minority groups and other candidates who will lead and contribute to the diversification and enrichment of ideas and perspectives.