University of Michigan | Hiring | Senior Business Intelligence Analyst | Ann Arbor, MI | United States | BigDataKB.com | 12 Oct 2022

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.

Summary

The Taubman College of Architecture and Urban Planning is looking for a senior business intelligence analyst to transform the way data is sourced, analyzed, and organized to guide decision making across the college. You are someone with experience building complex financial models, what-if scenarios, 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 with the Business Services team to perform complex business 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.

This job is situated in Ann Arbor and on-campus work is expected three days a week.

Responsibilities*

• 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.

Required Qualifications*

• Bachelor’s degree in finance, accounting, or related field
• 3 or more years proficiency in query design and report writing tools like Tableau, Business objects, SQL, SAS
• 3 or more 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

Additional Information

The salary range for this position is $90,000 – $100,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.

U-M COVID-19 Vaccination Policy

COVID-19 vaccinations, including one booster when eligible, are required for all University of Michigan students, faculty and staff across all campuses, including Michigan Medicine. This includes those working remotely and temporary workers. More information on this new policy is available on the U-M Health Response website or the UM-Dearborn and UM-Flint websites.