RIT Solutions, Inc. · 23 hours ago
Data Quality Assurance Engineer
United States
Full-time
Remote
Senior Level
5+ years expRIT Solutions, Inc. is seeking a Data Quality Assurance Engineer to ensure high product quality through effective testing of ETL processes within Master Data Management and Data Warehouse environments. The role involves developing and executing test plans, collaborating with teams, and advocating for best practices in testing and quality assurance.
Staffing & Recruiting
Responsibilities
Constantly develop a deeper understanding of available data
Work to understand multiple operational departments and how data is captured and used within the organization
Become an expert in business rules, system functionality and architecture
Understand the current state to develop and/or enhance the data quality framework to support the Data Architecture and Data Analytics teams
Aptitude to evolve the current data quality processes into an enterprise data quality practice
Write complex SQL queries for source and target systems to verify the data for the ETL processes
Review business requirements, functional specifications, use cases, design, and architecture documents to create effective test plans for both ETL and data migration activities providing robust coverage
Independently 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
Performance/volume testing
Build and execute regression test scenarios
Provide estimates and timeframe necessary for testing a project to ensure a high-quality implementation
Participate in data migration testing activities, including data validation, integrity checks, and reconciliation across source and target systems
Contribute to and maintain project documentation
Identify, report and track defects and User Experience issues through a system of record
Collaborate with external teams on root cause analysis
Maintain close interaction with business and technical peers during the project life cycle
Actively participate in requirements and code reviews
Actively participate and drive improvements in Agile Scrum delivery
Be a thought leader in the test design and execution arena (manual and automated)
Identify process bottlenecks and suggest improvement actions
Creation and input of test data, either manually or by using tools, programs or masked production data to execute test cases
Qualification
Required
Advanced SQL / relational DB expertise (SQL Server required; Oracle and Postgres familiarity) — needed to query, validate, diagnose data issues and support DB-heavy testing across Velocity and MDM
MDM domain skills (data analysis, modeling, entity relationships, mismatch detection) — essential for understanding data flows, identifying defects, and performing master-data-specific testing
Test automation & scripting fundamentals (Python, VS/VS Code)
Working in CICD using Git/GitHub or similar (list tools used)
API testing: Highly automated. Teams working on API testing are described as 'pretty advanced in automation.' — required to work with existing automation utilities, extend frameworks, and deliver repeatable, scalable testing
Overall maturity: Mixed — strong maturity for API automation, moderate for web/UI, and nascent but rapidly developing for data/MDM automation (frameworks exist but coverage is still growing)
Seniority: ~5–8 years experience; not entry level; able to take initiative and work independently
Core technical skills: Strong relational DB skills: advanced SQL on SQL Server (must), Oracle (SQL Developer), and Postgres familiarity
Basic scripting/automation experience: Python, Visual Studio / VS Code, and GitHub
API, web, and UI testing experience (especially API testing)
Engagement: Will be dedicated to the Velocity project (full-time on Velocity)
Other: Expected to ramp quickly and be able to extend/expand existing automation frameworks
Must have experience with dimensional databases
Experience with Amazon Redshift, MPP Databases, or other cloud warehouses
Hands-on experience validating End User reports
Hands-on experience in ETL process testing is a must
Strong hands-on experience using complex sql queries for results validation, data mining and evaluating foreign key dependencies
Strong ability to troubleshoot issues, identify root causes, and support external teams in development of resolutions
Hands-on experience in Regression Test Strategies, Regression suite maintenance and execution
Preferred
Domain/background: Healthcare/insurance experience is a plus but not required; emphasis on ability to analyze data relationships and identify mismatches/flows
Hands-on experience with Hex, Tableau, PowerBI or other analytics applications is a strong plus
Hands-on experience with one or more scripting languages (C#, Python, JS, PowerShell, etc.) is a strong plus
Hands-on experience with Coda or SSIS packages is a strong plus
Company
RIT Solutions, Inc.
Jobdiva Job Portal: https://www1.jobdiva.com/candidates/myjobs/searchjobsdone.jsp?a=xbjdnwgjodtga1y1im2g881fkkeiwd0775lbvq8yqgps8vb2q36w2vj1ga6xxork&compid=-1 Recruitment (contingency search and campus selection).
201-500 employees
H1B Sponsorship
RIT Solutions, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2023 (2)
Funding
Current Stage
Growth StageCompany data provided by crunchbase