Data Quality Assurance Engineer

Description

Company Overview Who We Are Established in 1955 to provide lifetime monthly retirement benefits to Teamsters in the trucking industry, Central States Pension Fund has paid nearly $87 billion in lifetime retirement benefits. At Central States/TeamCare we proudly serve thousands of Teamster members and their families through two trusted organizations: TeamCare, a Central States Health Plan The Central States Southeast and Southwest Areas Health and Welfare Fund was founded in 1950 and was one of the first non-profit labor health funds in the United States. Since 2014, the Fund has done business under the tradename TeamCare. Today TeamCare covers the lives of 550,000 members, from 1,100 different employers, making it the largest labor healthcare fund in the country. Central States Pension Fund For more than half a century, Central States Pension Fund has blazed a trail to retirement security for over 670,000 Teamsters and their family members and revolutionized the pension world of American workers. Position Summary The Data Quality Assurance Engineer will be responsible for ETL process Data testing within Master Data Management (MDM) system, Data Warehouse, as well as Data Analytics. The successful candidate will deeply understand the needs of the organization and determine how to best test modeled data, as well as maintain and improve the health of our existing data warehouse objects and ETL processes. Data Quality engineer is responsible for planning and executing manual and automated testing activities on new and existing products to ensure that they meet the Business, Functional and Technical specifications and maintain high overall product quality. The Data Quality Assurance Engineer must be an advocate for all things Testing and Quality while driving and implementing best practices and must possess strong analytical and critical thinking abilities. The successful candidate is entrepreneurial at heart and open to building an entirely new set of capabilities for the organization. Key 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: o Load balance testing o Duplicate run testing o Negative testing with invalid test data o Performance/volume testing o 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.

Skills

Quality assurance, Automation, Quality assurance testing, Sql, Python, Manual testing, Test automation, Api, Automation testing, Automated testing

Top Skills Details

Quality assurance,Automation,Quality assurance testing,Sql,Python,Manual testing,Test automation,Api,Automation testing,Automated testing

Additional Skills & Qualifications

Qualifications. Must have experience with dimensional databases. Experience with Amazon Redshift, MPP Databases, or other cloud warehouses. Hands-on experience with Hex, Tableau, PowerBI or other analytics applications is a strong plus. 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 with one or more scripting languages (C#, Python, JS, PowerShell, etc.) is a strong plus. Hands-on experience in Regression Test Strategies, Regression suite maintenance and execution. Hands-on experience with Kodda or SSIS packages is a strong plus.

Experience Level

Intermediate Level
Job Type & Location
This is a Contract position based out of Rosemont, IL.
Pay and Benefits
The pay range for this position is $70.00 - $90.00/hr.
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave)
Workplace Type
This is a fully remote position.
Application Deadline
This position is anticipated to close on Jan 23, 2026.
>About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

About TEKsystems and TEKsystems Global Services

We're a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We're a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.