> Markdown version of [/jobs/ext/4409669-bi-analyst-intermediate](https://www.wearedevelopers.com/jobs/ext/4409669-bi-analyst-intermediate). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# BI Analyst Intermediate

- **Company:** University of Michigan
- **Location:** Ann Arbor, MI, United States (Remote available)
- **Experience:** Experienced
- **Salary:** $66,000.0 - $77,000.0
- **Contract:** Temporary contract
- **Skills:** Microsoft Excel, Databases, Data Integrity, Data Structures, Data Systems, Productivity Software, SQL Databases, Tableau (Software), Freeform SQL, Macros, Sap Business Objects, Data Analytics, Dart, Tools for Reporting
- **Published:** October 12, 2026
- **Apply:** https://careers.umich.edu/job_detail/apply/284245

## About the Role

Here are the things you already have:

 * Bachelor's degree or an equivalent combination of education and work experience.
 * 2.5 or more years of experience working as a business intelligence analyst, data analyst, or in a similar analytical role. Candidates with direct experience performing data analysis within a higher education advancement or fundraising environment are encouraged to apply.
 * Demonstrated proficiency in developing intermediate-to-advanced SQL queries to analyze complex datasets.
 * Experience analyzing datasets to identify trends, patterns, and insights that support decision-making.
 * Experience translating customer requirements into data-driven solutions.
 * Working knowledge of business productivity tools, including Excel and Google Sheets, with the ability to perform complex functions and create macros.
 * Experience working with databases, reporting tools, and data visualization software (Tableau preferred).
 * Experience working with confidential data while maintaining discretion and data integrity.

## Description

You will report to the Director with functional supervision from the Assistant Director of Advancement Business Solutions., As the Business Solutions Analyst Intermediate, you will...

 * Develop and deliver data insights that support fundraising, engagement, and stewardship. These insights include reports, dashboards, visualizations, and data exports. They are built with SQL, SAP Business Objects, Tableau, and DART/Blackbaud CRM.
 * Partner closely with Advancement colleagues and campus partners to understand goals across development, alumni engagement, and communications, translating those needs into clear, actionable data solutions.
 * Analyze and model data to strengthen donor pipelines, identify engagement patterns, support solicitation strategies, and help measure the effectiveness of Advancement operations.
 * Contribute to strategic business solutions by participating in needs assessments, applying quantitative and analytical methods, and supporting the presentation, demonstration, and training of Advancement tools and insights.
 * Support the integrity and long-term health of alumni and donor data through thoughtful data modeling, mapping, cleansing, auditing, and continuous improvement of data structures and processes.
 * Communicate insights in accessible ways that help our fundraisers, communicators, and leaders use data in decisions, planning, and outreach - regardless of technical background.
 * Work collaboratively and independently in a service-oriented environment, bringing curiosity, accuracy, and a commitment to inclusion, integrity, and shared success in support of the college's mission., The University of Michigan conducts background checks on all job candidates upon acceptance of a contingent offer and may use a third party administrator to conduct background checks. Background checks are performed in compliance with the Fair Credit Reporting Act.