Hybrid Data Warehouse QA Engineer ETL Snowflake

MathWorks; Natick (MA); Hybrid; USD 90,000 - 140,000; Full time

Job summary

MathWorks is seeking a Data Warehouse Quality Engineer to support data warehousing systems, data marts, and the broader information architecture. This role emphasizes testing, data integrity, and collaboration with the Data Warehouse team.

You will design and execute test plans across ETL, DBT, and Snowflake workloads, validate mappings, and drive continuous improvement in data quality and delivery processes in a hybrid work environment.

Qualifications

• Bachelor's degree and 3+ years of professional experience, or a master's degree.
• Experience in IT software development, data warehousing, ETL, and QE.
• Strong SQL skills for data validation and analysis.
• Experience testing data warehouse systems and ETL processes.

Responsibilities

• Collaborate with project teams and business users to gather requirements and develop test plans, test cases, and technical scripts
• Participate in Agile/Scrum ceremonies and provide QE status updates
• Test ETL pipelines, DBT transformations, and Snowflake data loads to ensure data accuracy and integrity
• Validate source-to-target mappings by writing Snowflake SQL queries to reconcile data from different sources like SQL Server, files, and AWS S3
• Analyze and profile data to identify quality issues and assess ETL readiness
• Develop and maintain automated scripts for data validation and regression testing in Python
• Document test results, defects, and resolutions, and communicate findings to stakeholders

Skills

SQL

Python scripting

ETL testing

Data profiling

QA testing

Agile/Scrum

Test planning

Education

Bachelor's degree in a related field

Master's degree

Tools

Snowflake

DBT

AWS

SQL Server

Job description

MathWorks is seeking a Data Warehouse Quality Engineer to support data warehousing systems, data marts, and the broader information architecture. This role emphasizes testing, data integrity, and collaboration with the Data Warehouse team.

You will design and execute test plans across ETL, DBT, and Snowflake workloads, validate mappings, and drive continuous improvement in data quality and delivery processes in a hybrid work environment.