Temporary Data Migration Jobs in Chicago, IL (NOW HIRING)

Job Description: Quality Automation Lead

Position Title: Quality Automation Lead
Department: Global Data Technology
Location: Remote
Reports To: Director of Quality Engineering

About Arthur J. Gallagher

Arthur J. Gallagher is one of the world’s largest insurance brokerage and risk management companies, providing tailored insurance solutions and strategic organizational wellbeing initiatives. With over 50,000 employees globally, Gallagher is committed to innovation, client success, and delivering highquality solutions across all aspects of the business.

Please note additional position details below:

• This is a Temp-To-Hire, W-2 position.  We are not able to do 1099 or C2C.
• It is a fully remote role that will need to be based in the U.S. 
• You must meet our U.S. Eligibility requirements for work authorization as noted under "Additional Information" at the bottom of the job description.

Position Summary

The Quality Automation Lead will serve as the primary architect of our enterprise data integrity and validation strategy. This role focuses on building automated, defenseindepth testing solutions to ensure our insurance data remains accurate, consistent, and trusted across all BI and reporting platforms. The individual will develop scalable ETL and datapipeline validation frameworks, lead complex data migration reconciliations, and drive UAT readiness to maintain a reliable, enterprisewide single source of truth.

Self-motivated in handling multiple assignments across cross-functional teams.

Key Responsibilities

Leadership & Strategy

• Lead QA Automation strategy and execution for ETL/DWH, data migration, and BI/reporting initiatives.
• Establish best practices for automated testing, data quality frameworks, and continuous validation processes.
• Mentor and guide QA engineers, ensuring high-quality deliverables and best practices.
• Work closely with Data Engineering, Product Owners, and Business stakeholders to define testing approaches and quality standards.
• Drive continuous improvement in QA processes, automation, and data validation frameworks.

ETL / Data Warehouse Testing

• Design, implement, and maintain automated frameworks for validating ETL workflows, data lakes, and data warehouse processes.
• Validate data transformations, aggregations, business rules, and lineage across multilayered architectures.
• Perform comprehensive data profiling, schema validation, and quality rule testing thru Automation.
• Ensure accuracy, completeness, and consistency across largescale datasets and integrated systems.
• Integrate automated checks into orchestration tools such as Apache Airflow.

Data Migration Testing

• Lead highvisibility data migration and system conversion validation initiatives.
• Define and execute reconciliation strategies across source and target systems to ensure zerodefect migration outcomes.
• Drive cross-functional resolution of data discrepancies and mapping issues.

Reporting & BI Testing

• Validate endtoend data flows supporting enterprise BI and reporting platforms.
• Perform reporttodata source validation for dashboards, operational reports, and analytical applications.
• Certify UAT readiness with structured data validation, defect management, and signoff processes.

Technical Quality Engineering

• Build and maintain automated testing frameworks for data pipelines, transformations, APIs, and reporting assets.
• Implement automation testing integrated with CI/CD pipelines (Azure DevOps, Jenkins, GitHub Actions, GitLab CI).
• Collaborate with engineering teams to embed test hooks, automated checkpoints, and validation steps in data pipelines.
• Set up continuous testing and monitoring for ETL, batch, streaming, and eventdriven data flows.
• Implement governancealigned quality checks using tools such as Collibra for metadata and lineage validation.

Project & Delivery Support

• Lead QA automation planning and estimation coordination for data engineering, BI, and analytics projects.
• Collaborate with project managers, product owners, and engineering leads to define testing scope, timelines, and deliverables.
• Ensure ontime delivery of testing milestones through proactive risk identification, mitigation planning, and issue resolution.
• Support Agile ceremonies and coordinate test planning, execution, and reporting.

Qualifications

Education

• Bachelor’s degree in Computer Science, Software Engineering, Information Systems, or related field (or equivalent experience).

Experience

• 6 + years of experience with a strong focus on data-centric testing.
• Proven experience testing ETL processes, data warehouses, data lakes, and complex data transformations.
• Hands on experience with automation tools for Data testing (e.g., Selenium, Query Surge, Datagaps, ACCELQ, python scripts).
• Experience working within Agile/Scrum environments.

Technical Skills

• Automation Tools : Selenium, QuerySurge, Datagaps, ACCELQ, and other test automation frameworks.
• CI/CD Integration : Handson experience embedding automated tests into CI/CD workflows (Azure DevOps, Jenkins, GitHub Actions, GitLab).
• Data Engineering & Scripting : Strong query skills : Python, PySpark/Spark, SQL, shell scripting.
• Good to have experience with Modern Data Stack:
• DBT - transformation testing and data modeling.
• Collibra - governance, metadata quality, and lineage verification.
• Apache Airflow - workflow automation and testintegrated ETL orchestration.
• Experience across data lakes, warehouses, marts, and semantic layers.
• BI report and dashboard validation across enterprise reporting tools.
• Experience with data migration testing (legacy to modern systems or cloud).
• Strong understanding of insurance domain datasets—policy, commissions, premiums, claims, billing etc.
• Exposure to data quality frameworks, metadata management, and MDM principles.
• Experience validating BI reports (Power BI, Tableau).
• Familiarity with cloud DWH platforms (Snowflake, Azure Synapse, BigQuery).
• Experience with performance testing (e.g., JMeter, Load Runner) is a plus.

