Data Analyst

About The Company

OPTrust is a prominent pension fund organization dedicated to paying pensions today and preserving pensions for tomorrow. With a mission rooted in financial security and long-term stability, OPTrust manages over $27 billion in assets, serving more than 118,000 members of the OPSEU Pension Plan. The organization is committed to delivering exceptional service to its members while maintaining a strong investment strategy to secure their future. OPTrust’s team operates across Toronto, London, and Sydney, fostering a diverse and inclusive culture that values collaboration, integrity, respect, and continuous improvement. The organization emphasizes innovation, community involvement, and a purpose-driven environment where every team member contributes meaningfully to its mission.

About The Role

The Data Analyst within the Member Experience and Pension Operations department plays a vital role in ensuring the accuracy and integrity of member data in the pension administration database. This contract position, lasting 18 months, requires a detail-oriented professional capable of managing complex data processes, reconciling information received from various employers, and supporting special projects related to pension administration. The successful candidate will serve as a key point of contact for employer communications, providing guidance on data interface requirements and ensuring data quality standards are met. Additionally, they will participate in process improvement initiatives, contribute to system testing, and assist in developing efficient data management procedures. The role demands a proactive approach, excellent communication skills, and the ability to handle large volumes of data with precision, all while delivering exceptional service to internal and external stakeholders.

Qualifications

• Post-secondary education or equivalent experience
• PPAC/CEBS certification (asset)
• Knowledge of OPSEU Pension Plan text provisions and pension administration processes
• Proficiency in MS Office applications (Word, Excel)
• Working knowledge of SQL and MS Power BI (asset)
• Strong interpersonal and customer service skills
• Analytical and problem-solving abilities
• Attention to detail and mathematical skills
• Organizational skills to manage multiple tasks efficiently
• Ability to communicate clearly both verbally and in writing
• Experience with data reconciliation, investigation, and correction
• Familiarity with business software applications and data management tools
  
  

Responsibilities

• Manage the entire cycle of interface processing to ensure accurate member data received from employers is properly processed
• Support internal controls by reconciling reports from the pension database to maintain data integrity
• Reconcile and purify received data through established data control procedures
• Investigate data discrepancies, resolve issues, and support system user needs
• Create testing criteria and conduct user acceptance testing for new systems or updates
• Assist with special projects such as Annual Pension Statement runs, Actuarial Extracts, and Long-Term Incentive Plan (LTIP) analyses
• Maintain spreadsheets and control files related to data management and project support
• Identify trends in data problems and recommend process improvements to enhance data quality
• Develop and maintain strong relationships with employer representatives, providing guidance on data interface and correction procedures
• Prepare written communication for data requests, problem descriptions, and correction instructions
• Participate in cross-functional teams to implement new systems, processes, and procedures
• Support change management initiatives and contribute to continuous process improvements
• Adhere to OPTrust policies, procedures, and values, fostering an inclusive and respectful work environment
  
  

Benefits

• Flexible hybrid work model promoting work-life balance
• Benefits package available after six months of consecutive employment
• Optional membership in a defined benefit pension plan
• Opportunity to work within a purpose-driven organization committed to diversity, inclusion, and community engagement
• Professional development and growth opportunities through participation in various projects and initiatives
• Collaborative and supportive work environment that values innovation and continuous improvement
  
  

Equal Opportunity

OPTrust is an equal opportunity employer committed to fostering an inclusive environment where diversity is celebrated. We encourage applications from all qualified candidates regardless of race, gender, sexual orientation, age, disability, or background. We are dedicated to providing accommodations throughout the recruitment process and are committed to building a workforce that reflects the diverse communities we serve. If you require accommodation at any stage of the hiring process, please contact us at careers@optrust.com or discuss your needs with the Talent Acquisition team. We thank all applicants for their interest; however, only those selected for consideration will be contacted.