Business Intelligence Analyst Intermediate

Apply Now

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.

For a full and detailed job description, please click here

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.