Senior QA Analyst

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.

Major Tasks, Responsibilities and Key Accountabilities

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.

Preferred Qualifications:

• 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
• 5+ years of QA experience in enterprise environments, with a strong focus on integration testing and API validation
• Hands-on experience testing MuleSoft-based integrations or similar middleware platforms
• Strong understanding of data flows, ETL processes, and data validation across systems
• Demonstrated ability to quickly learn and adapt to new integration patterns, business processes, and system architectures
• Experience leading User Acceptance Testing (UAT) efforts with business stakeholders
• Excellent communication and collaboration skills in cross-functional Agile teams
• Ability to work independently as the sole QA resource supporting multiple developers and integration streams

Core & Main is an Equal Employment Opportunity employer. Employment at Core & Main is based solely on a person's merit and qualifications directly related to professional competence. Core & Main does not discriminate against any employee or applicant on the basis of race, creed, color, religion, national origin, nationality, ancestry, age, disability, veteran status, pregnancy or related condition (including breastfeeding), affectional or sexual orientation, gender identity or expression, marital status, status with regard to public assistance, citizenship, or any other basis protected by law.

None of the questions in this application are intended to elicit information regarding any protected characteristics, nor imply any limitation, illegal preferences or discrimination based upon non-job-related information or protected characteristics.

For more information, please click here or visit https://www.eeoc.gov