
Data Warehouse QA Engineer
CSI
full-time
Posted on:
Location Type: Remote
Location: California • United States
Visit company websiteExplore more
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