Business Intelligence & Analytics Analyst

UMass Amherst Foundation; Hadley (MA); Hybrid; USD 95,000 - 105,000; Full time

Benefits offered by this job

20 vacation days

4-day summer work week

401(k) with match

Health insurance

Parental leave

Accommodation for work-life balance

Job summary

UMass Amherst Foundation (UMAF) seeks a BI & Analytics Analyst to build and maintain dashboards and data assets, ensuring accuracy and traceability. The role emphasizes Tableau, Snowflake, and data documentation to enable self-serve reporting for advancement staff and leadership.

The position is full-time and hybrid, open to select US states, with a salary range of $95,000–$105,000 per year. Collaboration with the Advancement Operations team is key, using AI tools to accelerate analysis and

Qualifications

• Bachelor’s degree in a related field or equivalent professional experience.
• Experience writing SQL queries against relational databases.
• Experience building Tableau dashboards or comparable tools.
• Attention to data accuracy and integrity.
• Ability to document query logic and methodology for reproducibility.
• Active use of AI tools in analytics and documentation workflows.
• Strong communication of analytical findings to non-technical audiences.

Responsibilities

• Builds and maintains Tableau dashboards and reports to support fundraising performance and operations.
• Prepares ad hoc data pulls and analysis for leadership.
• Validates outputs against trusted data sources.
• Designs visualizations that are clear and actionable for non-technical audiences.
• Writes SQL queries in Snowflake to extract and analyze data.
• Documents data quality issues and supports data dictionary efforts.
• Contributes to self-serve reporting resources and end-user guides.
• Assists with training and support for advancement staff.

Skills

Tableau dashboards

SQL queries

Data accuracy

Non-technical communication

AI tools usage

Documentation practices

Data storytelling

Education

Bachelor's degree or equivalent

Tools

Snowflake

Salesforce CRM

Job description

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 [e-mail] 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 the culture where the team be‑ t‑re? Wait.

Questions regarding the position or anything else related to careers with UMAF may be directed to the People & Culture team at [e-mail]