<p><b>Position Overview</b></p> <p>The Data Validation Analyst will play a critical role in the next phase of the Data efforts, focusing on validating the new Datawarehouse against legacy warehouse data.
This role will leverage advanced SQL skills to query, compare, and reconcile data across both environments, research discrepancies, and document solutions.
The analyst will also evaluate and implement automation tools to streamline validation processes, ensuring data integrity and supporting the transition to new systems.</p> <p> </p> <p><b>Position Responsibilities</b></p> <ul> <li>Design and execute data validation scripts to compare legacy and new Datawarehouse environments</li> <li>Develop and run SQL queries to identify, research, and resolve data discrepancies</li> <li>Document validation processes, findings, and solutions for ongoing reference and governance</li> <li>Evaluate, recommend, and implement automation tools to enhance validation efficiency</li> <li>Collaborate with Business and IT Partners to ensure alignment on validation requirements and solutions</li> <li>Capture and report on key metrics related to data quality and validation progress</li> <li>Troubleshoot data issues using SQL and reporting tools</li> <li>Provide input to data migration and integration projects to ensure data accuracy</li> <li>Interact with various teams and partners to ensure alignment on all above activities</li> </ul> <p><b>Position Qualifications</b></p> <ul> <li>Strong verbal and written communication skills</li> <li>Excellent analytical and problem-solving abilities</li> <li>3-5 years' experience with SQL, including complex queries and data reconciliation</li> <li>Demonstrated experience in data validation, data quality assessment, or data migration projects</li> <li>Experience with automation tools for data validation (e.g., ETL testing, data comparison software) a plus</li> <li>Experience modeling data and/or data governance</li> <li>Experience with Agile Methodology a plus</li> <li>Understanding of Vehicle Processing or Servicing environment a plus</li> <li>Understanding of Automotive Industry a plus</li> </ul>