Business Intelligence & Analytics Analyst

UMass Amherst Foundation•Hadley, MA

1d•$95,000 - $105,000•Hybrid

About The Position

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. 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.

Requirements

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.

Nice To Haves

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.
Experience writing technical documentation or contributing to a data dictionary.
Familiarity with ETL concepts and data pipeline basics.

Responsibilities

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.
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.
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.
Supports UMAF's building and growing efforts with other duties and projects as assigned.