Data Integrity Specialist

Spelman College Portal-posted 11 days ago

Full-time • Entry Level

Atlanta, GA

501-1,000 employees

Resume

Match Score

Upload and Match ResumeTrack Jobs with Teal

The Data Integrity Specialist is responsible for ensuring the accuracy, validity, and completeness of data stored within the CRM Advance system and other databases used by the Division of Institutional Advancement. This position plays a critical role in maintaining the integrity of advancement data, including demographic information, contributions, and other related data, to support advancement operations, fundraising efforts, donor relations, and accurate reporting. The Data Integrity Specialist routinely monitors data for inconsistencies, implements data cleansing processes, and develops strategies to maintain the quality of advancement data.

Data Quality Management: Regularly review and audit advancement data within CRM Advance and related systems to ensure accuracy, validity, and completeness. Identify and resolve inconsistencies, missing data, and inaccuracies to maintain high data integrity standards.
Duplicate Record Management: Identify and manage duplicate constituent records and contributions. Implement processes to regularly review data for duplicates and merge records when necessary, ensuring that all related data (e.g., contributions, contact information) is properly consolidated.
Pledge and Gift Association: Ensure gifts are accurately associated with corresponding pledge records where applicable. Regularly review contribution data to identify and resolve instances where pledge payments are not linked to pledge records and make necessary corrections.
Data Cleaning and Validation: Develop and implement processes for cleaning, standardizing, and validating data, including demographic and contribution data. Ensure compliance with data integrity standards and guidelines for consistency and quality.
Data Import and Export: Design and execute data imports, exports, and file uploads into CRM Advance and other databases. Prepare and clean data files for mass uploads, reviewing and correcting issues such as formatting errors or missing fields.
Database Maintenance and Updates: Monitor databases for outdated, inaccurate, or incomplete records or data. Perform regular updates and collaborate with other departments to ensure data changes (e.g., address updates, donor preferences) are accurately captured.
Collaboration and Support: Work with the Advancement Services team, development officers, and other stakeholders to address data-related needs and improve data integrity practices. Provide support and recommendations for best practices in data management.
Reporting and Analytics Support: Assist the data team with creating clean, accurate datasets for reporting. Troubleshoot data-related issues in reports and dashboards to ensure the accuracy of data used for decision-making.
Process Improvement: Identify opportunities for improving data management processes, including data cleaning, validation, and duplicate resolution. Develop automated solutions, scripts, or workflows to enhance efficiency and maintain data quality.
Other duties as assigned.

Bachelor’s degree is required. Preference for a degree in Information Systems, Data Management, Computer Science, or a related field.
2+ years of experience in data management, database administration, or a related role, preferably within a nonprofit or higher education setting.
Proficiency in CRM systems (e.g., CRM Advance), database management, data extraction, and validation techniques.
Experience in identifying and merging duplicate records and linking gifts to pledge records.
Experience with fundraising databases and reporting or business intelligence software such as Argos and Power BI.
Strong proficiency in Excel, SQL , and/or Microsoft Dynamics, as well as working with large datasets.
Excellent problem-solving skills, attention to detail, and a focus on maintaining high data quality standards.
Strong communication and collaboration skills to work effectively across departments.

None

Track Jobs with Teal

Job Search Resources

•

AI Resume Builder

•

Data Integrity Analyst Resume Examples

•

Cover Letter Examples

Data Integrity Specialist

Job Search Resources

Tools

Career Hubs

Guides

Company