Financial Analyst Intermediate

University of Michigan

Ann Arbor , MI

ID: 7121349
Posted: January 17, 2023
Application Deadline: Open Until Filled

Job Description

Summary

The following is a job posting for a Financial or Business Analyst Intermediate position at the University of Michigan Survey Research Center.

The Survey Research Center (SRC) has been a national and international leader in interdisciplinary social science research involving the collection or analysis of data from scientific sample surveys. SRC is part of the Institute for Social Research (ISR), and the Survey Research Operations (SRO) is the operations branch of the SRC.

SRO provides a wide range of services in the areas of survey and statistical design, data collection and processing, and data analysis. SRO provides these services to clients from ISR and SRC, to other departments within the University, as well as to researchers and organizations outside the University. Within SRO, staff members work on projects across a variety of substantive areas, using leading survey methodology and project management techniques, as well as state-of-the-art technical systems.

This position is part of the SRO Finance Group. For additional information on SRC and SRO, please visit our websites at http://www.src.isr.umich.edu and http://www.src.isr.umich.edu/services/survey-research-operations/.

Responsibilities*

25% Perform data analysis as required for projects or department on a variety of financial related topics such as payroll, human resources, revenue, procurement, etc. Conduct routine and ad hoc analyses on a specific project as well as across projects and departments. Query and summarize datasets accurately for project managers. Monitor the general accounting of project accounts and initiate appropriate corrections. Monitor overall account balance on projects as well as status of invoice payments. Monitor and communicate with project team on project spending requirements such as carryforward restrictions, smoothing and small business spending requirements.

25% Enter and maintain project level budget and projection data in department cost reporting system. Provide standard as well as customized reports to managers on a regular basis. Perform projection analysis using cost data from past projects, budget assumptions and current work scope assumptions. Create accurate projections of project future expense.

25% Initiate the set-up of account structures to support the required level of data needed to perform analysis. Monitor the active status of accounts and process account closeout when necessary. Maintain an archive of financial documents as related to sponsored projects. Provide information as requested in a timely manner to financial operations.

15% Conduct audits of financial transactions, reconcile various department accounting processes and initiate corrections. Review proposal documents and take appropriate action based on specific sponsor requirements. Monitor proposal budget allocations against MPathways Budget Ledger budget allocation. Maintain department’s various reconciliation processes and perform necessary accounting corrections. Also responsible for various financial reports and controls.

10% Some finance database maintenance support.

Required Qualifications*

B.A. degree in a field related to business or finance, and 2-5 years of experience with an emphasis in either accounting or finance or an equivalent combination of work experience and education.
Demonstrated competency with Excel and database software to perform financial reporting and management.
Demonstrated ability to work collaboratively with staff at all levels with varying degrees of financial management knowledge and experience.
Desired Qualifications*

Experience performing financial analysis in a project based environment.
Experience with database design and query writing.
Detailed knowledge of University financial systems and processes.
Detailed knowledge of University financial data warehouse or large-scale financial data sets.