Soft Skills

• Strong leadership abilities and a collaborative mindset.
• Excellent problemsolving and analytical skills.
• Clear communication skills, both written and verbal.
• Ability to work effectively with crossfunctional teams.

Preferred Qualifications

• QA or testing certifications (ISTQB, CSTE, CSQE, etc.).
• Experience with AI/MLbased testing tools.
• Understanding of compliance standards (SOC 2, ISO 27001, etc.).

Why Join Gallagher?

• Work with a global organization committed to innovation and employee development.
• Contribute directly to the quality of key software platforms and business outcomes.
• Enjoy a supportive, inclusive, and growthoriented environment.

#LI-NJ1

#Contingent

#APintegration

We offer a competitive and comprehensive compensation package. The base salary range represents the anticipated low end and high end of the range for this position. The actual compensation will be influenced by a wide range of factors including, but not limited to previous experience, education, pay market/geography, complexity or scope, specialized skill set, lines of business/practice area, supply/demand, and scheduled hours. On top of a competitive salary, great teams and exciting career opportunities, we also offer a wide range of benefits. 

Below are the minimum core benefits you’ll get, depending on your job level these benefits may improve:

• Medical/dental/vision plans, which start from day one!
• Life and accident insurance
• 401(K) and Roth options
• Tax-advantaged accounts (HSA, FSA)
• Educational expense reimbursement
• Paid parental leave

Other benefits include:

• Digital mental health services (Talkspace)
• Flexible work hours (availability varies by office and job function)
• Training programs
• Gallagher Thrive program – elevating your health through challenges, workshops and digital fitness programs for your overall wellbeing
• Charitable matching gift program
• And more...

**The benefits summary above applies to fulltime positions. If you are not applying for a fulltime position, details about benefits will be provided during the selection process.

We value inclusion and diversity

Click Here to review our U.S. Eligibility Requirements

Inclusion and diversity (I&D) is a core part of our business, and it’s embedded into the fabric of our organization. For more than 95 years, Gallagher has led with a commitment to sustainability and to support the communities where we live and work.

Gallagher embraces our employees’ diverse identities, experiences and talents, allowing us to better serve our clients and communities. We see inclusion as a conscious commitment and diversity as a vital strength. By embracing diversity in all its forms, we live out The Gallagher Way to its fullest.

Gallagher believes that all persons are entitled to equal employment opportunity and prohibits any form of discrimination by its managers, employees, vendors or customers based on race, color, religion, creed, gender (including pregnancy status), sexual orientation, gender identity (which includes transgender and other gender non-conforming individuals), gender expression, hair expression, marital status, parental status, age, national origin, ancestry, disability, medical condition, genetic information, veteran or military status, citizenship status, or any other characteristic protected (herein referred to as “protected characteristics”) by applicable federal, state, or local laws.

Equal employment opportunity will be extended in all aspects of the employer-employee relationship, including, but not limited to, recruitment, hiring, training, promotion, transfer, demotion, compensation, benefits, layoff, and termination. In addition, Gallagher will make reasonable accommodations to known physical or mental limitations of an otherwise qualified person with a disability, unless the accommodation would impose an undue hardship on the operation of our business.

Qualifications

Education

• Bachelor’s degree in Computer Science, Software Engineering, Information Systems, or related field (or equivalent experience).

Experience

• 6 + years of experience with a strong focus on data-centric testing.
• Proven experience testing ETL processes, data warehouses, data lakes, and complex data transformations.
• Hands on experience with automation tools for Data testing (e.g., Selenium, Query Surge, Datagaps, ACCELQ, python scripts).
• Experience working within Agile/Scrum environments.

Technical Skills

• Automation Tools : Selenium, QuerySurge, Datagaps, ACCELQ, and other test automation frameworks.
• CI/CD Integration : Handson experience embedding automated tests into CI/CD workflows (Azure DevOps, Jenkins, GitHub Actions, GitLab).
• Data Engineering & Scripting : Strong query skills : Python, PySpark/Spark, SQL, shell scripting.
• Good to have experience with Modern Data Stack:
• DBT - transformation testing and data modeling.
• Collibra - governance, metadata quality, and lineage verification.
• Apache Airflow - workflow automation and testintegrated ETL orchestration.
• Experience across data lakes, warehouses, marts, and semantic layers.
• BI report and dashboard validation across enterprise reporting tools.
• Experience with data migration testing (legacy to modern systems or cloud).
• Strong understanding of insurance domain datasets—policy, commissions, premiums, claims, billing etc.
• Exposure to data quality frameworks, metadata management, and MDM principles.
• Experience validating BI reports (Power BI, Tableau).
• Familiarity with cloud DWH platforms (Snowflake, Azure Synapse, BigQuery).
• Experience with performance testing (e.g., JMeter, Load Runner) is a plus.

Soft Skills

• Strong leadership abilities and a collaborative mindset.
• Excellent problemsolving and analytical skills.
• Clear communication skills, both written and verbal.
• Ability to work effectively with crossfunctional teams.

Preferred Qualifications

• QA or testing certifications (ISTQB, CSTE, CSQE, etc.).
• Experience with AI/MLbased testing tools.
...