What are the responsibilities and job description for the Data Integrity Specialist position at Spelman College?
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.
Required Qualifications
- 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.
Preferred Qualifications
None
Certifications, Licenses, Restrictions
None
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.
Shift
Days
% Travel Required
0%
Full Time/Part Time
Full-time
Work Location/Schedule:
This position is eligible for a hybrid work arrangement.
FLSA
Non-Exempt
Number of Vacancies
1
Anticipated Candidate Start Date
Position End Date
Posting Detail Information
Posting Number
SC0763P
Posting Open Date
01/11/2025
Posting Closing Date
Open Until Filled
Yes
Special Instructions to Applicants
EEO Statement
Spelman College is an EEO/Minority/Female/Disabled/Veteran/Title IX Employer and we participate in E-Verify. We are a smoke-free campus.
COVID-19 Vaccination Protocol
Due to the heightened risk of contracting COVID-19 and the spread of variants, Spelman College strongly recommends that faculty, staff, and students receive a COVID-19 vaccine and adhere to all health and safety guidelines.
If you have any questions please contact: Yemi Brown, PharmD Manager of COVID-19 Operations, at ibiyemibrown@spelman.edu
If you have any questions please contact: Yemi Brown, PharmD Manager of COVID-19 Operations, at ibiyemibrown@spelman.edu
