Data Quality Tester / ETL / SQL / Chicago

Motion Recruitment
  • Chicago, IL
    1 day ago

    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.

    Numbers & Facts

    LocationChicago, IL

    Skills

    • Agile Programming Methodologiesunmatched
    • Analysis Skillsunmatched
    • Automationunmatched
    • Best Practicesunmatched
    • Business Intelligenceunmatched
    • Business Intelligence Softwareunmatched
    • Cloud Computingunmatched
    • Communication Skillsunmatched
    • Data Analysisunmatched
    • Data Migrationunmatched
    • Data Modelingunmatched
    • Data Qualityunmatched
    • Data Warehousingunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Dental Insuranceunmatched
    • Dimensional Modelingunmatched
    • Documentationunmatched
    • Documentation Planunmatched
    • Identify Issuesunmatched
    • Integration Testingunmatched
    • JavaScriptunmatched
    • Large-Scale Systemsunmatched
    • Master Data Management (MDM)unmatched
    • Microsoft C# (C Sharp)unmatched
    • Multiplatform/Cross-Platformunmatched
    • Performance Testingunmatched
    • Power BIunmatched
    • Problem Solving Skillsunmatched
    • Python Programming/Scripting Languageunmatched
    • Quality Assuranceunmatched
    • Quality Metricsunmatched
    • Reconciliationunmatched
    • Regression Testingunmatched
    • Reporting Dashboardsunmatched
    • Root Cause Analysisunmatched
    • SQL (Structured Query Language)unmatched
    • SQL Server Integration Services (SSIS)unmatched
    • Scripting (Scripting Languages)unmatched
    • Tableauunmatched
    • Test Caseunmatched
    • Test Dataunmatched
    • Test Plan/Scheduleunmatched
    • Test Strategyunmatched
    • Validation Testingunmatched
    • Vision Planunmatched
    • Windows PowerShellunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder