Business Intelligence/Data Analyst (Hybrid)

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

Benefits offered by this job

Generous time off

Retirement plan with two-for-one match

Comprehensive health insurance

Life insurance

Long-term disability coverage

Flexible spending accounts

Job summary

The University of Michigan's LSA Advancement seeks a Business Solutions Analyst Intermediate to turn data into actionable fundraising insights. You will build reports, dashboards, and data visualizations using SQL, Tableau, and SAP Business Objects, partnering with campus colleagues to translate goals into solutions.

Responsibilities include modeling data, ensuring data integrity, and communicating insights to fundraisers and leaders.

Qualifications

• Bachelor's degree or equivalent combination of education and work experience.
• 2.5+ years of experience as a business intelligence/ data analyst or similar analytical role, preferably in higher education advancement or fundraising.
• Proficient 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 Excel and Google Sheets, with ability to perform complex functions and create macros.
• Experience with Tableau or similar data visualization tools.

Responsibilities

• Develop and deliver data insights that support fundraising, engagement, and stewardship through reports, dashboards, visualizations, and data exports.
• Partner with Advancement colleagues and campus partners to understand goals and translate into data solutions.
• Analyze and model data to strengthen donor pipelines and measure engagement and solicitation strategies.
• Contribute to strategic solutions via needs assessments and training of Advancement tools and insights.
• Ensure data integrity and long-term health of alumni and donor data through modeling, mapping, and auditing.
• Communicate insights in accessible ways to fundraisers, communicators, and leaders.
• Work collaboratively and independently in a service-oriented environment with curiosity and integrity.

Skills

SQL

Data analysis

Data visualization

Stakeholder communication

Education

Bachelor's degree

Tools

Tableau

SAP Business Objects

DART/Blackbaud CRM

Excel

Google Sheets

Job description

Interview Timeline and Structure

We will be conducting interviews via phone and Zoom throughout November and early December, with an anticipated start date in early January.

Salary and work location

This is an intermediate-level position with a salary range of $66,000 - $77,000. Salary is determined by direct, relevant experience and demonstrated past performance, while ensuring equity on the team.

Our office is located at 309 Maynard Street in Ann Arbor, Michigan. This position has the option to work on-site or hybrid (both remote and on-site) with the expectation that they will attend, at a minimum, in-person quarterly all-staff retreats and team planning sessions.

Mission Statement

The mission of the University of Michigan is to serve the people of Michigan and the world through preeminence in creating, communicating, preserving and applying knowledge, art, and academic values, and in developing leaders and citizens who will challenge the present and enrich the future.

Who we are

LSA Advancement champions the liberal arts at the University of Michigan by creating access and opportunities for learning, engagement, and giving that will improve the world. We are an office of more than 55 professionals building a positive work environment that supports the excellence and transformative power of the college’s liberal arts mission through values-based fundraising, stewardship, and alumni engagement. To learn more about our culture and what we do, visit our Join Our Team Website.

At the heart of Advancement’s Business Solutions team, curiosity and exploration fuel our pursuit of fundraising excellence. We believe in the power of data and collaboration to create transformative change for our students, faculty, and community. By promoting an environment where questions lead to insights and new ideas excel, we equip Advancement and the College of LSA with the tools, confidence, and knowledge to achieve sustainable fundraising growth. Guided by a shared commitment to learning and exploration, we bridge the gap between data and strategy, empowering our fundraising partners to unlock new potential, create lasting impact, and celebrate successes.

Who You Are

Someone who will find value in connecting your work to a greater purpose in a higher education fundraising environment. Who enjoys building a deep, end-to-end understanding of our fundraising and development work through learning and curiosity. Who geeks out over telling compelling stories with data, has SQL skills, and loves uncovering hidden insights to create impactful reports and visualizations. And enjoys helping out a teammate while having fun in the process. If this describes you, then look no further!

LSA Advancement wants someone like you, who practices purposeful and collaborative communication and who values integrity, trust, and authenticity, to be our next Business Solutions Analyst. Together, we will embody a team environment where exploration, common good, inclusion, well-being, integrity, collaboration, and creativity are at the forefront of our work.

You will report to the Director with functional supervision from the Assistant Director of Advancement Business Solutions.

Specific Responsibilities Include

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.

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.

Not sure if you meet all qualifications? Let us decide! Research shows that people tend not to apply to jobs when they think they may not meet every qualification, when, in fact, they often do! We are committed to creating an environment where everyone can succeed, and strongly encourage you to apply.

Why Work at Michigan?

Benefits

• Generous time off, including vacation time, sick time, holidays, and season days
• A retirement plan that provides two-for-one matching contributions with immediate vesting
• Many choices for comprehensive health insurance
• Life insurance
• Long-term disability coverage
• Flexible spending accounts for healthcare and dependent care expenses

In Addition, LSA Offers

• Enhanced tuition support programs for LSA courses
• Strong commitment to work/life balance
• Flexible work arrangements with respect to campus stakeholder needs

Being part of something greater, of serving a larger mission of discovery and care - that's the heart of what drives people to work at Michigan. In some way, great or small, every person here helps to advance this world-class institution. It adds purpose to your profession. Work at Michigan and become a victor for the greater good.

You can learn more about the benefits you will be eligible to receive at this website.

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.

Additional Information

Work Authorization

Authorization to work in the U.S. is a precondition of employment, and applicants for this position will not be sponsored for work visas.

As one of the world's great liberal arts and sciences colleges, LSA pushes the boundaries of what is understood about the human experience and the natural world, and we foster the next generation of rigorous and empathetic thinkers, creators, and contributors to the state of Michigan, the nation, and the world.

To learn more about LSA's Mission, Vision and Values, please visit lsa.umich.edu/strategicvision.

Background Screening

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.

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.