Business Intelligence & Analytics Analyst

**About University of Massachusetts Amherst Foundation** Established in 2003, thehttps://www.uma-foundation.org/[University of Massachusetts Amherst Foundation](https://www.uma-foundation.org/) (UMAF), a private 501(c)(3) nonprofit organization, exists to raise philanthropic funds in support of the University of Massachusetts Amherst’s mission and highest aspirations. Located on the Amherst campus and wholly dedicated to supporting the University’s mission, UMAF is a separately governed nonprofit organization with its own health, wellness, and retirement benefits. UMAF serves the University of Massachusetts Amherst community by serving as a best practices resource for fundraising strategy and implementation. **About the role** The BI & Analytics Analyst sits within the Advancement Operations division and reports directly to the AVP of Advancement Operations. This is a hands-on individual contributor role responsible for building, maintaining, and improving UMAF's reporting and data assets. The Analyst works primarily in Tableau and Snowflake, building dashboards and reports that give advancement staff and leadership reliable, reconciled data. They contribute to a self-serve reporting environment by supporting data documentation and data quality work across the team. This role is a good fit for someone who cares about getting numbers right, can trace a figure back to its source, and finds satisfaction in turning messy data into something a non-technical person can act on. The right candidate asks "what are we actually trying to understand?" before writing the first query. They use AI tools as a natural part of their workflow, document as they go, and don't stop at the surface answer when something doesn't add up. Advancement domain knowledge is useful but not required — strong analytical habits and business curiosity travel well across industries. ***Location*** *: This is a full-time hybrid position and is open to employees in select US states: Massachusetts, New York, Connecticut, Rhode Island, New Jersey and New Hampshire.* **What you'll do** **Reporting & Visualization (35%)** • Builds and maintains Tableau dashboards and reports supporting fundraising performance, donor engagement, and advancement operations tracking. • Prepares ad hoc data pulls and analysis in response to requests from advancement staff and leadership. • Validates and reconciles report outputs against trusted data sources before delivery. • Designs visualizations that are clear and actionable for non-technical audiences. **Data Analysis & Quality (30%)** • Writes SQL queries in Snowflake to extract, transform, and analyze advancement data. • Identifies and documents data quality issues, working with team members and data stewards to resolve them. • Supports the development and maintenance of Snowflake reporting views used across the team's reporting stack. • Participates in reconciliation processes that verify key metrics against authoritative sources. **Documentation & Self-Serve Support (25%)** • Contributes to UMAF's data dictionary and documentation library, keeping field definitions and reporting logic current. • Documents query logic and dashboard methodology so others can understand and reproduce the work. • Supports the development of UMAX (Salesforce Education Cloud) reporting resources and end-user guides. • Assists with training and support for advancement staff using self-serve reporting tools. • Uses AI tools to accelerate analysis, draft documentation, and explore data questions — and shares that fluency with the team. **Other Duties as Assigned (10%)** UMAF is building and growing, and this position will support those efforts with other duties and projects as assigned from time to time. **Qualifications** **Required:** • Bachelor's degree in data analytics, computer science, statistics, business, or a related field, or equivalent professional experience. • Experience writing SQL queries against relational databases. • Experience building…