Data QA Engineer at EXL in Dublin, Leinster, Ireland

Job description

• The Data QA Engineer will own and drive quality assurance across our data products, ensuring the delivery of reliable, accurate, and high-performing solutions through a combination of manual and automated testing.
• This role is responsible for defining and executing test strategies, championing quality best practices, and embedding a quality-first mindset across the engineering organisation. The Data QA Engineer will also provide clear, accurate, and timely reporting on test progress, quality risks, and defect status, enabling informed release decisions and continuous improvement of product quality.

Responsibilities

• Data Pipeline & ETL Testing
• Validate end-to-end data pipelines from source systems to data marts.
• Test batch data loads.
• Validate transformations, aggregations, and derived metrics.
• Ensure data completeness, accuracy, and consistency across layers.
• Understanding of data governance, privacy, and PII handling
• Data Warehouse & Data Mart Validation
• Write complex SQL queries to validate fact and dimension tables in Redshift.
• Validate data models (fact/dimension, keys, relationships)
• Perform reconciliation between raw, curated, and reporting layers.
• Validate business KPIs and metrics against source systems and definitions.
• Operational Monitoring & Troubleshooting
• Validate data ingestion in S3 (file counts, schema, partitions, formats)
• Review Glue job and Lambda execution logs to troubleshoot data issues.
• Monitor pipeline health, failures, and data refresh SLAs.

Requirements

• Qualifications and experience we consider to be essential for the role:
• Strong SQL skills (joins, aggregations)
• Hands-on experience testing data pipelines, ETL, or data warehouses
• AWS Glue
• AWS Lambda
• AWS Step Functions
• AWS Redshift
• AWS Athena
• AWS CloudWatch
• Experience validating structured and semi-structured data (Parquet, JSON, CSV)
• Solid understanding of data warehousing concepts and dimensional modelling
• 5+ years’ experience in software quality assurance with a strong focus on manual testing
• Proven experience testing complex web and/or mobile applications
• Familiarity with browser developer tools for debugging network, console, and UI issues
• Strong understanding of QA methodologies, SDLC, and Agile/Scrum
• Excellent test design, defect management, and reporting skills
• Experience with Jira, TestRail, or similar tools
• Automation skills to write automated tests for pipelines using a language like Python.
• Experience integrating automated tests into CI/CD pipelines (e.g. Azure DevOps)

Skills

Required

• Strong SQL skills (joins, aggregations)

Benefits

• As part of a leading global Data and AI company, you can look forward to:
• A competitive salary with a generous bonus, private healthcare, life assurance at 4 x your annual salary, income protection insurance, and a rewarding pension.
• At EXL, we are committed to providing our employees with the tools and resources they need to succeed and excel in their careers. We offer a wide range of professional and personal development opportunities. We also support a range of learning initiatives that allow our employees to build on their existing skills and knowledge. From online courses to seminars and workshops, our employees have the opportunity to enhance their skills and stay up to date with the latest trends and technologies.