Gallagher · 1 week ago
Quality Automation Lead - Contract to Hire
United States
Full-time, Contract
Remote
Lead/Staff
$70K/yr - $136K/yr
6+ years expGallagher is a global community dedicated to helping clients navigate complexity with confidence. The Quality Automation Lead will architect enterprise data integrity and validation strategies while building automated testing solutions to ensure accurate and trusted insurance data across BI and reporting platforms.
ConsultingFinanceProperty & Casualty InsuranceFinancial ServicesInsuranceManagement ConsultingRisk Management
No H1B
Hiring Manager
Nayana Jodigatte Chinnappa
Responsibilities
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
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
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
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
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
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
Qualification
Required
Bachelor's degree in Computer Science, Software Engineering, Information Systems, or related field (or equivalent 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
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
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)
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
QA or testing certifications (ISTQB, CSTE, CSQE, etc.)
Experience with AI/ML‑based testing tools
Understanding of compliance standards (SOC 2, ISO 27001, etc.)
Benefits
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
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
Company
Gallagher
Gallagher is an international insurance brokerage and risk management services firm.
10001+ employees
Funding
Current Stage
Public CompanyTotal Funding
$9.7B2024-12-09Post Ipo Equity· $8.5B
2023-06-22Post Ipo Debt· $1.2B
1984-06-29IPO
Leadership Team
Alec Herring
Area Senior Vice President
Mark Gresser
Executive Vice President
Recent News
Coverager - Insurance news and insights
2026-07-10
2026-07-07
2026-07-07
Company data provided by crunchbase