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 EY's technology team, you'll work on high-impact projects with clients across industries, using cutting-edge 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 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 Look For

We're seeking professionals who can adapt to ever-changing environments, thrive in complex, ambiguous situations, and contribute to building long-term, innovative solutions. Strong interpersonal skills and the ability to communicate complex ideas simply are essential for success. If you're a self-starter who's passionate about driving excellence in data quality and technology solutions, we'd 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 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.

Diversity and Inclusion at EY

Diversity and inclusiveness are at the heart of who we are and how we work. We're 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 our neuroinclusion and accessibility initiatives, and are dedicated to amplifying the voices of Indigenous peoples (First Nations, Inuit, and Métis) 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.