Data Analyst

Role overview

Processing and data management

• Process employer interface data through its full cycle to ensure member data is properly handled.
• Reconcile pension database reports and support internal controls that maintain database integrity.
• Manage expected data and reconcile and correct received data using data control procedures.
• Investigate data problems, solve issues, and provide administration-system user support.
• Create testing criteria and conduct user acceptance testing.
• Support the Annual Pension Statement run, Actuarial Extract, and LTIP historical membership analysis and data correction.
• Maintain spreadsheets and provide file control and administrative support for special projects.
• Review data control procedures, identify trends in data problems, and share improvement suggestions with senior staff and managers.

Employer services and communication

• Maintain employer contacts regarding interface processing, data reconciliation, and general communications.
• Instruct employers on expected interface transactions and data correction requirements.
• Prepare information requests, descriptions of data problems, and data correction instructions.
• Communicate data and system issues clearly with employers, clients, and OPTrust staff.

Change management and projects

• Participate in projects to improve employer connections and services to members and pensioners.
• Contribute to cross-functional implementation of new business systems, processes, and procedures.
• Recommend and implement efficiency changes where process gaps are identified.
• Support departmental benchmarks and goals and participate in procedure review and development.
• Follow organizational policies, procedures, and guidelines and contribute to an inclusive, collaborative culture.

Qualifications

• Post-secondary education or equivalent.
• Knowledge of OPSEU Pension Plan provisions and pension administration sufficient to process simple transactions and understand pension data relationships.
• Proficiency in MS Office and business software applications.
• PPAC/CEBS certification is an asset.
• SQL and working knowledge of MS Power BI are assets.
• Requires analytical, mathematical, organizational, interpersonal, and communication skills, attention to detail, and customer-service orientation.

Compensation

• Expected compensation is $73,792 to $85,720 per year.

Benefits and culture

• Benefits package available after six months of consecutive employment; membership in the defined benefit pension plan is optional.
• The employer describes a flexible hybrid model, an inclusive culture, and opportunities to participate in employee-led resource groups.