Data Quality Tester / ETL / SQL / Chicago

Motion Recruitment; Chicago (IL); Hybrid; USD 90,000 - 140,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

Vacation Time

401(k)

Paid Holidays

Professional Development

Stock Options

Job summary

Motion Recruitment is seeking a Data Quality Assurance Engineer to join a hybrid Data & Analytics team in Chicago. You will validate data movement, perform ETL and regression testing, and ensure data quality across enterprise platforms.

The role emphasizes hands-on testing, documentation, and collaboration with engineering and analytics teams to establish data quality standards and governance across cloud data warehouses and BI tools.

Qualifications

• Strong hands-on experience with ETL testing and data validation.
• Advanced SQL skills for data analysis, reconciliation, and verification.
• Experience 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.

Responsibilities

• 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.
• 70% Hands-on testing & validation
• 10% Test planning & documentation
• 20% Team collaboration & stakeholder engagement

Skills

ETL testing

SQL

Data warehousing

Data migration testing

Test planning

Root cause analysis

Agile delivery

Stakeholder management

Tools

SSIS

Tableau

Power BI

Python

Redshift

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.