Data Warehouse Quality Engineer

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

Summary

MathWorks has a hybrid work model that enables staff members to split their time between office and home. The hybrid model provides the advantage of having both in-person time with colleagues and flexible at-home life optimizations. Learn More: https://www.mathworks.com/company/jobs/resources/applying-and-interviewing.html#onboarding.

Summary

MathWorks has a hybrid work model that enables staff members to split their time between office and home. The hybrid model provides the advantage of having both in-person time with colleagues and flexible at-home life optimizations. Learn More: https://www.mathworks.com/company/jobs/resources/applying-and-interviewing.html#onboarding.

The Data Warehouse Quality Engineer will support the ongoing development and maintenance of our data warehousing systems and data marts. Through your efforts, you’ll be making valuable contributions to the continuous transformation and improvement of our information systems.

This role works with the rest of the Data Warehouse team to support and test throughout the entire data development lifecycle, including data profiling, ETL and data model design, development, testing and support. We’re looking for someone who has experience testing data warehouse systems and ETL, is team oriented, quality-focused and a great communicator, with the skills necessary to ensure successful growth and support of our data warehousing systems.

MathWorks nurtures growth, appreciates inclusivity, encourages initiative, values teamwork, shares success, and rewards excellence.

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

Minimum Qualifications

• A bachelor's degree and 3 years of professional work experience (or a master's degree, or equivalent experience) is required.

Additional Qualifications

• 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