Data Warehouse QA Engineer

CSI

27d • Remote

About The Position

Are you passionate about data accuracy, ETL validation, and building high‑quality data warehouse solutions for financial institutions? Join our Quality Engineering team and play a critical role in ensuring the stability, integrity, and reliability of the data that powers our banking technology solutions. In this role, you will design, execute, and maintain comprehensive data quality processes across warehouse systems, ETL pipelines, and databases. If you thrive in a detail‑oriented, data‑driven environment and enjoy solving complex data challenges, this is the opportunity for you. What You’ll Do 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
• Strong written and verbal communication skills

Nice To Haves

• Experience with big data/analytics testing, data pipelines, and dashboard validation
• Familiarity with Domo, Tableau, or Power BI
• Experience testing AI‑driven applications
• Experience with TypeScript, Node.js, or Python
• Relevant certifications in database, ETL, or data warehouse technologies

Responsibilities

• 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.

Benefits

• Along with a competitive salary, this position includes eligibility for incentive awards based on both individual and business performance.
• We also offer a comprehensive range of benefits.
• To learn more about our benefits, visit: Benefits Summary
• Enjoy a remote-friendly, growth-oriented culture with strong work/life balance

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees