BI Analyst Senior

Apply Now

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.


The Office of Budget and Planning is looking for a business intelligence analyst senior to join our Institutional Research team.   This position will focus on supporting and expanding the metrics and Tableau dashboards created by the office to support leadership needs on the Ann Arbor campus.    Use business intelligence data and tools to transform data into information through visual and contextual reporting of university data in areas such as tuition, student enrollment and admissions, student outcomes, faculty and human resources, budget and finances.  Assist in the management and administration of the design and development of data models, and audit techniques in partnership with data stewards.  Participate in business process improvement discussions and provide advice on potential resolutions.  If you have a passion for discovering information hidden in large data sets and for working with stakeholders to improve business outcomes then you will want to apply.

Mission Statement

The mission of the University of Michigan is to serve the people of Michigan and the world through preeminence in creating, communicating, preserving, and applying knowledge, art, and academic values, and in developing leaders and citizens who will challenge the present and enrich the future. The University of Michigan is committed to fostering learning, creativity, and productivity, and to supporting the vigorous exchange of ideas and information, not only in the classroom but in the workplace by:

  • Creating a work environment in which people treat each other with respect and dignity, regardless of roles, responsibilities, or differences.
  • Providing support, direction, and resources enabling us to accomplish the responsibilities of our jobs and to reach the goals that are set for professional and personal growth.

Why Work at Michigan?

In addition to a career filled with purpose and opportunity, the University of Michigan 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, including vacation time, sick time, holiday and season days
  • A retirement plan that provides two-for-one matching contributions with immediate vesting
  • Many choices for comprehensive health insurance
  • Life insurance
  • Long-term disability coverage
  • Flexible spending accounts for healthcare and dependent care expenses

In addition, OBP provides:

  • Strong commitment to work/life balance
  • Flexible work arrangements with respect to campus stakeholder needs

Being part of something greater, of serving a larger mission of discovery and care — that's the heart of what drives people to work at Michigan. In some way, great or small, every person here helps to advance this world-class institution. It's adding a purpose to your profession. Work at Michigan and become a victor for the greater good.


Respond to requests for information and studies from leadership in a timely manner.   Be able to determine the appropriate sources of data and then provide recommendations for data management and the design of dashboards and reports.  Develop interactive queries and Tableau dashboards for use by leadership.

Deliver graphical presentations (dashboards, reports, portal interfaces) of data from a variety of data sources.  Understand the principles behind encoding data and communicating information that is complex so that it is concise and straight forward for decision-makers.

Troubleshoot business intelligence environment problems and opportunities for improvement and coordinate with ITS to resolve bottlenecks and performance issues.

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.

Assist in the evaluation of the effectiveness and usefulness of the existing suite of Tableau dashboards and metrics and whether they are meeting the needs of leadership and campus community.

Required Qualifications*

  • Bachelor’s degree with proven experience in data analysis.
  • Five years of relevant experience in data analysis and data visualization using Tableau.
  • 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.
  • 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

The Office of Budget and Planning joins the University of Michigan in its commitment to recruiting, selecting, and retaining a diverse and highly engaged staff community. We strive to recognize, respect, and celebrate individual and collective differences and strengths to foster an inclusive environment. To learn more about our commitment to diversity, equity, and inclusion, please visit our website.

Application Deadline

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 anytime after the minimum posting period has ended.

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.