Business Intelligence & Analytics Analyst

About University Of Massachusetts Amherst Foundation Established in 2003, the University of Massachusetts Amherst Foundation (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 Tableau dashboards or comparable data visualization tools. Strong attention to detail and demonstrated commitment to data accuracy. Investigative mindset — follows a data question until the underlying logic is understood, and flags when a number warrants a closer look. Demonstrated habit of documenting query logic and methodology so others can trace and reproduce the work. Active user of AI tools (such as Claude, ChatGPT, Copilot, or Cortex) as part of analytical and documentation workflows. Ability to communicate analytical findings clearly to non-technical audiences. Excellent written, verbal, and interpersonal communication skills. High degree of integrity, demonstrating respect for individuals at every level of an organization. Ability to work effectively both independently and as a member of a team. Preferred Experience with Snowflake or other cloud data warehouse platforms. Familiarity with Salesforce or advancement/fundraising CRM systems. Experience in higher education, nonprofit fundraising, or a mission-driven organization. Domain knowledge in advancement is a plus; strong analytical instincts and documentation habits are weighted more heavily. Experience writing technical documentation or contributing to a data dictionary. Familiarity with ETL concepts and data pipeline basics. Note: We’re passionate about building a diverse team. If your experience is close, but not an exact match, please consider applying. Experience comes in many forms, and skills are transferable. We know that diverse teams make better decisions and deliver better results, which is why we’re committed to adding new perspectives and encourage everyone to apply. Benefits 20 vacation days, 12 holidays, 12 sick days, 5 personal days, and 2 office closure days.4-day summer work week.401(k) plan. You contribute 5% and receive a 10% match.Health insurance packages for medical, dental, and vision.16 weeks of paid parental leave to use within 1 year of childbirth. An additional 6 weeks available for the birthing parent. Part-time work for full-time pay for the first 4 weeks post parental leave.Learn more about our benefits. Proposed Annual Salary Range $95,000 - $105,000 DIVERSITY, EQUITY AND INCLUSION At the UMass Amherst Foundation, we understand the value that diversity, equity, and inclusion bring to our workplace, our constituents, and our community. We welcome and value diversity in all its forms and recognize that a diverse and inclusive team strengthens our work and advances our mission. We recognize that the benefits of a diverse team are fully realized when people of all races, gender identities, ages, ethnicities, cultural heritages and nationalities; educational backgrounds; religious and political beliefs; sexual orientations; abilities; and socioeconomic and veteran status are valued, respected, and included at every level. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact careers@uma-foundation.org to request accommodation. OUR VALUES Connection Build meaningful relationships rooted in trust, respect, and belonging. Courage Show up with integrity, embrace challenges, and lead through uncertainty. Curiosity Commit to learning—for yourself and others—and create a culture where everyone can thrive. Questions regarding the position or anything else related to careers with UMAF may be directed to the People & Culture team at careers@uma-foundation.org