Financial Data Analyst
HERC
Ann Arbor, MI (In Person)
Full-Time
Skill Insights
Compare your current skills to what this opportunity needs—we'll show you what you already have and what could strengthen your application.
Job Description
A cover letter and resume are important submissions for the hiring team to get a sense of your experience. A cover letter is required to be considered for this position. In the cover letter, please let us know how this position will align with your career aspirations and skills. Submit both a cover letter and resume as one file (because of system limitations). For questions about this role or accommodation requests, contact talent.acquisition@umich.edu The primary function of this Financial Data Analyst position is to provide data-driven insights and process leadership for complex initiatives. While the primary focus is financial aid and gift fund planning, you will also support other operational workflows requiring heavy data compilation, financial modeling, and strategic coordination. Reporting to the Director of Analytics and IT, you will leverage your analytical background to create financial plans, forecasts, budgets, coordinate process execution, and improve workflows. As a newly created role, this position offers an exciting opportunity to help define and shape an important area of work. The responsibilities may evolve over time as priorities develop, making this an ideal opportunity for someone who is adaptable, innovative, and eager to contribute to something new. A link to the full job description can be found here . Lead the financial aid planning and disbursement process, ensuring deadlines are met and awards are processed accurately and efficiently. Monitor scholarship fund balances, forecast annual aid spending, and support financial aid budget development. Collaborate with Student Affairs, Finance, Development, HR, and Graduate Student Affairs to allocate, document, and manage aid funding. Conduct budget-to-actual variance analysis, investigate discrepancies, and recommend adjustments. Manage pooled operational budgets and adapt plans based on funding or strategic changes. Fulfill complex data requests and conduct ad hoc analysis to support decision-making and benchmarking. Develop dashboards, scheduled reports, and visualizations using tools such as BusinessObjects, Tableau, and Google Data Studio. Serve as a business intelligence resource for Finance and partner departments, supporting data integrity and standardized reporting. Build self-service reporting resources, technical guides, process documentation, templates, and operational checklists. Improve workflows and team efficiency using tools such as Google Workspace, Wrike, Asana, or TeamDynamix. Bachelor's degree in Finance, Business Administration, Data Analytics, Economics, or a related field, with an understanding of financial and analytical principles. 2+ years of professional experience in data analysis, financial modeling, business operations, or a related analytical role. Experience creating financial forecasts, budgets, and long-term models. Advanced proficiency in using spreadsheet software (e.g., Excel, Google Sheets) to manipulate large datasets, vlookup, create pivot tables, build financial models, and analyze complex data. Experience using reporting or Business Intelligence tools (e.g., Business Objects, Tableau, Google Data Studio or similar tools). Experience coordinating administrative processes, managing project timelines, or driving workflow improvements. Job openings are posted for a minimum of seven calendar days. The review and selection process may begin as early as the eighth day after posting. This opening may be removed from posting boards and filled any time after the minimum posting period has ended. The University of Michigan is an equal employment opportunity employer.