CSI

Data Warehouse QA Engineer

CSI

full-time

Posted on:

Location Type: Remote

Location: CaliforniaUnited States

Visit company website

Explore more

AI Apply
Apply

About the role

  • Author and execute comprehensive data validation test suites for data warehouse systems, ETL processes, and database integrity to deliver accurate, high‑quality data solutions on time.
  • Follow standard operating procedures, validate data accuracy and transformation logic, track and close data‑related defects, and document evidence across multiple environments (dev, test, pre‑prod, prod).
  • Mentor QA engineers and collaborate with cross‑functional teams to ensure high‑quality data warehouse solutions meet company commitments.
  • Partner with product, engineering, and internal teams for support, training, and knowledge transfer on database and data warehouse testing best practices.
  • Identify and drive improvements in data testing processes and automation.
  • Review and provide feedback on technical documentation for data pipelines, ETL processes, and database schemas.
  • Research and introduce new tools, frameworks, and best practices for database and warehouse test automation.
  • Collaborate on defining and executing test strategies for data‑centric products.
  • Analyze acceptance criteria, create test cases, and maintain automated test suites for data validation.
  • Validate data accuracy, integrity, and transformation logic across multiple database environments.
  • Troubleshoot and resolve data‑related issues to ensure high data quality throughout the pipeline.
  • Independently lead testing efforts and participate in Agile ceremonies with the Data Intelligence team.

Requirements

  • 3–5 years of software engineering or software testing experience, with a strong focus on database/data warehouse testing.
  • Deep understanding of relational databases, data warehousing concepts, and ETL processes
  • Expert‑level SQL skills for data validation, profiling, and root‑cause analysis (Oracle, MySQL, Snowflake)
  • Experience with data testing tools and automation frameworks
  • Strong analytical skills for investigating data discrepancies in source, transformation, and loading stages
  • Manual and automated testing experience focused on data quality
  • Familiarity with Unix/Linux environments
  • Experience with GIT, JIRA, Confluence, and cloud platforms (AWS preferred)
  • Bachelor’s degree or equivalent experience in computer science, engineering, or related field
Benefits
  • Comprehensive range of benefits
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLdata validationdata warehousingETL processesdata testingdata profilingroot-cause analysisautomated testingdata qualitydata integrity
Soft Skills
analytical skillsmentoringcollaborationcommunicationproblem-solvingleadershipattention to detailprocess improvementknowledge transferindependence