Find work in Canada.

326,097 jobs across our Canadian network. How we count

Jobs in Canada

Email me new jobs Save this search

Added 5 months ago
D365 CE & Power Platform Developer
National Research Council Canada
Halifax, NS
What if your next Dynamics 365 project helped Canadian companies turn breakthrough ideas into real-world products?
Added 9 days ago
Management Information Analyst
ICES
Toronto, ON
Contract
Collaborate with project teams to understand data requirements and implement cleaning processes that align with research objectives, ensuring that all datasets are accurate and reliable for…
Added 10 days ago
Information Management Analyst
ICES Central
Toronto, ON
Full-time · Temporary
Collaborate with project teams to understand data requirements and implement cleaning processes that align with research objectives, ensuring that all datasets are accurate and reliable for…
Added 11 days ago
Reporting Analyst
AtkinsRéalis
Mississauga, ON
Full-time
The Reporting Analyst supports project reporting by independently collecting, validating, and consolidating project data to produce routine reports, dashboards, and summaries that support…
Added 10 days ago
Accounting Manager/Senior Accountant
Dexcent
Edmonton, AB
Full-time
…information analytics, cyber-security, infrastructure, and control systems engineering. As such, we pride ourselves on truly transforming industrial operations to optimize business…
Added 11 days ago
Senior Systems Analyst, Production Support
CBC/Radio-Canada
Vancouver, BC
Full-time
Senior Systems Analyst manages and supports server-based systems and processes within CBC-Radio Canada’s media production ecosystem.
Added 10 days ago
Environmental Compliance Analyst (12-month contract)
Town of Pelham
Fonthill, ON
Full-time
Reporting to the Public Works Manager, the Environmental Compliance Analyst is responsible for managing the stormwater, water and wastewater services compliance programs, including the…
Added 10 days ago
Reporting Analyst
AtkinsRéalis
Mississauga, ON
Full-time
The Reporting Analyst supports project reporting by independently collecting, validating, and consolidating project data to produce routine reports, dashboards, and summaries that support…
Added 10 days ago
Reporting Analyst
AtkinsRéalis
Mississauga, ON
Full-time
The Reporting Analyst supports project reporting by independently collecting, validating, and consolidating project data to produce routine reports, dashboards, and summaries that support…
Added 10 days ago
Senior Systems Analyst, Production Support
CBC/Radio-Canada
Vancouver, BC
Full-time
Senior Systems Analyst manages and supports server-based systems and processes within CBC-Radio Canada’s media production ecosystem.
Added 10 days ago
Senior Financial Analyst
British Columbia Institute of Technology
Burnaby, BC
$81,091 to $111,500 CAD / year
Full-time
BCIT’s Financial Services department is seeking a regular, full-time (1.0 FTE) Senior Financial Analyst. This position works with and provides financial support to BCIT managers and the…
Added 11 days ago
Automation Controls Sr. Analyst /Consultant
Accenture
Calgary, AB · Vancouver, BC · Mississauga, ON · Ottawa, ON · Toronto, ON
Full-time
Be responsible for the completion of all project requirements, including, but not limited to:
Added 10 days ago
Senior Analyst, Production Support
Radio-Canada
Vancouver, BC
Full-time
Senior Systems Analyst manages and supports server-based systems and processes within CBC-Radio Canada’s media production ecosystem.
Added 10 days ago
Sr. Investment Analyst
Brookfield Residential
Toronto, ON
Full-time
The Sr. Investment Analyst (Canada) will support national capital deployment and investment decision-making by performing financial analysis and underwriting for new opportunities across…
Added 2 months ago
Reconciliation Analyst
BI Control
Halifax, NS
Full-time
As a Reconciliation Analyst, you will be responsible for developing and managing reconciliation processes within our platform for various clients. You will work closely with clients to…
Added 11 days ago
Engineering Lead Analyst - VP
Citi
Mississauga, ON
Full-time
The Engineering Lead Analyst is a senior level position responsible for leading a variety of engineering activities including the design, acquisition and deployment of hardware, software…
Added 11 days ago
Engineering Lead Analyst - VP
Citi
Mississauga, ON
Full-time
The Engineering Lead Analyst is a senior level position responsible for leading a variety of engineering activities including the design, acquisition and deployment of hardware, software…
Added 10 days ago
Senior Business Analyst
Mutual Fire Insurance
Langley (District), BC · Langley, BC
$90,000 to $115,000 CAD / year
Full-time
This role is a permanent full-time position. The Senior Business Analyst is a trusted liaison between business users, vendors, and information technology. They will actively oversee…
Added 11 days ago
Sr. Investment Analyst
Brookfield Properties
Toronto, ON
Full-time
The Sr. Investment Analyst (Canada) will support national capital deployment and investment decision-making by performing financial analysis and underwriting for new opportunities across…
Added 11 days ago
Senior Data Analyst
OPTrust
Toronto, ON
Full-time
Control code table administration for the pension database and security requests for special project users.
Added 11 days ago
INVESTIGATIVE ANALYST (HYBRID)
Green Shield Canada
Calgary, AB · Toronto, ON · Windsor, ON
Identify and recommend cost‑containment and risk‑mitigation opportunities, including automation and control enhancements.
Added 10 days ago
Investigative Analyst
GreenShield
Toronto, ON
$59,688 to $91,109 CAD / year
Full-time
Identify and recommend cost‑containment and risk‑mitigation opportunities, including automation and control enhancements.
Added 10 days ago
Senior Data Analyst
OPTrust
Toronto, ON
Contract
Control code table administration for the pension database and security requests for special project users.
Added 10 days ago
Senior IT Business Analyst
Master
Saint-Bruno-de-Montarville, QC · St-Bruno-de-Montarville, QC
Full-time
Reporting to the Portfolio Director, Transformation, you act as the Business Analyst supporting a portfolio of strategic technology initiatives - including ERP lifecycle resilience,…
Added 10 days ago
Investment Analyst, Stewardship, Publications
Minnesota Direct Care and Treatment
Saint-Paul, NB · St.-Paul, NB
Full-time
Working Title: Investment Analyst, Stewardship, Publications

