Business Intelligence & Analytics II (Hybrid)

About the Company

Established in 2003, the University of Massachusetts Amherst Foundation (UMAF) is a private 501(c)(3) nonprofit organization dedicated to raising philanthropic support for the University of Massachusetts Amherst and advancing the University's mission and strategic priorities. Located on the Amherst campus, UMAF operates as a separately governed nonprofit organization while working closely with the University community. The Foundation serves as a best-practices resource for fundraising strategy and implementation and supports advancement professionals through strong data, technology, and operational capabilities. UMAF is committed to building a diverse, collaborative, and mission-driven workplace where employees are encouraged to bring new perspectives, demonstrate curiosity, and contribute meaningfully to organizational success.

About the Role

UMAF is seeking an experienced Senior Director, Business Intelligence & Analytics to join its Advancement Operations division and report directly to the Associate Vice President of Advancement Operations. The Senior Director will lead UMAF's Business Intelligence and Analytics function and own the end-to-end analytics pipeline, from data architecture and data governance through reporting, dashboard development, and business insights. The role will work primarily across Snowflake, Tableau, and Salesforce Education Cloud (UMAX) to build reliable data infrastructure, maintain high data-quality standards, develop self-service reporting capabilities, and translate complex data into actionable recommendations.

The ideal candidate is an investigative, technically strong, and business-oriented analytics leader who can move from a business question to a data investigation and ultimately to a clear, actionable finding. This person will also establish strong documentation practices and leverage AI tools such as ChatGPT, Claude, Copilot, or Cortex as part of analytical and documentation workflows. Success in this role means leadership can confidently make decisions using trusted dashboards and reporting rather than relying on repeated one-off data requests.

Responsibilities

• Data Infrastructure & Architecture:
  • Design, build, and maintain Snowflake reporting views and data pipelines that provide a trusted source of truth for advancement data.
  • Partner with IT and Salesforce Education Cloud (UMAX) administrators to maintain reliable, auditable data flows between systems.
  • Manage ETL processes and data warehouse architecture supporting enterprise reporting and analytics requirements.
  • Establish and maintain data-quality standards and reconciliation processes to validate key metrics against authoritative sources.
  • Evaluate data platforms, tools, and infrastructure based on current and future organizational requirements.
  • Incorporate AI tools into analytical, data-management, and documentation workflows.
  • Establish effective technical practices that enable the BI & Analytics team to work efficiently and consistently.
• Reporting & Analytics:
  • Develop and maintain Tableau dashboards and reports focused on fundraising performance, donor engagement, and advancement operations.
  • Deliver accurate, reconciled, and actionable analytics to organizational leadership.
  • Build and maintain data dictionaries and documentation that enable advancement teams to independently access and interpret reporting within UMAX.
  • Respond to analytical requests from leadership and advancement teams.
  • Translate complex data findings into clear, audience-appropriate insights and recommendations.
  • Establish and monitor KPIs, benchmarks, and performance measures in partnership with organizational leadership.
  • Investigate unusual or inconsistent data and determine when deeper analysis is required.
• Team Leadership:
  • Serve as the functional lead for the BI & Analytics team.
  • Establish priorities, manage workload, and coordinate team deliverables.
  • Review analytics and reporting outputs for accuracy, logic, consistency, and documentation quality.
  • Support hiring, performance management, professional development, and team planning in partnership with the Associate Vice President.
  • Foster a team culture where documentation, data quality, reconciliation, and knowledge sharing are standard practices.
  • Establish processes that enable team members to independently build and maintain reporting solutions.
• Data Governance & Documentation:
  • Develop and maintain a comprehensive enterprise data dictionary supporting self-service reporting across UMAF departments.
  • Establish and enforce data governance standards, including field definitions, data stewardship responsibilities, and change-management processes.
  • Document reporting logic, methodologies, calculations, and data sources so team members can independently trace and reproduce results.
  • Partner with Gift & Donor Services and Prospect Development to align data definitions and reporting standards.
  • Promote consistent data practices across Advancement Operations.
  • Improve the quality, accessibility, transparency, and usability of organizational data.
• Other Duties:
  • Support organizational growth initiatives, technology projects, analytics priorities, and other strategic projects as assigned.
  • Contribute to continuous improvement of UMAF's data infrastructure, reporting capabilities, and business intelligence practices.

Benefits

• Annual salary range of $110,000–$121,000
• 20 vacation days
• 12 paid holidays
• 12 sick days
• 5 personal days
• 2 office closure days
• Four-day summer workweek
• 401(k) retirement plan with a 10% employer match when the employee contributes 5%
• Medical, dental, and vision insurance
• 16 weeks of paid parental leave to be used within one year of childbirth
• Additional six weeks of paid parental leave available for the birthing parent
• Part-time work for full-time pay during the first four weeks following parental leave
• Hybrid work environment
• Professional growth and development opportunities
• Mission-driven and collaborative workplace culture

Qualifications

• Basic Qualifications:
  • Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field, or equivalent professional experience.
  • Minimum 5 years of experience in business intelligence, data analytics, or a closely related discipline.
  • Strong SQL skills and hands-on experience with data warehouse technologies; Snowflake experience preferred.
  • Demonstrated experience designing and developing Tableau dashboards and data visualizations.
  • Experience working with CRM systems and fundraising, advancement, or comparable organizational databases.
  • Strong investigative and analytical mindset with the ability to translate business questions into data-driven investigations and actionable findings.
  • Demonstrated ability to document analytical logic, methodologies, and processes so others can reproduce and validate results.
  • Active experience using AI tools such as ChatGPT, Claude, Copilot, or Cortex within analytics and documentation workflows.
  • Strong data-reconciliation and quality-assurance skills.
  • Excellent analytical, critical-thinking, and problem-solving abilities.
  • Excellent written and verbal communication skills.
  • Ability to communicate complex analytical findings effectively to both technical and non-technical audiences.
  • High degree of professional integrity and respect for colleagues and stakeholders at all organizational levels.
  • Ability to work effectively both independently and collaboratively.
• Preferred Qualifications:
  • Experience with Salesforce Education Cloud or a comparable higher-education CRM platform.
  • Previous experience in higher education advancement, nonprofit fundraising, philanthropy, or another mission-driven organization.
  • Familiarity with Snowflake architecture, including views, schemas, and role-based access control.
  • Experience developing and maintaining enterprise data dictionaries.
  • Experience creating self-service reporting environments and documentation.
  • Experience leading a CRM migration or major data platform transformation.
  • Knowledge of data governance frameworks and master data management practices.
  • Understanding of fundraising analytics, donor engagement metrics, advancement operations, or related higher-education business processes.
  • Experience leading or mentoring BI, analytics, data engineering, or reporting professionals.

The University of Massachusetts Amherst Foundation is committed to equal employment opportunity and to fostering a diverse, equitable, inclusive, and respectful workplace. Qualified applicants are encouraged to apply regardless of background or identity, and reasonable accommodations will be provided as required by applicable law.