Senior QA Engineer Data and ETL Testing
Posted Today by 1762498608
Negotiable
Outside
Hybrid
USA
Summary: The Senior QA Engineer - Data & ETL Testing role focuses on ensuring the quality and reliability of data within enterprise data warehouse environments. The position requires hands-on experience in validating data movement and transformation, collaborating with data engineers and analysts to enhance QA practices. The ideal candidate will implement testing strategies for ETL processes and data pipelines while contributing to process improvements. This role is remote or hybrid based in New York, USA, and classified as outside IR35.
Key Responsibilities:
- Perform source-to-target testing for EDW systems using SQL (manual and automated).
- Validate data transformations, manipulations, and data quality/completeness across data pipelines.
- Conduct comprehensive testing of ETL processes, dimensional data models, and reports.
- Execute ETL workflows and data validation processes using scheduling tools.
- Develop and execute test plans to validate data within on-prem and cloud data warehouses.
- Identify, document, and resolve data quality issues in collaboration with data engineering teams.
- Ensure consistency and accuracy of data across various sources and reporting systems.
- Contribute to the continuous improvement of QA testing strategies and methodologies.
- Implement QA automation frameworks and best practices for data validation.
- Partner with Client, data engineers, architects, and QA leads to define test requirements and deliverables.
- Work with the Lead Data QA Engineer to maintain and support testing infrastructure.
- Prepare detailed reports on data quality findings, metrics, and improvement recommendations.
Key Skills:
- Bachelor's or Master's degree in Computer Science or a related field.
- 8 years of experience in data warehouse testing or development.
- Strong understanding of Data Warehousing (DW), ETL, and Data Quality concepts.
- Proficiency in SQL, RDBMS, and ETL validation.
- Experience validating reports and dashboards using Tableau, Power BI, or similar tools.
- Exceptional attention to detail with a strong, results-driven approach.
- Excellent verbal and written communication skills.
- Self-starter with strong ownership, accountability, and collaboration skills.
- Willingness to provide off-hour support as needed.
- Experience with SSIS and MS SQL Server.
- Exposure to Snowflake and DBT environments.
- Familiarity with QA automation tools and frameworks.
- Understanding of ETL workflows, data warehouse testing procedures, and cloud data ecosystems.
- Experience with Insurance data and hybrid (on-prem/cloud) architectures is a plus.
Salary (Rate): £130000 yearly
City: New York
Country: USA
Working Arrangements: hybrid
IR35 Status: outside IR35
Seniority Level: Senior
Industry: IT
Detailed Description From Employer:
Job Title: Senior QA Engineer - Data & ETL Testing
Location: Remote / NJ USA
Full time: Salary budget: 120k to 130K P.A
Position Overview
We are seeking a Senior QA Engineer (Data & ETL Testing) to ensure the quality, integrity, and reliability of data across our enterprise data warehouse (EDW) environments. The ideal candidate will have hands-on experience in validating data movement, transformation, and quality within on-premises and cloud-based data platforms.
You will collaborate closely with data engineers, architects, and analysts to test ETL processes, data pipelines, and reporting layers while implementing and improving QA best practices for data validation and automation.
Key Responsibilities
Data & ETL Testing
Requirements
IMP Skills
Ideal Candidate Profile
You are a meticulous QA professional passionate about ensuring data accuracy and consistency. You thrive in collaborative environments, take ownership of testing initiatives, and continuously seek to improve quality processes through innovation and automation.
Suggested Designation:
Senior QA Engineer - Data & ETL Testing (or) Data Quality Assurance Engineer
Location: Remote / NJ USA
Full time: Salary budget: 120k to 130K P.A
We are seeking a Senior QA Engineer (Data & ETL Testing) to ensure the quality, integrity, and reliability of data across our enterprise data warehouse (EDW) environments. The ideal candidate will have hands-on experience in validating data movement, transformation, and quality within on-premises and cloud-based data platforms.
You will collaborate closely with data engineers, architects, and analysts to test ETL processes, data pipelines, and reporting layers while implementing and improving QA best practices for data validation and automation.
Data & ETL Testing
- Perform source-to-target testing for EDW systems using SQL (manual and automated).
- Validate data transformations, manipulations, and data quality/completeness across data pipelines.
- Conduct comprehensive testing of ETL processes, dimensional data models, and reports.
- Execute ETL workflows and data validation processes using scheduling tools.
- Develop and execute test plans to validate data within on-prem and cloud data warehouses.
- Identify, document, and resolve data quality issues in collaboration with data engineering teams.
- Ensure consistency and accuracy of data across various sources and reporting systems.
- Contribute to the continuous improvement of QA testing strategies and methodologies.
- Implement QA automation frameworks and best practices for data validation.
- Partner with Client, data engineers, architects, and QA leads to define test requirements and deliverables.
- Work with the Lead Data QA Engineer to maintain and support testing infrastructure.
- Prepare detailed reports on data quality findings, metrics, and improvement recommendations.
- Bachelor's or Master's degree in Computer Science or a related field.
- 8 years of experience in data warehouse testing or development.
- Strong understanding of Data Warehousing (DW), ETL, and Data Quality concepts.
- Proficiency in SQL, RDBMS, and ETL validation.
- Experience validating reports and dashboards using Tableau, Power BI, or similar tools.
- Exceptional attention to detail with a strong, results-driven approach.
- Excellent verbal and written communication skills.
- Self-starter with strong ownership, accountability, and collaboration skills.
- Willingness to provide off-hour support as needed.
- Experience with SSIS and MS SQL Server.
- Exposure to Snowflake and DBT environments.
- Familiarity with QA automation tools and frameworks.
- Understanding of ETL workflows, data warehouse testing procedures, and cloud data ecosystems.
- Experience with Insurance data and hybrid (on-prem/cloud) architectures is a plus.
You are a meticulous QA professional passionate about ensuring data accuracy and consistency. You thrive in collaborative environments, take ownership of testing initiatives, and continuously seek to improve quality processes through innovation and automation.
Senior QA Engineer - Data & ETL Testing (or) Data Quality Assurance Engineer