Job Description

Why join us?

We are looking for skilled test automation developers that are comfortable with SQL, python, and data to join our Products & Technology team in Toronto. We are interested in building world-class products in a collaborative environment with our developers. As QA members on Agile product teams, our primary focus is to provide real value both to our teams and to our 500,000 members.

You will be joining our Business Intelligence team and be responsible for testing the data analysis and reports they deliver for the business. This is an opportunity to start building test automation from the ground up.

Tools and technologies used on this team include:

SQL Server / OracleDB

Python

PowerBI

Data Analysis Expressions (DAX)

Git (Gitlab)

Azure Data Factory

Azure Function App

Jira defect management

Other test automation tools available in our department include WebdriverIO and ReadyAPI.

Some concepts you will need to know:

How to break down business-oriented user stories into small granular tests

Leveraging every layer of the test pyramid to get the best ROI from automation

How to integrate test automation effectively into developer workflows/pipelines

The relationship between manual and automated testing, including when not to automate

How to use automation to provide direct value to the product team

As a QA Engineer, you are part of a 20+ person Quality Assurance group. Your responsibilities will include:

Being an active member of the product team, including contributing to planning and design discussions with testability in mind

Developing test plans based on business requirements and technical design documents, and following through on implementing that plan

Understanding our overall automation strategy and making sure the team is adopting it, including automating as early in the development process as possible

Working to reduce the amount of scripted manual tests in favour of automation, and reworking any existing automated tests to make sure the test coverage is clear and understandable

Performing both manual and automated tests as needed for the team to deliver new functionality and meet biweekly release commitments

Reporting on the status of testing and any ongoing issues to your team and stakeholders

To succeed in this role, you have:

3-5 years direct experience in overseeing the design, development, and implementation of quality assurance standards for software testing

3-5 years direct experience with automated testing frameworks in a variety of test automation frameworks

In-depth experience with constructing and validating, and executing complex SQL queries including joins and subqueries

3-5 years of experience in data driven/data warehouse process testing and deployment testing

3-5 years of experience performing Power BI reports/dashboard testing

Hands on knowledge of Azure Data Factory/Azure Function App (nice to have)

Good experience in Jira defect management

Ability to learn and understand data warehouse/database concepts, data process flow and procedures quickly to identify bugs and issues

Ability to exercise good judgement and work well independently, multitask, and follow through on tasks to completion

Experience working with python, especially for working with data or test automation

Knowledge of testing concepts and methodologies used in Agile contexts

Knowledge of pension standards legislation (e.g. Pension Benefit Act, Income Tax Act), a comprehensive knowledge of at least one pension lifecycle event, or a working understanding of financial and retirement planning concepts would be a plus

Our story:

Founded in 1962, OMERS is one of Canada\xe2\x80\x99s largest defined benefit pension plans, with $124 billion in net assets as at December 31, 2022. OMERS is a jointly-sponsored pension plan, with more than 1,000 participating employers ranging from large cities to local agencies, and over half a million active, deferred and retired members. OMERS members include union and non-union employees of municipalities, school boards, local boards, transit systems, electrical utilities, emergency services and children\xe2\x80\x99s aid societies across Ontario. Contributions to the Plan are funded equally by members and employers. OMERS teams work in Toronto, London, New York, Amsterdam, Luxembourg, Singapore, Sydney and other major cities across North America and Europe \xe2\x80\x93 serving members and employers and originating and managing a diversified portfolio of high-quality investments in public markets, private equity, infrastructure and real estate.

OMERS is committed to having a workforce that reflects the communities in which we live and work. We are an equal opportunity employer committed to a barrier-free recruitment and selection process. At OMERS inclusion and diversity means belonging. How we create a sense of belonging is through our employees and our vast network of Employee Resource Groups. Whether you are passionate about gender, pride, or visible minorities, we have groups that are focused on making a difference in all of our lives.

Omers