EY Senior QA Engineer - Data ETL Testing 

Canada, Ontario, Toronto 

692063079

Your Key Responsibilities

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

• Lead the quality assurance efforts for data-driven 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 industry-leading 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 cloud-based data platforms.
• Hands-on 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 problem-solving skills with an analytical approach to identifying and resolving data issues.
• Effective communication and collaboration skills, able to work cross-functionally 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.
• Hands-on 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 large-scale data systems.
• Experience working in fast-paced, Agile environments and delivering high-quality results under tight deadlines.

Ideally, You’ll 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 (Anti-Money 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 Ontario's 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 Bachelor’s degree in Computer Science, Information Systems Management, Engineering , or a similar discipline.

What We Offer

At EY, our Total Rewards package supports our commitment to creating a leading people culture, built on high-performance 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, firm-paid holidays, and personal days for a healthy work-life 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 $72,000 to $132,000. 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.