Membership Data Quality Analyst

Job Summary

The Data Quality Analyst plays a critical role in ensuring the accuracy, completeness, and reliability of membership data within the AACR system of record. This role involves evaluating data quality, defining standards, implementing data cleansing and transformation procedures, validating data, and resolving issues.

Responsibilities

• Evaluate the quality of data through data profiling, validation, and analysis.
• Identify and document data quality issues, anomalies, and inconsistencies.
• Define, recommend, and help establish data quality standards, guidelines, and best practices.
• Develop and maintain data quality rules and metrics to measure the accuracy, completeness, consistency, and timeliness of data.
• Collaborate with the IT department to design and execute data cleansing and transformation procedures.
• Implement data quality improvement initiatives to rectify identified issues.
• Develop and execute data validation tests and procedures to ensure data accuracy and consistency.
• Perform regular audits and reconciliations to verify the integrity of data across systems and databases.
• Investigate and troubleshoot data quality issues, collaborating with relevant teams to identify root causes and implement appropriate solutions.
• Document and track issue resolution processes and outcomes.
• Maintain comprehensive documentation of data quality processes, standards, and methodologies.
• Generate reports and dashboards to communicate data quality metrics and trends to stakeholders.
• Propose enhancements and automation opportunities to optimize data quality workflows.
• Train staff on data entry standards and provide guidance on data-related issues.
• Support business users in resolving data-related issues and answering data quality-related queries.

Requirements

• Bachelor’s degree in Information Systems, Data Analytics, or a related field (or equivalent work experience)
• 3-5 years of experience in data quality, data management, or database administration, preferably in a non-profit environment
• Excellent written and verbal communication skills
• Strong understanding of data quality concepts, methodologies, and best practices
• Experience in data analysis, profiling, and data cleansing techniques
• Proficiency in Excel, SQL, and data visualization tools (e.g., Tableau, Power BI)
• Experience with CRM systems (e.g., Salesforce, Raiser’s Edge) and nonprofit databases is a plus
• Strong analytical and problem-solving skills
• Excellent attention to detail and accuracy
• Effective communication and collaboration skills
• Ability to work effectively and independently and as part of a team
• Experience in working with large datasets and complex data environments is a plus