Business Intelligence & Analytics Analyst
Uma Foundation
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
Job summary
University of Massachusetts Amherst Foundation is seeking a Business Intelligence & Analytics Analyst to build, maintain, and improve UMAF's reporting and data assets in a hands-on role.
The role focuses on Tableau and Snowflake, delivering dashboards for fundraising performance and donor engagement, while supporting a self-serve reporting environment and accurate data documentation for non-technical audiences.
Qualifications
- Bachelor's degree or equivalent experience in data analytics, CS, statistics, or business.
- Experience building Tableau dashboards or similar data visualization tools.
- Strong attention to data accuracy and traceable data lineage.
- Ability to document query logic and dashboard methodology.
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.
Skills
Education
Tools
Job description
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.
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.
- 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.
UMAF is building and growing, and this position will support those efforts with other duties and projects as assigned from time to time.
- Bachelor's degree in data analytics, computer science, statistics, business, or a related field, or equivalent professional experience.
- 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.
- 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.
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.
- 20 vacation days, 12 holidays, 12 sick days, 5 personal days, and 2 office closure days.
- 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.
$95,000 - $105,000
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.
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
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
