Data Analyst

OPTrust; Toronto; Hybrid; CAD 74,000 - 86,000; Full time

Benefits offered by this job

Hybrid work model

Benefits after six months

Pension plan membership

Job summary

OPTrust is seeking a Data Analyst for a 18-month contract in Toronto (Hybrid). You will ensure accuracy of member data in the pension administration database, manage data interfaces, reconcile data, and support employer communications.

The role involves data testing and participating in special projects. Ideal candidates have post-secondary education and knowledge of pension plans, with strong MS Office skills, SQL, and Power BI.

Qualifications

• Post-secondary education or equivalent.
• PPAC/CEBS certification is an asset.
• Knowledge of OPSEU Pension Plan text provisions and pension administration to process simple case transactions and understand pension data relationships.
• Proficient in MS Office (Word and/or Excel), and business software applications; SQL and Power BI are asset.
• Strong interpersonal and customer service orientation.

Responsibilities

• Ensure accuracy of members’ information in the pension administration database and perform data management and correction services.
• Reconciling and correcting received data; support employers on data requirements.
• Provide user acceptance testing and testing criteria; support special projects.
• Develop and maintain employer communications and data interface processing; document data issues and corrections.

Skills

MS Office

SQL

Power BI

Customer service

Data accuracy

Education

Post-secondary education or equivalent

PPAC/CEBS certification (asset)

Tools

MS Power BI

Job description

Data Analyst

Department: Member Experience and Pension Operations

Type: Contract – 18 Months

Location: Toronto (Hybrid)

Posting Date: October 08, 2026

At OPTrust, _ paying pensions today, preserving pensions for tomorrow _ is our mission and business.

When you choose OPTrust, you join a team of smart, talented people who fuel our success and have a passion for pensions. Everyone at OPTrust – in Toronto, London and Sydney – makes a meaningful impact. Our culture is driven by team members with different backgrounds and perspectives creating an inclusive and fulfilling place to work for everyone. We work in a fast-paced environment, but we find time to have fun and give back to the community.

What OPTrust offers you

• Unique culture rooted in our core values – collaboration and teamwork, integrity, respect, flexibility, excellence and continuous improvement.
• A purpose-driven environment where we all work towards the common goal of paying pensions today and preserving pensions for tomorrow.
• A flexible, hybrid work model.
• Benefits package after six months of consecutive employment.
• Optional membership in our world-class defined benefit pension plan.
• A dedicated inclusion, diversity and equity strategy with meaningful opportunities to participate, including our employee-led resource groups.
• undefined

About the role

The successful candidate will be responsible for ensuring the accuracy of members’ information in the pension administration database by providing data management and correction services. The role includes managing expected data, reconciling and correcting received data, consulting with employers on data requirements, providing support services on special projects, and performing user acceptance testing. The candidate will deliver a remarkable service experience across key external interactions with various employers.

What you’ll do

Processing & Data Management

• Handles the entire cycle of interface processing to ensure that member data received from employers is properly processed.
• Supports internal controls by reconciling reports from the pension database to ensure that the integrity of the database is maintained.
• Manages expected data, reconcile and purify received data through data control procedures.
• Performs data investigation, problem-solving, and admin system user support.
• Creates testing criteria and performs user acceptance testing.
• Special project support: Annual Pension Statement run, Actuarial Extract, LTIP with full membership historical analysis and data correction.
• Administration support for the control of special projects, maintaining spreadsheets, and providing file control.
• Assists ongoing review of data control procedures to improve overall data quality. Related tasks may include:
• Identifying and documenting trends in data problems and passing on information and suggestions regarding improved data handling to senior staff and manager.

Employer Services & Communication

• Develops and maintains close contacts with employer representatives regarding data interface processing, data reconciliation, and general OPTrust communication efforts with employers.
• Instructs employers on expected interface transactions required for data correction.
• Written communication skills to prepare requests for information from employers, data problem descriptions, and data correction instructions.
• Verbal skills to communicate with Employers, clients, and OPTrust staff on data and system issues in a way that is clearly understood.

Change Management & Process Enhancement

• Participates in special projects aimed at improving the link between OPTrust and its employers or improving services to members and pensioners.
• Participates in cross-functional project teams responsible for implementing new business systems and processes or procedures.
• Participates in user acceptance testing of new systems applications.
• Supports initiatives in achieving department benchmarks and goals.
• Recommends and implements efficiency changes where process gaps are identified.
• Participates in project teams that review and/or develop procedures.
• Performs other duties as assigned.
• Ensures clear understanding and adherence of all OPTrust’s policies, procedures, guidelines, as well as living our values and fostering an inclusive culture.

What you bring

• Post‑secondary education or equivalent.
• PPAC/CEBS certification is an asset.
• Knowledge of OPSEU Pension Plan text provisions and pension administration to process simple case transactions and understand pension data relationships.
• Proficient in MS Office (Word and/or Excel), and business software applications. SQL and working knowledge with MS Power BI an asset.
• Interpersonal skills and a strong customer service orientation to deal with clients, Employers, and OPTrust staff with sensitivity and tact.
• Positive attitude towards work and work colleagues to support team goals and organization values of strong teamwork, cooperation, and mutual respect.
• Analytical/Problem‑solving skills to identify and resolve membership data problems.
• Mathematical skills and attention to detail to perform data corrections.
• Organizational skills to handle a large volume of work and prioritize multiple tasks in an efficient manner.
• Exemplify OPTrust’s values: collaboration and teamwork, integrity, respect, flexibility, excellence, and continuous improvement.

This posting is for an existing vacancy.

The range of expected compensation for this position is $73,792.00 to $85,720.00 per year.

Serving a membership as diverse as ours and investing in a global market means cultivating an environment that embraces inclusion, diversity, and equity in everything we do. OPTrust is an organization engaged in building on our unique and diverse strengths. We know a diversity of backgrounds, cultures, gender identities and perspectives are critical to achieving our shared goals.

If you require accommodation at any time during the recruitment process, please send a message to [e-mail], or discuss your needs with the Talent Acquisition Consultant during the telephone screening. We will do our best to work with you and provide appropriate accommodation.

As an organization we’re seeking ways to respond to the Truth and Reconciliation Commission of Canada’s Call to Action 92. We are working with the Canadian Council for Indigenous Business to build bridges with Indigenous communities and partners, and we have created an employee‑led Reconciliation Working Group that will work with Indigenous experts to identify a path to reconciliation for our organization.

We thank all interested applicants, however only those under consideration will be contacted.