Data Validation Analyst

Jobtailor; New London (CT); On-site; USD 65,000 - 95,000; Full time

Job summary

Jobtailor is seeking a data analytics specialist to perform rigorous data validation and QA on MAP Revenue data within Salesforce and Data Manager. You will audit records, validate tracking, and use data mining to identify discrepancies for prompt resolution.

Responsibilities include troubleshooting data issues, collaborating with the Customer Payments team, loading data files, and refining validation processes to improve data quality across systems and payment workflows.

Qualifications

• Bachelor's degree or equivalent experience in a data-focused field is required or considered.
• Experience with data validation, quality assurance, auditing, or reconciliation is required.
• Proficiency in querying and analyzing data using MySQL or similar relational databases.
• Strong understanding of database structures and relationships.
• Excellent analytical, problem-solving, and attention to detail.

Responsibilities

• Perform data validation and QA on high-volume MAP Revenue data loaded into Salesforce and Data Manager
• Audit records for accuracy and proper inclusion in downstream payment processes
• Validate Salesforce Data Tracking Records
• Use data mining, querying, and analysis to identify discrepancies and quality issues
• Investigate data issues, identify root causes, and coordinate resolution
• Partner with Customer Payments team to resolve data or payment discrepancies
• Load and manage data files within Data Manager
• Develop and maintain data validation and audit processes
• Build understanding of data lifecycle across source files, systems, Salesforce, and payments
• Communicate findings and risks to stakeholders and cross-functional partners
• Identify opportunities for process improvements and automation

Skills

Data Validation

MySQL Querying

Data Quality Assurance

Analytical Problem-Solving

Attention to Detail

Analytical Skills

Communication Skills

Collaboration

Education

Bachelor's degree in Data Analytics, Computer Science, Information Systems, Database Management, or related field

Tools

Salesforce

Data Manager

Microsoft Excel

Job description

• Perform data validation and quality assurance on high-volume MAP Revenue data loaded into Salesforce and Data Manager
• Audit records for accuracy, completeness, and proper incorporation into downstream customer payment processes
• Validate Salesforce Data Tracking Records
• Use data mining, querying, and analytical techniques to identify discrepancies, anomalies, missing records, and data quality issues
• Investigate and troubleshoot data issues, identify root causes, and coordinate resolution before customer payment processing
• Partner with the Customer Payments team to research and resolve data or payment discrepancies
• Load and manage data files within Data Manager
• Develop, maintain, and improve data validation and audit processes
• Build understanding of the data lifecycle across source files, internal systems, Salesforce, and payment processes
• Communicate findings, risks, and data issues to stakeholders and cross-functional partners
• Identify opportunities for process improvements, automation, and enhanced data quality controls

Requirements

• Bachelor's degree in Data Analytics, Computer Science, Information Systems, Database Management, or a related field; equivalent relevant experience may be considered
• 2-4 years of experience working with databases, large datasets, data validation, data quality, or related analytical functions
• Experience performing data quality assurance, validation, auditing, or reconciliation activities
• Experience querying and analyzing data using MySQL or similar relational database technologies
• Strong understanding of database structures, relationships, and fundamental database architecture
• Ability to investigate data discrepancies, identify root causes, and resolve complex data issues
• Strong analytical, problem-solving, and critical-thinking skills
• Exceptional attention to detail and ability to maintain accuracy while working with high volumes of data
• Strong written and verbal communication skills and ability to collaborate effectively across teams
• Proficiency with Microsoft Office, particularly Excel
• Work authorization in the United States; work sponsorship is unavailable for this role

Core Competencies

Demonstrates expertise in data validation, quality assurance, and auditing processes, with a strong proficiency in MySQL and data analysis. Capable of identifying discrepancies and implementing process improvements to enhance data quality and accuracy.

Highest-signal resume keywords

• Data Validation
• MySQL Querying
• Data Quality Assurance
• Analytical Problem-Solving
• Attention to Detail

Hard Skills

• Data Validation
• Data Quality Assurance
• Data Auditing
• MySQL
• Data Analysis
• Database Management
• Data Mining
• Data Querying
• Data Lifecycle Understanding
• Process Improvement

Soft Skills

• Analytical Skills
• Problem-Solving
• Critical Thinking
• Communication Skills
• Collaboration

Industry Keywords

• Data Analytics
• Database Structures
• Data Discrepancies
• Customer Payments
• Payment Processing

Tools & Technologies

• Salesforce
• Data Manager
• Microsoft Excel