OPTrust

Senior Data Analyst

Toronto, ON, Canada

Pay: The range of expected compensation for this position is $104,550 - $128,763 per year.
Job type: Contract
Apply by: Oct 16, 2026
Posting language: English
Posted: Sep 16, 2026

Apply About employer

Applications open in a new tab.

Original job description

Senior Data Analyst

Department: Member Experience and Pension Operations

Type: 18-Month Contract

Location: Toronto (Hybrid)

Posting Date: July 21st, 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

This role is accountable for delivering technical expertise and contributing to the development and maintenance of data management practices. The mandate includes designing and implementing business processes, systems, methods and procedures that ensure accurate reconciliation, strong controls, and a high standard of quality and integrity for employer and plan member information. In addition, this position is responsible for building and maintaining reporting solutions using business intelligence tools, enabling actionable insights and informed decision-making across the organization.

What you’ll do

Provide expertise on business intelligence and data management standards, business process operating methods, and work procedures. Examples of key tasks include:

Build and prepare statistical reports and/or presentations on results, findings, and recommendations related to business process reviews and ongoing data management functions, identifying and documenting trends in data problems and passing on information and suggestions regarding improved data handling and control to the manager.
Provide support to product owners by generating and presenting data in a form that assists with business decisions (trends, projections, volumes, etc.).
Work with datasets by extracting, transforming, organization, and translating raw data into actionable insight, data workflow, and work-inventory management for the department to maintain service levels, productivity, and standards.
Analyze and establish internal work processes, procedures, and controls related to the entire cycle of data interface processing and reconciliation.
Follow up with OPTrust staff and employers to resolve data processing and reconciliation problems, including source file issues, membership and contribution split reconciliations, problem-solving of aborted updates of the pension database, and recovery implementation.
Represent OPTrust in discussions with employers regarding OPTrust data control and integrity requirements.
Follow up and assist employers in reviewing work processes and procedures related to member data.
Detect and implement solutions to complex data integrity issues with employers and OPTrust business areas.
Design and deliver presentations, education, and training to employer representatives or OPTrust staff regarding data management processes, systems, and procedures.
Develop and support initiatives in achieving departmental benchmarks and goals.
Work with individual smaller employers/payroll providers to improve their extract programmes to meet OPTrust’s requirements.
Develop structured testing of data received to improve business processes.
Develop audit programmes to validate the data received from employers.
Lead the batch data remediation processes for batch extracts, including Annual Pension Statement (APS).
Support generating remediation information for the Annual Valuation Extract (AVE) purposes to reduce remedial process time.
Perform annual update and verification of system tables.

