Hybrid BI Analyst – Dashboards, SQL & Data Quality

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

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.