Data Analyst

OPSEU Pension Trust Fund

Toronto

Hybrid

CAD 74,000 - 86,000

Full time

10 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Benefits after six months
Hybrid work model
Optional membership in defined benefit

Job summary

OPSEU Pension Trust Fund is seeking a Data Analyst (Member Experience and Pension Operations) for a 18-month contract in Toronto. The role focuses on data management, accuracy of member information, and collaboration with employers to ensure data integrity.

You will perform data reconciliation, testing, and support special projects, delivering excellent service to members and employers while contributing to continuous improvement initiatives.

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 transactions.
  • Proficient in MS Office (Word/Excel) and business software applications.
  • SQL and MS Power BI are assets.
  • Strong customer service orientation and interpersonal skills.
  • Positive attitude toward teamwork and company values.

Responsibilities

  • Ensure accuracy of member data in the pension administration database.
  • Manage expected data, reconcile and correct received data.
  • Consult with employers on data requirements and provide project support.
  • Perform user acceptance testing and assist with special projects.
  • Deliver high-quality service across external employer interactions.
  • Support data control procedures to improve data quality.

Skills

Analytical thinking
Problem solving
Interpersonal skills
Communication
Organizational skills
Attention to detail

Education

Post-secondary education or equivalent
PPAC/CEBS certification
OPSEU Pension Plan knowledge

Tools

SQL
MS Power BI
MS Office

Job description

Data Analyst (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.

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 careers@optrust.com, 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.

With net assets of over $27 billion, OPTrust invests and manages one of Canada's largest pension funds and administers the OPSEU Pension Plan (including OPTrust Select), a defined benefit plan with 118,000 members. OPTrust was established to give plan members and the Government of Ontario an equal voice in the administration of the Plan and the investment of its assets through joint trusteeship. OPTrust is governed by a 10-member Board of Trustees, five of whom are appointed by OPSEU/SEFPO and five by the Government of Ontario.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Analyst
Business Analyst

OPSEU Pension Trust Fund • Toronto

Hybrid
CAD 98,000 - 121,000
Hybrid work model
Benefits package
Professional development
Pension Benefits Consultant
Pension Benefits Consultant

OPSEU Pension Trust Fund • Toronto

Hybrid
CAD 74,000 - 86,000
Benefits after 6 months
Defined benefit pension plan
Diversity and inclusion programs
Senior Public Affairs Advisor
Senior Public Affairs Advisor

OPSEU Pension Trust Fund • Toronto

Hybrid
CAD 105,000 - 129,000
Flexible hybrid work model
Manager, Corporate Reporting and Financial Services
Manager, Corporate Reporting and Financial Services

OPTrust • Toronto

Hybrid
CAD 120,000 - 165,000
Hybrid work model
World-class defined benefit pension
Comprehensive benefits includinghealth
+5
Senior Public Affairs Advisor
Senior Public Affairs Advisor

OPTrust • Toronto

Hybrid
CAD 105,000 - 129,000
Hybrid work model
Benefits after six months
Pension plan option
Business Analyst
Business Analyst

OPTrust • Toronto

Hybrid
CAD 98,000 - 121,000
Hybrid work model
Health and wellness benefits
Tuition reimbursement
+1
Pension Benefits Consultant
Pension Benefits Consultant

OPTrust • Toronto

Hybrid
CAD 74,000 - 86,000
Hybrid work model
Benefits after six months
Optional defined benefit pension plan
+2
Business Analyst- Technology Risk and Control
Business Analyst- Technology Risk and Control

OPTrust • Toronto

Hybrid
CAD 98,000 - 121,000
Hybrid work model
Benefits package
Pension plan
+2
Analyst, Pension Accounting Operations (12 month Contract)
Analyst, Pension Accounting Operations (12 month Contract)

Healthcare of Ontario Pension Plan Trust Fund Company • Toronto

On-site
CAD 71,000 - 109,000
Health benefits
Dental benefits
Health spending account
+2
Business Analyst
Business Analyst

Healthcare of Ontario Pension Plan Trust Fund Company • Toronto

On-site
CAD 71,000 - 109,000
Defined benefit pension plan
Health and dental benefits (100% paid)
Learning & development via LinkedIn
+1