Represent the data management group in special project work teams related to the design testing and implementation of new system applications as well as annual project deliverables. Examples of key tasks include:

Provide business analysis from a data management perspective on projects regarding member- and employer-data-related controls and completeness and accuracy of such data; projects cover areas such as data purification, production of accurate annual pension statements to members, extraction of actuarial data, and maintenance of pension records and benefits for members on long-term disability.
Analyze data management user requirements related to new application development.
Participate in system design walkthroughs and evaluations.
Develop user acceptance test plans, including test strategy, test criteria, and test data identification, resources, and time estimates; implement and control user acceptance test projects, identifying issues with IT as needed.
Control code table administration for the pension database and security requests for special project users.
Design and deliver training and support to users of the pension database and coordinate database communication updates.
Performs other duties as assigned.

What you bring

Post-secondary degree or diploma.
Advanced knowledge of pension plan administration and of related legislation/plan provisions, including the OPSEU Pension Plan text, the Pension Benefits Act, the Family Law Act, and federal statutes such as CPP, EI, and the Income Tax Act.
Applied knowledge of business and administrative processes and systems in the financial services sector.
Familiar with extracting, transforming, and loading (ETL) methods for large datasets, integrating source data to produce actionable insights.
Knowledge of electronic data processing and financial system controls and methods to establish operating procedures that ensure control and integrity of data management processes.
Knowledge of database systems operations and use, spreadsheet applications, and database inquiry languages and products to resolve complex data problems, redesign work processes/procedures, and provide technical assistance/guidance to junior staff.
Experience using MS Office Suite (Excel, PowerPoint, Power BI).
Experience with database systems operations.
Experience building dashboards using Microsoft Power BI or Tableau.
Familiar with SQL and writing scripts to extract data.
Experience with RPA or other automation development is highly preferred.
Strong research and analytical skills to identify and resolve complex membership data problems and improve operating/control procedures and efficiency and make related recommendations.
Strong organizational skills to balance workload and set priorities.
Excellent written and verbal communication skills.
Interpersonal and negotiation skills along with a strong client service orientation.
Positive attitude towards work and colleagues to support team goals and organization values of strong teamwork, cooperation and mutual respect.
High degree of accountability and personal leadership.
Exemplify OPTrust’s values: collaboration and teamwork, integrity, respect, flexibility, excellence, and continuous improvement.

Please submit your application via Workday by October 1st, 2026.

This posting is for an existing vacancy.

The range of expected compensation for this position is $104,550 - $128,763 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.

Apply About employer

More about this job

Responsibilities

The role is responsible for delivering technical expertise in data management, designing business processes for accurate reconciliation, and maintaining high data integrity for plan members. It also involves building reporting solutions using BI tools to provide actionable insights for organizational decision-making.

Requirements

Requires a post-secondary degree and advanced knowledge of pension plan administration and related legislation. Candidates must be proficient in SQL, ETL methods, and BI tools like Power BI or Tableau, with strong analytical and communication skills.

Skills

Business Intelligence
Data Management
ETL
SQL
Power BI
Tableau
RPA
Data Reconciliation
Business Analysis
User Acceptance Testing
Pension Administration
Financial System Controls
Data Purification
Statistical Reporting
Microsoft Office Suite
Data Modeling

Benefits

Defined benefit pension plan
Inclusion, diversity and equity strategy
Employee-led resource groups

Visa sponsorship

Not detected in the job text

Keywords

Power BI
Tableau
SQL
ETL
RPA
Pension Benefits Act
Family Law Act
CPP
EI
Income Tax Act
Data Integrity
Data Reconciliation
Business Intelligence
User Acceptance Testing
Financial Services
Pension Funds
Data Purification
Actuarial Data
Batch Data Remediation
Statistical Reports
Data Workflow
Work-inventory Management
Database Systems
Microsoft Office Suite
Data Management Standards
Internal Controls
Audit Programmes
Annual Pension Statement
Annual Valuation Extract
Code Table Administration

Report this job