Hybrid Data Warehouse QA Engineer

The MathWorks, Inc.; Natick (MA); Hybrid; USD 90,000 - 120,000; Full time

Job summary

The MathWorks, Inc. is seeking a Data Warehouse Quality Engineer to support the ongoing development and maintenance of our data warehousing systems and data marts. The role focuses on testing ETL, data profiling, and ensuring data integrity across Snowflake loads and DBT transformations.

Join a hybrid team that values collaboration, communication, and continuous improvement. You will work across the full data development lifecycle, from test planning to automation, in a fast-paced, supportive

Qualifications

• A bachelor's degree and 3 years of professional work experience (or a master's degree, or equivalent experience) is required.
• 3+ years of experience in IT software development (such as Systems Analysis, Data Warehousing, ETL, and QE areas).
• Knowledge of data warehousing concepts.
• Experience with cloud data warehouse technologies such as AWS, DBT, Snowflake.
• Strong SQL skills for data validation and analysis (experience with SQL Server and Snowflake).
• Familiarity with DBT (Data Build Tool) for data transformation validation.
• Experience working with relational and dimensional data models.
• Must be a self-starter comfortable working in a fast-paced, flexible environment, and take the initiative to learn new tools and concepts quickly.

Responsibilities

• Collaborate with project teams and business users to gather requirements and develop effective test plans, test cases, and technical scripts
• Participate in Agile/Scrum ceremonies and provide clear 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

Agile testing

SQL queries

Python scripting

ETL testing

Education

Bachelor's degree

Master's degree preferred

Tools

Snowflake

DBT

SQL Server

Python

AWS

Job description

The MathWorks, Inc. is seeking a Data Warehouse Quality Engineer to support the ongoing development and maintenance of our data warehousing systems and data marts. The role focuses on testing ETL, data profiling, and ensuring data integrity across Snowflake loads and DBT transformations.

Join a hybrid team that values collaboration, communication, and continuous improvement. You will work across the full data development lifecycle, from test planning to automation, in a fast-paced, supportive