Senior QA Engineer - Data and ETL Testing

The Opportunity

We are currently seeking a Senior Quality Assurance Engineer with expertise in Data and ETL testing to join our team in the Canadian Sector Technologies & Platforms consulting group. This is an exciting opportunity to play a key role in transforming businesses by ensuring the integrity accuracy and performance of their data systems. As part of EYs technology team youll work on highimpact projects with clients across industries using cuttingedge tools and methodologies to drive digital transformation.

This role offers the chance to work collaboratively with leading financial institutions and innovative companies helping them navigate complex data challenges enhance data quality and ensure robust ETL processes. If you are an experienced QA professional with strong data testing and automation skills we want to hear from you.

Your Key Responsibilities

As a Senior QA Engineer specializing in Data and ETL you will:

• Lead the quality assurance efforts for datadriven solutions ensuring the successful validation of data and ETL pipelines.
• Develop and execute comprehensive test strategies plans and cases for ETL processes data transformations and integrations.
• Work with stakeholders to define and understand data quality requirements transforming them into actionable testing strategies.
• Implement and drive test automation for ETL processes using industryleading tools and frameworks.
• Collaborate with data engineers developers and business analysts to identify potential risks and resolve data quality issues.
• Optimize data validation procedures to improve testing efficiency and accuracy.
• Document test results report on quality metrics and communicate findings with stakeholders ensuring transparency in testing processes.
• Stay updated on emerging data technologies and incorporate best practices into testing methodologies.

Skills and Attributes for Success

• Strong understanding of data validation ETL processes and data architecture.
• Proficiency in SQL for data validation and transformation testing.
• Experience with data integration warehousing and cloudbased data platforms.
• Handson experience with ETL tools and frameworks to drive efficient data processing.
• Ability to apply data quality assurance practices to ensure data integrity and accuracy.
• Strong problemsolving skills with an analytical approach to identifying and resolving data issues.
• Effective communication and collaboration skills able to work crossfunctionally with business development and data teams.
• Ability to design and execute automated testing strategies to validate data accuracy and pipeline integrity.

Technical Skills:

• Proficiency in Python SQL or Java for data engineering and ETL processes.
• Extensive experience with ETL tools like Informatica Talend SSIS or Apache Nifi.
• Handson experience with cloud platforms such as AWS Azure and Google Cloud for data storage and processing.
• Proficient in data warehousing technologies including Amazon Redshift Snowflake and Microsoft Azure Synapse.
• Strong knowledge of relational databases (MySQL PostgreSQL SQL Server) and NoSQL databases (MongoDB Cassandra).
• Experience with big data tools such as Apache Hadoop Spark and Kafka for distributed data processing.
• Familiarity with version control systems like Git and CI/CD processes for automating data workflows.
• Expertise in data validation quality assurance and data profiling techniques.
• Experience using data visualization tools like Power BI or Tableau to create dashboards and reports.

To Qualify for the Role You Must Have

• 5 years of experience in Quality Assurance focusing on data and ETL testing.
• Proven expertise in designing and executing complex data validation tests for largescale data systems.
• Experience working in fastpaced Agile environments and delivering highquality results under tight deadlines.

Ideally Youll Also Have

• Familiarity with data visualization tools (e.g. Tableau Power BI.
• Knowledge of CI/CD pipelines and how they relate to QA automation.
• Previous consulting or Big 4 experience is highly desirable.

Nice to Have: Domain Knowledge and Regulatory Understanding

• AML (AntiMoney Laundering) Knowledge: Understanding the concepts and regulations around AML including KYC (Know Your Customer) suspicious activity detection and regulatory reporting. Familiarity with how iGaming platforms must comply with Ontarios regulatory frameworks and gaming laws.
• Gaming Industry Familiarity: Knowledge of how online gaming platforms operate including customer registration transaction monitoring reporting requirements and handling sensitive player data. Familiarity with the risks specific to online gaming.
• Regulatory Reporting: Understanding of what kind of data and reports are required for regulatory compliance in iGaming and how to validate that those reports are correctly generated accurate and timely.

Education

• A Bachelors degree in Computer Science Information Systems Management Engineering or a similar discipline.

What We Look For

Were seeking professionals who can adapt to everchanging environments thrive in complex ambiguous situations and contribute to building longterm innovative solutions. Strong interpersonal skills and the ability to communicate complex ideas simply are essential for success. If youre a selfstarter whos passionate about driving excellence in data quality and technology solutions wed love to have you on our team.

What We Offer

At EY our Total Rewards package supports our commitment to creating a leading people culture built on highperformance teaming where everyone can achieve their potential and contribute to building a better working world for our people our clients and our communities. We offer:

• Competitive compensation based on your performance and the value you bring to the business.
• A comprehensive medical prescription drug and dental coverage plus a defined contribution pension plan.
• Paid vacation days firmpaid holidays and personal days for a healthy worklife balance.
• Access to learning and development programs to help you grow your skills and progress in your career.
• Flexible work arrangements including the option to work from home and in the office 3 days per week).
• A diverse inclusive culture where everyone feels they belong.
  

The salary range for this job in British Columbia is $72000 to $132000. Individual salaries within this range are determined through a wide variety of factors including but not limited to education experience knowledge skills and work location city.

Diversity and Inclusion at EY

Diversity and inclusiveness are at the heart of who we are and how we work. Were committed to fostering an environment where differences are valued policies and practices are equitable and our people feel a sense of belonging. We embrace diversity and are committed to combating systemic racism advancing gender equity and women in leadership advocating for the 2SLGBTQIA community promoting ourneuroinclusionand accessibility initiatives and are dedicated to amplifying the voices of Indigenous peoples (First Nations Inuit and Mtis) nationally as we strive towards reconciliation. Our diverse experiences abilities backgrounds and perspectives make our people unique and help guide us. Because when people feel free to be their authentic selves at work they bring their best and are empowered to build a better working world.