Business Intelligence Analyst, Intermediate

University of Michigan; Ann Arbor (MI); Hybrid; USD 75,000 - 110,000; Full time

Job summary

The University of Michigan is seeking a Business Intelligence Analyst to support fundraising analytics, reporting, and data quality within the Integrated Data Services team. You will maintain ad hoc reports, dashboards, and respond to requests, translating needs into technical solutions across the DART ecosystem.

This hybrid role requires office presence twice weekly at Michigan House, Ann Arbor, MI, with an end date of 06/30/2029 for this term-limited position.

Qualifications

• Bachelor's degree in business information systems, CS, statistics, mathematics, or related field or equivalent experience.
• 3+ years as a data analyst, business systems analyst or BI analyst.
• Experience with Tableau, SAP BusinessObjects, or other data visualization/reporting tools.
• Intermediate knowledge of SQL and Microsoft SQL Server, data dictionaries, standards, and metadata.
• Proficiency with Excel and Google Sheets advanced functions.
• Experience with data quality analysis, governance and stewardship.
• Ability to share knowledge with nontechnical colleagues.

Responsibilities

• Develop, test, document, implement, and maintain queries, reports, dashboards using SQL Server, SAP BO, DART Query, Tableau and other tools.
• Design data structures and extracts to support data collection, loading, reporting and complex analysis.
• Analyze business and user needs, document requirements, and troubleshoot complex report logic.
• Complete university-wide analytics projects and contribute to new ones.
• Analyze data quality, identify issues and opportunities, and help implement standards and sustainable solutions.
• Manage requests in TeamDynamix and fulfill ad hoc reporting and data updates.
• Answer questions and present dashboards, findings, and solutions to stakeholders.
• Lead discovery sessions to align solutions with team goals and build relationships.
• Help develop IDS processes, standards and educational materials for DART data integrity.
• Recommend data, system and process improvements and participate in DART upgrades and testing.

Skills

Tableau

SAP BusinessObjects

SQL

Microsoft Excel

Google Sheets

Data quality analysis

Data governance

Data stewardship

Knowledge sharing

Education

Bachelor's degree in related field

Tools

SQL Server

DART Query

Tableau (data viz)

Job description

Job Summary

A Cover Letter is required for consideration for this position. When submitting, please include the cover letter as the first page of your resume and submit as one document.

As a Business Intelligence Analyst on the Integrated Data Services team, you will partner with the U-M Development Community to support fundraising through reporting, analytics, and data quality. You will maintain ad hoc reports and dashboards, respond to ticketed requests, and translate community needs into technical solutions. Through technical analysis and University data quality projects, you will identify improvements. These improvements will help keep development data accurate, reliable, and usable. This includes data in the Donor and Alumni Relationship Tool (DART), which is used across the Development Community. You will report to the Business Intelligence Analyst, Senior, in this role.

Please Note: This is a Hybrid Role, and we work in office twice per week. Our new office is located at Michigan House: 2301 Commonwealth Blvd, Ann Arbor, MI 48105.

This is a Term Limited Role, with an end date of 06/30/2029.

Responsibilities

• Develop, test, document, implement, and maintain queries, reports, visualizations, and community-wide dashboards using SQL Server, SAP BusinessObjects, DART Query, Tableau, and other reporting tools.
• Design data structures and extracts that support comprehensive data collection, loading, reporting, and complex analysis.
• Analyze business and user needs, document requirements, develop sustainable technical solutions, and troubleshoot complex report logic.
• Complete university-wide analytics projects and contribute to new projects.
• Analyze data quality; identify issues, causes, impacts, and improvement opportunities; and help implement University standards, corrective processes, and sustainable solutions.
• Manage competing requests in TeamDynamix, provide frontline support, and independently fulfill ad hoc reporting, data update, and information retrieval requests using technical tools, reports, and programs.
• Answer questions, advise users, technical staff, and vendors, and resolve complex data, reporting, and application issues. Deliver updates on progress, timelines, findings, and solutions.
• Lead discovery sessions to align solutions with team goals, build relationships, and serve as a trusted resource. Present dashboards, reports, findings, and solutions to the Development Community, peer institutions, and departments.
• Help develop IDS processes, standards, procedures, documentation, and educational materials, including guidelines supporting DART data integrity, consistency, and usability.
• Recommend data, system, and business process improvements and participate in DART upgrade and other system testing.

Required Qualifications

Bachelor's degree in business information systems, computer science, statistics, mathematics, or a related field, or an equivalent combination of education and professional experience.

Three or more years of experience as a data analyst, business systems analyst, business intelligence analyst, or in a similar role.

Experience using Tableau, SAP BusinessObjects, or other data visualization and reporting software.

Intermediate knowledge of SQL, Microsoft SQL Server, and relational database concepts, including data dictionaries, data standards, and metadata management.

Proficiency with business productivity tools, including advanced functions in Microsoft Excel and Google Sheets.

Experience with data quality analysis, data governance, and data stewardship

Experience sharing knowledge with colleagues in a nontechnical but meaningful way.

Modes of Work

Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about the work modes.

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

U-M EEO Statement

The University of Michigan is an Equal Opportunity Employer. We are committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants, including protected veterans and individuals with disabilities.