Apply Now Clicking "Apply Now" opens the link in a new window.

How to Apply

A cover letter is required for consideration for this position and should be attached as the first page of your resume. The cover letter should address your specific interest in the position and outline skills and experience that directly relate to this position. 

Job Summary

The Office of Budget and Planning that directly supports the Provost and Executive Vice President for Academic Affairs is seeking an innovative thinker and intellectually curious Business Intelligence (BI) Analyst Senior/Intermediate to join our dynamic and fast-paced Institutional Research team.  This position will assist the University in making strategic, data-related decisions by transforming data into information through statistical analysis, verification, and visual, contextual reporting of university data in areas such as tuition, student enrollment and admissions, student outcomes, faculty and human resources, budget and finances.  Through an understanding of university data and how its integration and analysis can inform decision-making, the BI Analyst Senior/Intermediate will analyze, interpret, and verify research results to assist in the development of policy recommendations.  Must grasp the complexity of data management, have a strong understanding of databases and data analysis procedures, and data integration techniques.  Assist in the management and administration of the design and development of data structures, standards of data use, data models, and audit techniques in partnership with data stewards.  Participate in industry/knowledge reference groups and strategic assessment to identify current/emerging business issues/problems and contribute to defining high impact business intelligence solutions with a focus on the quantitative methods, modeling and analytical techniques.  Participate in business process improvement discussions and provide advice on potential resolutions including gathering the support necessary for initiatives.  Develop and present reports and definitions, graphs, dashboards, and portal interfaces appropriate for the audience.  


Respond to requests for information and studies from leadership in a timely manner.   Be able to determine the appropriate sources of data and then adeptly obtain and synthesize results into talking points that address the original request.  Be able to offer reasonable alternatives when necessary.

Interpret data, analyze results using statistical techniques in response to specific topics related to current events or university policy.  Identify and synthesize meaning from trends and patterns of complex data sets.  Understand the principles behind encoding data and communicating information that is complex so that it is concise and straight forward for decision-makers.

Remain current on trends that affect higher education and assist the Associate Director and Executive Director on the appropriate responses. Perform environmental scanning to proactively identify developments that affect higher education and the university, in particular and prepare talking points for leadership in response.  Develop and maintain relationships with organizations within the university and outside that are conducting education research and evaluation.   Assist in the development of business practices to collect and store benchmarking data for our peers and other institutions of interest for quick and easy retrieval.

Acquire data from primary and secondary data sources and establish data marts or other ways to organize data for easy retrieval into a variety of office systems for the benefit of the IR and Budget teams within OBP.   Proactively promote business practices that contribute to a team environment.

Assist the office and data stewards in improving data quality through a variety of techniques and methods such as audit reports, identification of derived data elements to include in data warehouses to improve the report writer experience, and advocacy for new or improved business practices of data collection.

Assist office to establish standards and business processes for reporting including template design, visualization, data models, query libraries, and data dictionaries appropriate to support Institutional Research and the budget, planning and management functions of the university.  Contribute to an information library or similar format which promotes sharing of information with other institutional researchers at the university.  Contribute to data dictionaries and other documentation required to understand information used by university leadership, Institutional Research and the budget planning process.

Required Qualifications*

Bachelor’s degree with proven experience in data analysis; extremely detail oriented with the ability to recognize and investigate data anomalies; ability to understand complex business processes and the inter-relatedness of data across an organization; competence in query language and working with complex data warehouses and data models; demonstrated ability to produce visualizations of data using a common software package; sound organizational skills and the ability to successfully multi-task in a dynamic, fast-paced environment; excellent communication and collaboration skills; competence in interpreting and representing numeric data; ability to write and speak clearly when communicating complex ideas and conclusions to leadership; demonstrated strong interpersonal skills with proven ability to coordinate and work effectively with numerous units and staff at various levels; proficiency and familiarity with modern database and information system technologies; strong knowledge of and experience with reporting packages (Business Objects, etc.), databases (SQL, Microsoft Access, etc.).

Desired Qualifications*

Master’s degree; experience working in higher education with some knowledge of UM structure, policies, procedures and institutional data warehouses; programming (XML, JavaScript, or ETL frameworks); knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS, etc.)

Additional Information

Applications will begin to be reviewed October 16, 2017

Application Deadline

Job openings are posted for a minimum of seven calendar days. This job may be removed from posting boards and filled anytime after the minimum posting period has ended.

U-M EEO/AA Statement

The University of Michigan is an equal opportunity/affirmative action employer.