Business Intelligence Analyst, Intermediate

Michigan Giving; Ann Arbor (MI); Hybrid; USD 80,000 - 85,000; Full time

Job summary

The University of Michigan is seeking a Business Intelligence Analyst, Intermediate, on the Integrated Data Services team to support fundraising through reporting, analytics, and data quality. You will maintain ad hoc reports and dashboards, respond to ticketed requests, translate community needs into technical solutions, and contribute to data quality initiatives using DART.

This hybrid role reports to the Senior BI Analyst and involves presenting dashboards to the Development Community,

Qualifications

• Bachelor’s degree in a related field or equivalent experience.
• 3+ years as a data analyst/BI analyst or similar role.
• Experience with Tableau or SAP BusinessObjects.
• Proficiency with SQL and Microsoft SQL Server; relational DB concepts.
• Advanced Excel and Google Sheets skills.

Responsibilities

• Develop, test, and maintain queries, reports, dashboards using SQL Server, SAP BO, DART, Tableau.
• Design data structures and extracts to support data collection, loading, reporting, and analysis.
• Analyze needs, document requirements, and deliver technical solutions; troubleshoot complex reports.
• Contribute to university analytics projects and new initiatives.
• Analyze data quality, identify issues and improve standards; support data governance.

Skills

Tableau

SAP BusinessObjects

SQL

Excel

Google Sheets

Data quality analysis

Data governance

Data stewardship

Communication

Education

Bachelor's degree or equivalent

Tools

SQL Server

DART Query

Tableau

SAP BusinessObjects

Job description

Job Summary

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.

Job Opening ID
285638

Working Title
Business Intelligence Analyst, Intermediate

Job Title
BI Analyst Intermediate

Work Location
Ann Arbor Campus
Ann Arbor, MI

Modes of Work
Onsite
Hybrid

Full/Part Time
Full-Time

Regular/Temporary
Regular

FLSA Status
Exempt

Organizational Group
Vp For Development

Department
Campaign Planning & Services

Posting Begin/End Date
11/12/2026 - 12/03/2026

Salary
$80,000.00 - $85,000.00

Career Interest
Administration
Development/Institutional Advancement