Data Warehouse QA Engineer

CSI is a forward-thinking software provider that helps community and regional financial institutions through open and flexible technologies. They are seeking a Data Warehouse QA Engineer to ensure the stability, integrity, and reliability of data powering their banking technology solutions by designing and maintaining comprehensive data quality processes.

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

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