Business Intelligence Analyst

Summary

Business Solutions Analyst IntermediateLSA 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.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: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.A full job description can be found here.Required Qualifications*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?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 daysA retirement plan that provides two-for-one matching contributions with immediate vestingMany choices for comprehensive health insuranceLife insuranceLong-term disability coverageFlexible spending accounts for healthcare and dependent care expensesIn addition, LSA offers:Enhanced tuition support programs for LSA coursesStrong commitment to work/life balanceFlexible work arrangements with respect to campus stakeholder needsBeing 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 WorkPositions 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 InformationWork 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 ScreeningThe 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 DeadlineJob 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 StatementThe 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.

Job Description

Business Solutions Analyst IntermediateLSA 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.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: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.A full job description can be found here.Required Qualifications*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?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 daysA retirement plan that provides two-for-one matching contributions with immediate vestingMany choices for comprehensive health insuranceLife insuranceLong-term disability coverageFlexible spending accounts for healthcare and dependent care expensesIn addition, LSA offers:Enhanced tuition support programs for LSA coursesStrong commitment to work/life balanceFlexible work arrangements with respect to campus stakeholder needsBeing 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 WorkPositions 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 InformationWork 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 ScreeningThe 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 DeadlineJob 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 StatementThe 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.