Hiring Department: Budget & Financial Analysis
Location: Chicago,
IL USA
Requisition ID: 1014807
Posting Close Date: November 11, 2022
Position Summary:
The Senior Coordinator, Budget Model, Tuition and Data
Analytics in the Office of Budget and Financial Analysis (BFA) in conjunction
with the Director, will manage analyses and activities related to financial aid
and student assessments; serve as an expert on salary & fringe benefit
analyses; coordinate the SURS Governor's Salary assessment for UIC, and serve
as a primary point of contact in BFA for a group of Colleges and/or
Administrative Units. The Senior Coordinator also assists with the creation and
management of databases, dashboards, automated reports, and other technologies
to support activities throughout BFA and enhance the use of data for
decision-making by campus leaders.
Duties & Responsibilities:
Budgeting & Analysis
- Develop
budgets and expenditure projections for institutionally funded financial
aid and waivers. Perform budget-to-actual analysis throughout the fiscal
year. Communicate budgets to affected units. Provide informed evaluation
of the impact of new financial aid programs and proposed changes to
existing programs. Work with the Financial Aid Office to create detail
codes for new programs. Prepare required year-end transactions.
- Develop
budgets and revenue projections for Library/IT and AFMFA Assessments.
Perform budget-to-actual analysis throughout the fiscal year. Communicate
budgets to affected units. Prepare and process allocations to units
receiving these funds. Adjust budgets at the end of the fiscal year to
reflect actual revenue and prepare required year-end transactions.
- Serve
as the BFA expert on salary & fringe benefits (budget & actuals).
Conduct routine and ad-hoc analysis in support of annual salary planning,
union negotiations, legislative changes, organizational changes, funding
changes, or strategic initiatives. Monitor and evaluate salaries &
benefit costs by source of funds. Perform cost impact analyses, trend
analyses, or other analyses as necessary.
- Coordinate
the annual SURS Governor’s Salary assessment process for UIC. Review and
distribute quarterly estimates from the System Office. Prepare and
distribute the final analysis for the fiscal year. Work with UAFR to
distribute the expense to affected units.
- Act as
a BFA point of contact for a portfolio of Colleges and / or Administrative
Units. Evaluate Budget Meeting materials and partner with units on
revisions. Evaluate course fees and pro formas for new initiatives.
Document and process financial commitments made to Colleges and
Administrative Units.
- Provide
recurring and ad hoc financial and analytical support to senior campus
officers and University fiscal officers. Prepare, present, and interpret
complex financial information for business and non-business audiences.
Reporting & Automation
- Assist
with the design, creation, automation, and maintenance of financial
reports for internal staff, senior campus officers, and college staff.
Ensure that dashboards and reports deliver accurate, valuable information
and facilitate analysis and informed decision making. Develop methods for
automating/scheduling routine reports. Reports may include but are not
limited to:
- financial dashboards that are meaningful
to non-business audiences and the public;
- leadership
dashboards and reports that provide senior campus officers with current
status and trends on key financial indicators;
- and
detailed business reports that college staff can use for planning and
operations.
- Maintain
and further develop departmental tools and databases used to track
financial commitments and manage other office activities and provide
support to all BFA staff in utilizing these tools and databases. Manage
the testing and roll out of new features.
- Identify
ways to improve data analysis and reporting solutions with evolving and
new technologies.
- Perform
other related duties as appropriate for a Senior Coordinator.
Qualifications:
Minimum Qualifications
- Bachelor’s
degree preferably in Business Administration, Business Analytics, Data
Science, Computer Science or a related field.
- Three
years financial analysis, reporting, budgeting, business, financial, or
accounting experience, preferably in a large and complex University or
not-for-profit setting. Expertise related to business and
financial operations.
- Experience
with report creation, macro writing, and/or SQL query writing. Experience
working with large datasets to provide useful analysis and insights to
address business issues.
- Strong
analytical skills with extensive experience using include Microsoft Office
products (especially Excel and Access) for financial analysis and
reporting. Experience with quality control and attention to
detail.
- Demonstrated
leadership skills. Outstanding verbal and written communications
skills and exceptional interpersonal and customer service skills.
- Experience
working with executive leadership that includes preparing summaries of
complex information or drafting communications or policy on behalf of
management.
Preferred Qualification
- Master’s
degree in Business Administration, Business Analytics, Data Science,
Computer Science or a related field.
- Five
years financial analysis, reporting, budgeting, business, financial, or
accounting experience, preferably in a large and complex University or
not-for-profit setting.
- Knowledge
of the University of Illinois at Chicago, SCT Banner finance module, SAP
Business Objects, EDDIE, and other related campus-based business / finance
systems.
- Experience
with Tableau or other business analytics platforms.
- Experience
working in a complex regulatory environment. Knowledge of federal
and State regulations governing University business and financial
activities.