Data Integrity Manager

Company Description

By working at Harvard University, you join a vibrant community that advances Harvard's world‑changing mission in meaningful ways, inspires innovation and collaboration, and builds skills and expertise. We are dedicated to creating a diverse and welcoming environment where everyone can thrive.

This full‑time confidential exempt position is responsible for managing data integrity and ensuring the availability of high‑quality biographical data for fundraising and engagement activities, reporting and analytics. Of key importance is the ongoing work to add new records to the Alumni Affairs & Development (AA&D) Customer Relationship Management (CRM) Advance, in particular the import of information from the university’s Student Information System (SIS).

This work enables the creation of alumni records as students graduate and creates the foundation of AA&D’s work to engage and raise funds from its alumni. Using multiple data sources and software tools, the manager will also explore, recommend, and carry out biographical data integrity projects to ensure high‑quality CRM data is available as colleagues undertake alumni outreach efforts, donor solicitation plans, and reporting and analysis of outcomes to support data‑driven strategies within AA&D.

The Data Integrity Manager will collaborate with managers in Alumni Affairs and Development (AA&D) on the evaluation and improvement of business systems and processes to optimize biographical data accuracy. The position requires relevant technical experience, operational expertise, and exemplary communication and project management skills. The ideal candidate will be organized, professional, focused on prioritizing colleagues and the objectives of Harvard’s AA&D organization.

• Responsible for five critical projects that occur on a scheduled basis each year: preparation of the voter eligibility file for the annual Harvard election; converting student records to alumni at graduation, which enables new graduates to join the worldwide community of Harvard Alumni; the creation of new student records; the creation of new parent records; and regular National Change of Address (NCOA) updates, which ensure that AA&D domestic mailing addresses are accurate and meet requirements from mail houses.
• Partners with AA&D Advancement Solutions managers and other internal and external business partners to develop or improve business processes and enhancements; stabilize business systems and processes; and implement technology that supports data integrity for AA&D. This includes research and experimentation to identify improvements (efficiency, accuracy) for routine projects and programs, using Harvard’s AI resources and similar tools.
• Delivers high‑quality, responsive, and efficient data integrity services that prioritize the support of fundraising and alumni engagement objectives through the delivery of quality data, working with AA&D business partners to identify opportunities and solutions.
• Coordinates with the Data Acquisition manager on projects designed to enhance the integrity of AA&D biographical data within AA&D and University policies.
• Establishes processes for managing the import and export of large volumes of data from different campus systems. Performs updates of large volumes of data (formatting, cleaning, prepping), creating data extracts to facilitate batch data loads to add or modify records.
• Oversears a centralized support model that provides project support to AA&D colleagues at the University, including entity matching and subscriber data services.
• Analyzes and interprets data to identify issues, evaluate scope and impacts; recommends appropriate methods to resolve.
• Understands complex and varied ways data is leveraged by Alumni Affairs and Development. Ensures practices for storing and maintaining data will optimally facilitate retrieval and use of information. Responsible for recommending changes in data collection and management practices to address data gaps.
• Using SQL, and/or in partnership with AA&D Business Intelligence, oversees the design and development of ad hoc queries and reports to support data integrity…