Senior Director, Business Intelligence & Analytics

UMAF; Hadley (MA); Hybrid; USD 110,000 - 121,000; Full time

Benefits offered by this job

Vacation days

Holidays

Parental leave

Health insurance

401(k) match

Job summary

University of Massachusetts Amherst Foundation (UMAF) seeks a Senior Director of BI & Analytics to own data architecture, dashboards, and self-serve reporting. You will lead a team to deliver trusted leadership data, partner with IT and Salesforce Education Cloud, and drive data quality and governance.

You will leverage Snowflake, Tableau, and AI tools to enable data-driven decisions, build documentation, and create a culture of self‑serve reporting and strong operational insight across

Qualifications

• Bachelor's degree in computer science, information systems, data analytics, or related field, or equivalent experience.
• 5+ years in BI, analytics, or related field.
• Strong SQL and data warehouse experience (Snowflake preferred).
• Experience designing/building Tableau dashboards and data visualizations.
• Experience with CRM systems and fundraising/advancement databases.
• Ability to translate business questions into data investigations and findings.
• Documented ability to trace and reproduce methodologies.

Responsibilities

• Design, build, and maintain Snowflake reporting views and data pipelines.
• Partner with IT and UMAX to ensure reliable data flows between systems.
• Manage ETL processes and data warehouse architecture for reporting needs.
• Maintain data quality standards and reconciliation processes.
• Evaluate data tools and infrastructure against organizational needs.
• Use AI tools in analytical workflows and documentation.

Skills

SQL

Tableau

Snowflake

CRM systems

AI tools

Leadership

Analytics mindset

Education

Bachelor's degree in CS/IS/Data analytics

Tools

Snowflake

Tableau

Salesforce Education Cloud

CRM software

Job description

Senior Director, Business Intelligence & Analytics

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 Senior Director of BI & Analytics sits within the Advancement Operations division and reports directly to the Associate Vice President of Advancement Operations. The role is part of a small team responsible for UMAF's data infrastructure, reporting, and business intelligence capabilities, built primarily on Snowflake, Tableau, and Salesforce Education Cloud (UMAX).

This person owns the end-to-end pipeline from data architecture to dashboard delivery. In partnership with the AVP, they set the team's technical direction, maintain data quality standards, and build the documentation and self-serve reporting layers that let Foundation staff act on data without requesting one-off pulls.

A strong Senior Director leaves UMAF with cleaner, better-documented data than they found it, and a team that can build and maintain reporting without constant escalation. Success looks like leadership routinely making decisions from dashboards rather than requesting custom pulls.

The right person connects business questions to data investigations, they don't wait to be handed a specification. They use AI tools as a natural part of their workflow, document as they go, and build things other people can open up and follow.

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

• Designs, builds, and maintains Snowflake reporting views and data pipelines that serve as UMAF's trusted source of truth for advancement data.
• Partners with IT and UMAX (Salesforce Education Cloud) administrators to ensure reliable, auditable data flows between systems.
• Manages ETL processes and data warehouse architecture to support the team's reporting and analytics needs.
• Maintains data quality standards, including reconciliation processes that verify key figures against authoritative sources before any output is shared.
• Evaluates data tools and infrastructure against current and anticipated organizational needs.
• Uses AI tools actively in analytical and documentation workflows, and sets expectations for the team to do the same.

Reporting & Analytics (25%)

• Develops and maintains Tableau dashboards and reports that give leadership actionable, reconciled data on fundraising performance, donor engagement, and advancement operations.
• Builds and maintains the data dictionary and documentation layers that allow advancement staff to self-serve in UMAX.
• Responds to analytical requests from leadership and advancement teams, translating data findings into clear, audience-appropriate recommendations.
• Establishes and tracks KPIs and benchmarks for fundraising performance in partnership with leadership.
• Serves as team lead for BI & Analytics, setting priorities, managing workload, and supporting professional development.
• Reviews team outputs for accuracy, logic, and documentation quality before delivery.
• Supports the AVP with hiring, performance management, and team planning.
• Builds a team culture where documentation is the default and numbers are reconciled before they leave the team.

Data Governance & Documentation (15%)

• Builds and maintains a comprehensive data dictionary enabling self-serve reporting across UMAF departments.
• Establishes and enforces data governance standards, including field definitions, data stewardship responsibilities, and change management processes.
• Documents all reporting logic so any team member can trace and reproduce a figure independently.
• Partners with Gift & Donor Services and Prospect Development to align data definitions and reporting standards across Advancement Operations.

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 computer science, information systems, data analytics, or a related field, or equivalent professional experience.
• 5+ years of experience in business intelligence, data analytics, or a closely related field.
• Strong SQL skills and hands‑on experience with data warehouse platforms (Snowflake preferred).
• Experience designing and building Tableau dashboards and data visualizations.
• Experience with CRM systems and fundraising or advancement databases.
• Investigative mindset — moves from a business question to a line of inquiry to a finding, and knows when a number warrants a deeper look.
• Demonstrated habit of documenting 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.
• Strong analytical and problem‑solving skills, with a track record of reconciling data to trusted sources.
• Excellent written and verbal communication skills; comfortable translating data findings for both technical and non‑technical audiences.
• 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 Salesforce Education Cloud or a comparable higher education CRM.
• Prior experience in higher education advancement, nonprofit fundraising, or a mission‑driven organization. Advancement domain knowledge is a plus; strong analytical instincts and documentation habits are weighted more heavily.
• Familiarity with Snowflake architecture, including views, schemas, and role‑based access control.
• Experience managing a CRM migration or major data platform transition.
• Knowledge of data governance frameworks and master data management practices.

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

Proposed Annual Salary Range

$110,000 - $121,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 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 [e-mail]