Acceptance Testing, Agile Programming Methodologies, Analysis Skills, Apache, Apache JMeter, Application Programming Interface (API), Artificial Intelligence (AI), Automation, Best Practices, Billing, Brokerage, Bug Tracking/Defect Management, Business Intelligence, Business Strategy, Cloud Computing, Communication Skills, Community Support, Compensation and Benefits, Computer Science, Consulting, Continuous Deployment/Delivery, Continuous Improvement, Continuous Integration, Cross-Functional, Customer Relations, Data Collection, Data Management, Data Mapping, Data Migration, Data Modeling, Data Processing, Data Profiling, Data Quality, Data Sets, Data Warehousing, Database Extract Transform and Load (ETL), Dental Insurance, DevOps, Diversity, Embedded Systems, Enterprise Architecture, Enterprise Data Integration, Equal Employment Opportunity (EEO), Fitness, Flexible Spending Accounts, GitHub, Healthcare, Home Automation, ISO (International Organization for Standardization), ISTQB Foundation, Information Technology & Information Systems, Insurance, Jenkins, Leadership, LoadRunner, Master Data Management (MDM), Matching Gift Programs, Medical Conditions, Medical Genetics, Mentoring, Metadata, Microsoft Windows Azure, Military, Operational Audit, Performance Testing, Power BI, Presentation/Verbal Skills, Problem Solving Skills, Process Improvement, Product Engineering, Psychiatry and Mental Health, Python Programming/Scripting Language, Quality Assurance, Quality Assurance Methodology, Quality Engineering, Quality Metrics, Reconciliation, Regulatory Compliance, Reporting Dashboards, Risk Analysis, Risk Management, SQL (Structured Query Language), Scalable System Development, Scripting (Scripting Languages), Scrum Project Management and Software Development, Selenium, Software Engineering, Staff Development, Structured Data, Sustainability, System Integration (SI), System Validation, Tableau, Team Player, Test Automation, Test Data, Test Harness, Test Tools, Testing, Training Program, Unix Shell Programming, Vision Plan, Writing Skills
Rolling Meadows, Illinois
Welcome to Gallagher - a global community of people who bring bold ideas, deep expertise, and a shared commitment to doing what’s right. We help clients navigate complexity with confidence by empowering businesses, communities, and individuals to thrive. At Gallagher, you’ll find more than a job; you’ll find a culture built on trust, driven by collaboration, and sustained by the belief that we’re better together. Whether you join us in a client-facing role or as part of our brokerage division, our benefits and HR consulting division, or our corporate team, you’ll have the opportunity to grow your career, make an impact, and be part of something bigger. Experience a workplace where you’re encouraged to be yourself, supported to succeed, and inspired to keep learning. That’s what it means to live The Gallagher Way.
Overview:
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 high‑quality 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.
How you'll make an impact:
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, defense‑in‑depth 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 data‑pipeline validation frameworks, lead complex data migration reconciliations, and drive UAT readiness to maintain a reliable, enterprise‑wide 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 multi‑layered architectures.
- Perform comprehensive data profiling, schema validation, and quality rule testing thru Automation.
- Ensure accuracy, completeness, and consistency across large‑scale datasets and integrated systems.
- Integrate automated checks into orchestration tools such as Apache Airflow.
Data Migration Testing
- Lead high‑visibility data migration and system conversion validation initiatives.
- Define and execute reconciliation strategies across source and target systems to ensure zero‑defect migration outcomes.
- Drive cross-functional resolution of data discrepancies and mapping issues.
Reporting & BI Testing
- Validate end‑to‑end data flows supporting enterprise BI and reporting platforms.
- Perform report‑to‑data source validation for dashboards, operational reports, and analytical applications.
- Certify UAT readiness with structured data validation, defect management, and sign‑off 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 event‑driven data flows.
- Implement governance‑aligned 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 on‑time delivery of testing milestones through proactive risk identification, mitigation planning, and issue resolution.
- Support Agile ceremonies and coordinate test planning, execution, and reporting.
About you:
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 : Hands‑on 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 test‑integrated 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 problem‑solving and analytical skills.
- Clear communication skills, both written and verbal.
- Ability to work effectively with cross‑functional teams.
Preferred Qualifications
- QA or testing certifications (ISTQB, CSTE, CSQE, etc.).
- Experience with AI/ML‑based 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 growth‑oriented environment.
#LI-NJ1
#Contingent
#APintegration
Compensation and benefits:
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 Hereto 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.