Coordinator, Government Costing (Chicago)
Job Category: Academic Professional Academic Professional
Description: University of Illinois System Office
Office of Business & Financial Services
Coordinator, Office of Government Costing
The University of Illinois System Office seeks a Coordinator to, under limited supervision, provide analytical and technical support in the review of the financial transactions for the Office of Government Costing at the University of Illinois System. This position will conduct service activity rate calculation reviews of the various departmental service activity funds. In addition, this position will provide assistance in data gathering, analysis, and calculation of the Facilities and Administrative (F&A) indirect cost, fringe benefit, tuition remission rates, and other projects as assigned. Compliance with University policies and Federal regulations, including the Code of Federal Regulations CFR Title 2: Grants and Agreements - Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards must be understood and adhered to while performing these functions. Additional responsibilities include:
1. Provide guidance to University departments in the development of service center rates. Conduct service activity rate calculation reviews which include: learning the operations of the various departmental service activity funds across campus, providing assistance and guidance to departments, writing queries and preparing related costing reports and calculations, detailed analysis of rate calculations for reasonableness, accuracy, and adherence to Federal and University policies.
2. Provide early consultation services to University departments related to potential or upcoming establishment of service center activities. Includes but is not limited to: appropriateness of service fund establishment; direction to fund establishment requirements; guidance on proper rate calculations; awareness of over-arching policies and procedures, available training resources, rate development reports, spreadsheets, etc.; and providing training as requested.
3. Provide individualized training to service center customers as needed and assist with formal service activity training sessions. Assist with developing service activity training and job aids for the University System at large.
4. Assist in preparation of the Facilities & Administration Rate proposals which includes performing various studies, analyses, and reviews in support of the proposal. Includes, but is not limited to major functions of: conducting and/or review of space studies, space tours, equipment inventories, review of various departmental financial data, creation of various financial and attribute tables, FTE studies, utilities analyses, interest analyses, library studies, projections, and various cost share studies. Includes collaboration with various University departments and related organizations.
5. In preparation for F&A Rate proposals, work with appropriate University departmental staff to monitor and maintain campus financial, space, equipment, and other related data to ensure compliance with applicable federal, state and institutional regulations. Perform various variance analyses and review error reports and facilitate necessary changes.
6. Assist in preparation of the “University Administration Calculation” for all three Universities Facilities & Administrative Rate proposals.
7. Assist in preparation of the Fringe Benefit Studies which includes Termination Rate calculations, Graduate Assistant Health, Dental, Vision Rate calculations, Employee Health, Life, and Dental Rates and Reconciliations, Worker's Compensation Rate Reconciliations, and compilation of Retirement, Medicare, and OASDI rates from other sources. Includes collaboration with various University departments and related organizations.
8. Assist in preparation of the Tuition Remission Rate calculations which includes collaboration with various University departments.
9. Assist with communications related to F&A, Fringe Benefit, Tuition Remission, Services Activity rates, issues, and topics for publication to the appropriate Universities. Includes assisting with development of communications and/or rate schedules and coordination with appropriate University departments for required approvals and formal publication of communications.
10. Assist with responses to audit requests related to the Defense Contract Audit Agency's (DCAA) audits of F&A proposals, DS -2, Fringe Benefits proposals, and Tuition Remission rates including: providing supporting documentation, working with various departments when necessary to obtain supporting documentation for audit requests in the amount of time stipulated by the auditors; and performing follow-up actions with administrative officials and/or auditors as needed.
11. Run, modify, create, utilize, and maintain numerous databases, queries, and reports in support of all costing functions and operations as required. Includes modifications to design of financial models and tools as needed, detailed analysis of results and reconciliation to the U of I System financial statements.
12. Other duties and responsibilities appropriate for a Coordinator of Government Costing position as assigned.
Candidates must possess a bachelor's degree, preferably in Accounting, with two years' professional work experience requiring utilization of accounting and financial skills in a complex business, academic, higher education, or government environment. Other requirements include: strong analytical and problem solving skills; ability to work independently and to exercise good judgment and discretion in the performance of all work assignments while maintaining compliance with Federal and University policies; ability to work in an integrated team environment; expert technical skills for extensive use of Access, Word, Excel, Power Point, Outlook, and Internet Explorer; ability to document clearly and concisely procedures and processes related to the costing functions; highly developed and effective verbal and written communications skills; strong interpersonal skills that reflect courtesy, diplomacy, and a collaborative approach to develop and maintain effective work relationships; ability to multi-task and prioritize work accordingly to meet deadlines while staying on task with daily assignments; ability to counsel and train individuals and departments.
Preferred qualifications include: advanced degree in Accounting; previous work experience at an institution of higher education; working knowledge of Banner programs/applications and SAP Business Objects Web Intelligence; working knowledge of generally accepted accounting principles, and state and federal regulations related to cost accounting, sponsored project administration, and rate development.
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 March 20, 2018 at https://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.
System Human Resource Services
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.
Close Date: 03/20/2018