[Remote] ETL QA Engineer

Note: The job is a remote job and is open to candidates in USA. Motion Recruitment is a non-profit labor health fund seeking an ETL Quality Assurance Engineer to join their team. This role involves testing ETL processes within the company's Master Data Management system and ensuring the quality of data in the Data Warehouse and analytics platform.ResponsibilitiesConstantly develop a deeper understanding of available dataWork to understand multiple operational departments and how data is captured and used within the organizationBecome an expert in business rules, system functionality and architectureUnderstand the current state to develop and/or enhance the data quality framework to support the Data Architecture and Data Analytics teamsAptitude to evolve the current data quality processes into an enterprise data quality practiceWrite complex SQL queries for source and target systems to verify the data for the ETL processesReview business requirements, functional specifications, use cases, design, and architecture documents to create effective test plans for both ETL and data migration activities providing robust coverageIndependently develop, modify, and execute test plans based on requirements and design documents including, but not limited to, the following methods: Load balance testing, Duplicate run testing, Negative testing with invalid test data, and Performance/volume testingSkillsStrong hands-on experience using complex SQL queries for results validation, data mining and evaluating foreign key dependenciesMust have experience with dimensional databasesHands-on experience in ETL process testing is a mustExperience with Amazon Redshift, MPP Databases, or other cloud warehousesHands-on experience validating End User reportsDeep understanding of Development and Test cycles, including respective best practicesStrong communication and Client/Business interfacing and interpersonal skills are a mustHands-on experience with Hex, Tableau, PowerBI or other analytics applications is a strong plusHands-on experience with one or more scripting languages (C#, Python, JS, PowerShell, etc.) is a strong plusHands-on experience in Regression Test Strategies, Regression suite maintenance and executionHands-on experience with Kodda or SSIS packages is a strong plusCompany OverviewMotion Recruitment, a Kelly® Company, delivers IT Talent Solutions for Contract, Direct Hire, Managed Solutions and Statement of Work to all of North America from our 21 delivery centers. It was founded in 1989, and is headquartered in Boston, Massachusetts, USA, with a workforce of 501-1000 employees. Its website is https://motionrecruitment.com.Company H1B SponsorshipMotion Recruitment has a track record of offering H1B sponsorships, with 2 in 2026, 11 in 2025, 12 in 2024, 1 in 2023, 1 in 2021, 1 in 2020. Please note that this does not guarantee sponsorship for this specific role.