QA Analyst

Core & Main•Saint Louis, MO

About The Position

Based in St. Louis, Core & Main is a leader in advancing reliable infrastructure™ with local service, nationwide®. As a specialty distributor with a focus on water, wastewater, storm drainage and fire protection products and related services, Core & Main provides solutions to municipalities, private water companies and professional contractors across municipal, non-residential and residential end markets, nationwide. With over 370 locations across the U.S., the company provides its customers local expertise backed by a national supply chain. Core & Main’s 5,700 associates are committed to helping their communities thrive with safe and reliable infrastructure. Visit coreandmain.com to learn more. Job Summary We are seeking a highly skilled and detail-oriented Data and Integrations QA Engineer to join our dynamic Data Engineering team. As a key member of our team, you will play a crucial role in ensuring the quality and reliability of our data pipelines and integrations. Your primary focus will be on testing the end-to-end data flow, identifying, and resolving data quality issues, and ensuring seamless integration between various systems.

Nice To Haves

Bachelor’s degree in Computer Science, Information Technology, or a related field
3+ years experience in data management, data integration, and data lake management
3+ years experience in Microsoft SQL development using T-SQL code to design, implement and optimize database objects, including tables, views, stored procedures, indexes and functions.
Experience with Master Data Management Platforms such as Enterworks, Profisee, or Informatica
Exposure with Azure data architecture and solid understanding of tools for building data pipelines of cloud-based data platforms including delta lake architecture and data warehousing
Understanding of HTTP APIs, testing tools like Postman/JMeter (doc already has API integration)
Familiarity with data security, data privacy regulations, and compliance standards.
Excellent analytical and problem-solving skills, with the ability to drive data-driven decision-making
Experience with testing tools and frameworks, and a strong understanding of automation principles

Responsibilities

Data Quality Assurance: Conduct comprehensive testing of data pipelines to ensure accuracy, completeness, and consistency of data.
Develop and execute test plans for data validation, transformation, and loading processes.
Collaborate with Data Engineers to understand data models and business rules, ensuring adherence to quality standards.
Integration Testing: Validate and verify data integrations between different systems and applications.
Perform end-to-end testing of integrated data flows to identify and address potential issues.
Work closely with cross-functional teams to understand integration requirements and implement effective testing strategies.
Automation: Design, implement, and maintain automated testing scripts for data pipelines and integrations.
Continuously enhance and optimize automated test frameworks to improve efficiency and coverage.
Issue Identification and Resolution: Investigate and troubleshoot data discrepancies, integration failures, and performance issues.
Collaborate with Data Engineers and developers to resolve identified issues and ensure data quality standards are met.
Documentation: Document test cases, test results, and testing processes to facilitate knowledge transfer and future reference.
Contribute to the development and maintenance of QA documentation, including best practices and guidelines.