Data Integrity Specialist – Development

Colonial Williamsburg; Williamsburg (VA); Hybrid; USD 36,000 - 50,000; Full time

Job summary

Colonial Williamsburg seeks a Data Integrity Specialist to drive data quality for donor records. You will align processes with best practices and serve as the primary liaison with IT and other partners to remediate non-standard data.

Responsibilities include leading import/validation of gift data, deduplication, and routine audits, while ensuring adherence to privacy regulations and nonprofit standards.

Qualifications

• Associate’s degree in business, information science or equivalent or 3 years of equivalent experience.
• Three to five years’ experience with records management or data/gift entry.
• Demonstrated experience with creating and implementing data quality improvement processes.
• Bachelor’s degree in information science, business or other related programs.
• 4-6 years of experience working in nonprofit services.
• 1-2 years experience with donor databases.
• Experience utilizing software languages such as R or Python.
• Strong understanding of database systems and data quality.

Responsibilities

• Lead the import, validation, reconciliation, and quality control of gift data for donor systems.
• Expand and lead constituent deduplication and remediation workflows.
• Develop data entry standards and guidelines for clean, consistent data.
• Identify opportunities for process improvements in data collection and reporting.
• Create automated workflows to verify accuracy of constituent records.
• Develop routine audits to correct inconsistencies, duplicates, or errors.
• Lead data hygiene projects and manage donor database updates.
• Collaborate with internal partners to troubleshoot issues and implement remedies.
• Ensure donor data compliance with data protection regulations.

Skills

Data quality

Donor data handling

Python

R

Data privacy

Attention to detail

Education

Associate’s degree / equivalent

Bachelor’s degree in info science / related

Job description

GOODWIN BUILDING
Williamsburg, VA 23185, USA

Description

Who We Are

Founded in 1926, the Colonial Williamsburg Foundation is a private, not-for-profit educational, historic, and cultural institution that owns and operates one of the largest and best-known museum complexes in the world. Our mission is “that the future may learn from the past” through preserving and restoring 18 th -century Williamsburg, Virginia’s colonial capital. We engage, inform, and inspire people to learn about this historic capital, the events that occurred here, and the diverse peoples who helped shape a new nation.

Today, Colonial Williamsburg is the largest living history museum in the U.S. The Historic Area is the 301-acre restored colonial capital with 89 original buildings and 525 buildings reconstructed to how they appeared in the 18th century through extensive archaeological, architectural, and documentary research. The Historic Area is staffed by highly trained, historically dressed interpreters and expert tradespeople who bring the 18th century to life. The Foundation also owns and operates two world-class museums, the DeWitt Wallace Decorative Arts Museum, and the Abby Aldrich Rockefeller Folk Art Museum, The Bob and Marion Wilson Teacher Institute , and a renowned research library, the John D Rockefeller Jr Library.

Additionally, Colonial Williamsburg is home to five world class accommodations at the Williamsburg Inn, Williamsburg Lodge Autograph Collection, the Griffin Hotel, the Williamsburg Woodlands Hotels and Suites and the unique Colonial Houses in the Historical Area. Visitors may also indulge in food and drink at our many on site restaurants and taverns that blend a historically inspired dining experience with today’s evolved tastes. Each year over five million people visit Williamsburg and another 20 million engage with us digitally.

About the Position:

The Data Integrity Specialist is a lead role within Development Services responsible for implementing continual process improvements to ensure the accuracy, consistency, and security of constituent and donor data. This role plays a key part in maintaining the integrity of data used in our fundraising efforts and ensures compliance with the best practices in data management and the development function. The role will serve as the primary contact with internal and external partners (e.g. IT) to identify non-standard data and will take the lead for remediation or the implementation of remedial processes for donor records.

Main Duties:

• Lead the import, validation, reconciliation, and quality control of gift data to ensure accurate, timely, and compliant entry into donor systems.
• Expand and lead the constituent deduplication process by analyzing duplicate record patterns, refining merge criteria, coordinating remediation workflows, and implementing scalable solutions that improve long-term data integrity.
• Develop and implement data entry standards, procedures, and guidelines to ensure clean and consistent data.
• Identify opportunities for process improvements related to data collection, validation, and reporting.
• Create technical processes and automated workflows to verify accuracy of constituent records using programming/software languages.
• Develop and implement routine audits to identify and correct inconsistencies, duplications, or errors in biographical and/or gift data.
• Lead the planning, managing, and implementation of special data hygiene projects.
• Manage and update the donor database to ensure smooth and efficient storage and retrieval of data.
• Lead the import, validation, reconciliation, and quality control of gift data to ensure accurate, timely, and compliant entry into donor systems.
• Collaborate with internal partners to complete systematic tasks, troubleshoot specific issues and identify/implement remedies.
• Ensure donor data is compliant with all relevant data protection regulations.

This is a non-exempt position, eligible to receive overtime in accordance with the Fair Labor Standards Act (FLSA). This position may be subject to overtime during high peak times, etc. as directed and approved by the Supervisor.

This job description reflects the general responsibilities of the position and is not intended to be an exhaustive list. Duties and responsibilities may evolve over time based on operational needs.

Required and Preferred Education and Experience:

• Associate’s degree in business, application systems, information science or equivalent or 3 years of equivalent experience.
• Three to five years’ experience with records management or data/gift entry.
• Demonstrated experience with creating and implementing data quality improvement processes.
• Bachelor’s degree in information science, business or other related programs.
• 4-6 years of experience working in nonprofit services.
• 1-2 years experience with donor databases.
• Experience utilizing software languages such as R or Python.
• A strong understanding of database systems, attention to detail, and commitment to data quality.
• Demonstrated proficiency in identifying data inconsistencies and apply technical solutions to correct them.
• Advanced understanding of development/advancement services and the data behind fundraising.
• Demonstrated proficiency with automated reporting and other technical tools to improve data.
• Strong understanding of data privacy regulations and best practices for donor security.
• Demonstrated ability to multitask, prioritize work, and meet firm deadlines.
• Demonstrated ability to work independently as well as collaboratively to ensure data record quality and accuracy.
• Demonstrated proficiency working with technology and ability to create standardization and validation processes.
• Demonstrated ability to manage confidential and sensitive information with discretion.

Typical Work Schedule:

Monday - Friday, 8:30am-5:00pm

Compensation Disclaimer:

The compensation listed below for this position represents the anticipated hiring range and is provided in accordance with Virginia pay transparency requirements. Actual compensation will be determined based on factors such as the selected candidate’s skills, qualifications, experience, education, certifications, internal equity, and the specific requirements of the role.

Range: $26.45-$36.05

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.