How to Apply
A cover letter and resume are important submissions for the hiring team to get a sense of your experience and skill set. Submit both a cover letter and resume as one file.
The review of resumes will begin when the posting closes. Applicants selected for an interview will be contacted via email. The interview process will consist of an initial 45-minute screening interview and one or two additional interviews for select candidates. Additionally, samples of relevant work may be requested.
The Taubman College of Architecture and Urban Planning is looking for a financial analyst intermediate to transform the way data is sourced, analyzed, and organized to guide strategic decision making across the college. You are someone with experience building complex financial models, what-if scenarios,and transforming data into comprehensible information through statistical analysis, verification, and visual/contextual reporting. Reporting directly to the chief financial officer (our organizational chart), you will work as a member of the finance team to perform complex business/financial analysis, build dashboards and organize data across multiple units. You will present data in a clear and compelling visual way that allows for decisive action.
You are proficient in and with minimal support can:
- Work with tools to pull data
- Understand accounting, budgeting and financial projections
- Build predictive financial analytical models
- Connect the dots between financial, HR, student, enrollment, facilities data, etc.
- Reveal the patterns of data and draw data-supported conclusions
- Organize data and build dashboards and other data visualizations
- Be detailed oriented
This job is situated in Ann Arbor and on-campus work is required three days a week, with a few fully remote weeks throughout the academic year as well as a fully remote period from mid-May to mid-August.
- Build complex financial models with multiple intersecting data sources/methodologies/flows and manage datasets.
- Develop comprehensive understanding of Taubman College's financial/HR/student data sets and systems, the university's enterprise-wide data warehouse, and departmental reporting structures to support institutional and hoc data analysis and report requests.
- Lead the development, implementation and management of a new financial modeling system using the tool Synario which allows for real-time what-if scenario analysis using complex logic.
- Make recommendations to integrate and improve the management, organization and presentation of data across multiple college domains including finance, human resources, student affairs and admissions.
- Create graphical representations including dashboards, infographics and reports.
- Provide back up to the senior financial specialist and financial manager.
- Bachelor's degree in finance, accounting, or related financial field
- 7+ years of overall work experience
- 3+ years experience creating complex financial models and conducting financial analyses for executive decision-making
- 3+ years proficiency in query design and report writing tools like Tableau, Business objects, SQL, SAS
- 3+ years experience with creating data visualization techniques for reporting purposes, developing dashboards and reports
- Expertise in storytelling and understanding of financial and other complex data sets
- Knowledge of database structures and data architecture relevant to the development of dynamic reporting.
- Advance proficiency using Excel (can perform complex functions), financial reporting tools and financial systems, and visualization/analytics
The salary for this position is $60,000 - 75,000. Factors used to determine salary include experience, knowledge and skills for the position. You are encouraged to discuss salary questions to honor transparency throughout the recruiting process.
In addition to a career filled with purpose and opportunity, U-M offers a comprehensive benefits package to help you stay well, protect yourself and your family, and plan for a secure future. Benefits include generous time off; retirement plan with two-for-one matching contributions after the first year; many choices for comprehensive health insurance; life insurance; long-term disability coverage; and flexible spending accounts for healthcare and dependent care expenses. Learn more about U-M benefits.
Commitment to Diversity, Equity, and Inclusion
Taubman College values a diverse group of students, faculty, staff, and administrators that includes people of different race and ethnicity, national origin, gender and gender expression, socioeconomic status, sexual orientation, religious commitment, age, and disability status. We aim to create a community of mutual respect and trust where everyone's backgrounds, identities, and views are represented without any threat of bias, harassment, intimidation, or discrimination. Learn more about our DEI efforts and the shared values we have for our community.
U-M EEO/AA Statement
The University of Michigan is an equal opportunity/affirmative action employer.