How to Apply
You must apply through the UM Jobs website (umjobs.org/). In addition to your resume, please submit a cover letter. Your resume and cover letter will be used for the initial screening process.
- Please limit your cover letter to one page.
- In the body of your letter, please tell us what you love about working with SQL and what excites you most about working in a higher education setting.
- Please submit your cover letter and resume together as a single electronic document (a PDF is best, if possible), as the system will accommodate only one attachment.
Interview Timeline and Structure
We will be conducting Round 1 (Phone) Interviews, Round 2 (Zoom) Interviews, and Round 3 (Skills Assessment) through February and March, with an anticipated start date in late April.
Salary and work location
This is an intermediate-level position with a salary range of $70,000 - $75,000. Salary is determined by direct relevant experience and demonstrated past performance results 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 minimum, in-person quarterly all-staff retreats and team planning sessions.
Job Summary
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 80 professionals building a positive work environment that supports the excellence and transformative power of the college's liberal arts mission through values-based fundraising, marketing, and communications. To learn more about our culture, what we do, and our commitment to diversity, equity, and inclusion, visit our Join Our Team Website.
At the heart of the Advancement Business Solutions team, curiosity and exploration drive our pursuit of excellence. We believe in the power of data and collaboration to create transformative change. By fostering an environment where questions lead to insights and innovation thrives, we equip LSA Advancement and the college with the tools, confidence, and knowledge to inspire meaningful donor relationships, optimize engagement strategies, and achieve sustainable growth. Guided by a shared commitment to learning and exploration, we bridge the gap between data and strategy, empowering our 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 environment. Who enjoys building a comprehensive understanding of a business's end-to-end needs through continuous learning and curious exploration. Who geeks out over telling stories by developing complex SQL and insightful data 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 embodies integrity and values 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 and Assistant Director of Advancement Business Solutions.
Specific responsibilities include:
As the Business Solutions Analyst Intermediate, you will...
- Build a comprehensive understanding of Advancement's business and processes across all teams.
- Write complex SQL queries, build ad hoc reports, and design data visualizations.
- Lead and conduct data analysis that informs strategic direction.
- Identify and participate in data integrity projects; develop, run, and analyze audit reports to ensure the health of LSA's alumni and donor data.
- Consult with teams across Advancement and the college as a subject matter expert.
- Develop and maintain positive and meaningful relationships through your interactions with Advancement colleagues and strategic partners.
A full job description can be found here.
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.
Why Work at Michigan?
In addition to a career filled with purpose and opportunity, the University of Michigan offers a comprehensive benefits package to help you stay well, protect yourself and your family, and plan for a secure future. Benefits include:
- 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's adding a purpose to your profession. Work at Michigan and become a victor for the greater good.
You can see a summary of the benefits you will be eligible to receive here.
Required Qualifications*
Here are the things you already have:
- Bachelor's degree or equivalent combination of education and work experience.
- 3 or more years of experience working as a business intelligence or data analyst or similar.
- Working knowledge of business productivity tools (Excel and Google Spreadsheets - perform complex functions and macros).
- Proven ability in developing complex Structured Query Language (SQL) queries to retrieve, analyze, and understand large data sets.
- Experience with databases, reporting, and data visualization software (Tableau preferable).
- Experience in data management and manipulation, including data mining and segmentation techniques.
- Experience working with confidential data.
Not sure you meet all qualifications? Let us decide! Research shows that women and members of other under-represented groups 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 a diverse and inclusive environment and strongly encourage you to apply.
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
Individuals who are women, LGBTQIA+, Black, Indigenous, people of color, disabled, or veterans are encouraged to apply.
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 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 diversity, equity, and inclusion in LSA, please visit lsa.umich.edu/lsa/dei.
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 anytime after the minimum posting period has ended.
U-M EEO/AA Statement
The University of Michigan is an equal opportunity/affirmative action employer.