Haystack
← Back to Jobs
Other
MR

Data Quality Tester / ETL / SQL / Chicago

Motion Recruitment Partners, LLCChicago, IL🇺🇸United StatesPosted Sep 23, 2026

Quick Overview

Seniority
Mid Senior
Work mode
Hybrid
Location
Chicago, IL, United States
Posted
Yesterday
SQLETLTableauAgileC#JavaScriptPower BIPowerShellPythonReconciliationRedshiftRoot Cause AnalysisStakeholder Management

Job Description

A leading organization is seeking a Data Quality Assurance Engineer to join its growing Data & Analytics team in a hybrid work environment. This full-time opportunity offers the chance to work with modern data warehousing technologies, cloud data platforms, ETL processes, Master Data Management solutions, and business intelligence tools that support critical enterprise initiatives. This role is ideal for someone who enjoys solving complex data challenges and ensuring information accuracy across large-scale systems.

The successful candidate will play a key role in establishing and expanding enterprise data quality standards while partnering closely with analytics, architecture, engineering, and business teams. This is an opportunity to make a measurable impact, gain visibility across multiple departments, and influence the future direction of data quality practices.

Required Skills & Experience Strong hands-on experience with ETL testing and data validation
Advanced SQL skills for data analysis, reconciliation, and verification
Experience working with dimensional data models and data warehouses
Ability to execute data migration and data integrity testing initiatives
Experience creating test plans, test cases, and regression testing strategies
Strong root cause analysis and troubleshooting skills
Experience working within Agile delivery environments
Excellent communication and stakeholder management skills

Desired Skills & Experience Experience with Amazon Redshift or other cloud-based data warehouses
Exposure to Master Data Management (MDM) platforms
Experience validating BI dashboards and enterprise reporting solutions
Knowledge of Tableau, Power BI, Hex, or similar analytics platforms
Experience with Python, PowerShell, JavaScript, C#, or similar scripting languages
Experience with SSIS packages or related ETL technologies
Background in data quality frameworks and automation initiatives What You Will Be Doing Validate data movement between source and target systems
Execute ETL, regression, migration, and performance testing activities
Perform data reconciliation and integrity checks across enterprise platforms
Develop and maintain testing documentation and test strategies
Partner with engineering teams to identify and resolve data issues
Support analytics teams through report and dashboard validation
Help establish best practices for data quality and testing governance Tech Breakdown 40% SQL & Data Validation
25% ETL Testing & Data Integration
20% Data Warehousing & Cloud Platforms
15% Analytics & Reporting Tools Daily Responsibilities 70% Hands On Testing & Validation
10% Test Planning & Documentation
20% Team Collaboration & Stakeholder Engagement The Offer
Bonus eligible
You will receive the following benefits:
Medical, Dental, and Vision Insurance
Vacation Time
401(k) Program
Paid Holidays
Professional Development Opportunities
Stock Options (where applicable)
Applicants must be currently authorized to work in the US on a full-time basis now and in the future.

Similar jobs