Senior Data Integrity Associate

Job Purpose

Responsible for leading data maintenance and enrichment projects, ensuring the accuracy, integrity, and quality of the alumni, donor and gift records in the administrative database(s) for the Division of Development and Alumni Affairs. This position leads efforts to enhance data integrity, manage data enrichment projects and implements processes to ensure reliable and consistent records. Work with other units in the division to coordinate data maintenance efforts. This position reports to the Associate Director, Data Integrity.

Essential Functions

• Ensure the accuracy, integrity, and confidentiality of alumni, donor, and gift records through strategic oversight of data maintenance activities, including additions, deletions, and modifications. Supervise the processing of data update requests from staff, donors, alumni and friends. Assist the Director, Reporting & Data Services in evaluating data enhancement strategies. Lead data hygiene projects and the importing of returned data from third-party vendors. (30%)
• Analyze data for integrity noncompliance based on university and division business rules, user input and best practices. Identify and correct structural and semantic data errors. Serve as a subject-matter expert for the Data Integrity staff. (25%)
• Assist with the ongoing enhancement and maintenance of volunteer records, including assisting with the outreach process and processing of updates. Evaluate the data hygiene of non-volunteer category involvement records and reconcile data from external sources. (10%)
• Execute protocols for new data integrity checks in the division’s administrative database(s) and create scheduled workflows where appropriate. (10%)
• Execute protocols for routine updates of biographical data in the division’s administrative database(s), including call center and NCOA updates. Establish a protocol to track update requests and monitor completions. Monitor and report on the progress of all ongoing data integrity projects. (10%)
• Upload modified records collected from external sources into the division’s administrative database(s). (5%)
• Code large groups of alumni, donors and prospects to support the university’s alumni engagement, fundraising, and donor stewardship activities. Research and evaluate third party vendors and data enhancement services, as requested. (5%)
• Perform other related duties as assigned. (5%)

Qualifications

MINIMUM QUALIFICATIONS

Education: Bachelor's degree. Graduation from an accredited college or university with a bachelor’s degree in computer science, information systems, information technology, or related field.

Experience: Intermediate (3 to 4 years job-related experience). Minimum three (3) years of experience with database management, records maintenance, SQL, and data cleansing, extraction and validation. Experience with administrative systems software, preferably in the higher education or nonprofit environment. General understanding of, and interest in, Development and Alumni Affairs’ best practices and general operations.

Working Conditions

Normal office environment. Hybrid schedule. Adhere to confidentiality and data usage policy for the division.