Data Integrity Specialist

Position Summary
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.

Essential Duties And Responsibilities
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.

Physical Demands
While performing the duties of this job the employee is regularly required to: talk hear sit and use hands to operate the computer and other office equipment. The employee frequently is required to: stand and walk. The employee is occasionally required to: reach with hands and arms and lift and/or move up to 15 pounds. Specific vision abilities required by this job include ability to adjust focus.

Required Qualifications
Bachelors 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.

Preferred Qualifications
None