Why join us?

Are you looking to join a dynamic pension plan that embodies the strong values of its 500,000 members and is an industry leading global investor? If so, we would love to tell you our story.

At OMERS we put our people first and are proud to embrace the diversity of thought and leadership that comes from having locations in Toronto, London, New York, Singapore, Sydney and other major cities across North America and Europe. Our culture is truly one of a kind. We get stuff done, and have fun doing it! We take great pride in contributing to the communities where we live with an ever-constant eye to the global investment markets.

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

We believe that time together in the office is important for OMERS and Oxford, the strength of our employees, and the work we do for our pension members. In delivering on our pension promise, keeping us connected to our work and each other, our flexible hybrid work guideline requires teams to come in to the office 1 day per week.

Our story:

Founded in 1962, OMERS is one of Canada’s largest defined benefit pension plans, with $128.6 CAD billion in net assets as of December 31, 2023. 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’s 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 – 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.