Overview
Remote
$60 - $65
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 Month(s)
Skills
Amazon Redshift
Data Validation
Data Warehouse
Data Warehouse QA
Documentation
ELT
Collaboration
Data Engineering
Data Governance
Data Modeling
Data Quality
Analytics
Automated Testing
Business Intelligence
Business Rules
Cloud Computing
ETL QA
Extract
Transform
Load
Regression Analysis
Regulatory Compliance
Reporting
SQL
Snow Flake Schema
Testing
Workflow
Job Details
Job Title: Data Warehouse (DWH) Tester
Location: Cincinnati, OH (Remote)
Job Description:
We are looking for a skilled Data Warehouse Tester with strong DBT (Data Build Tool) expertise to join our data engineering and analytics team. The role involves validating ETL/ELT pipelines, ensuring data quality, and performing end-to-end testing of data warehouse solutions. You will collaborate with data engineers, BI teams, and business stakeholders to ensure accurate, consistent, and reliable data delivery.
Key Responsibilities:
- Perform ETL/ELT and data warehouse testing using DBT and SQL.
- Validate data transformations, mappings, and aggregations across source and target systems.
- Develop and execute DBT tests for data quality, schema, and business rule validation.
- Create and maintain automated test cases, regression suites, and test documentation.
- Collaborate with engineering teams to troubleshoot defects and optimize data quality.
- Ensure compliance with data governance and reporting standards.
Required Skills:
- 4 8 years of experience in Data Warehouse / ETL testing.
- Hands-on expertise with DBT (Data Build Tool) testing framework.
- Strong SQL skills for complex data validation and test automation.
- Solid understanding of data warehousing concepts, ETL/ELT workflows, and data modeling.
- Experience with cloud data warehouses like Snowflake, Redshift, BigQuery, or Synapse
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.