Senior Enterprise Data Specialist

OPTrust; Toronto; Hybrid; CAD 90,000 - 130,000; Full time

Job summary

OPTrust is seeking a Senior Enterprise Data Specialist to enhance data quality and processes. The role involves collaborating with various teams, managing data systems, and providing solutions to complex data challenges. Candidates should have extensive experience in data integration, SQL, and a strong understanding of financial services, with a commitment to OPTrust's values of collaboration and integrity.

Benefits

Comprehensive benefits including dental and vision

Flexible, hybrid work model

Professional development opportunities

Competitive vacation package

Qualifications

• 8+ years of industry experience required.
• At least 5 years’ experience in Financial Services and Pension domain preferred.
• Strong interpersonal and communication skills; ability to explain complex concepts.

Responsibilities

• Support development and administration of data processes.
• Provide expertise and guidance to Data Operations staff.
• Collaborate with business partners to understand data gaps.

Skills

SQL

Data Integration

Data Quality

Agile Methodologies

Communication

Education

Post-secondary education in a quantitative, engineering, or computer science field

Tools

SSIS

Informatica

Python

Power BI

Job description

Senior Enterprise Data Specialist

Type: Permanent

Location: Toronto

Posting Date: May 20th, 2025

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.

• Comprehensive benefits focused on your health and wellness, including dental, vision, and extended health benefits, as well as membership in our world-class defined benefit pension plan.

• A flexible, hybrid work model.

• A dedicated inclusion, diversity, and equity strategy with meaningful opportunities to participate, including our employee-led resource groups.

• Extensive professional development opportunities and learning initiatives, including access to LinkedIn Learning, guest speakers, tuition reimbursement, professional association memberships, leadership development programs, a mentorship program, monthly professional development time, and more.

• A competitive vacation package with additional work-life balance days.

About the Role

This position is responsible for supporting the development and administration of processes that ensure OPTrust’s enterprise data is of high quality and for working with enterprise units to provide them with data. The Senior Enterprise Data Specialist works with and other teams across the organization to develop an understanding of their processes and works with members of the PATH Program in mapping requirements to data processes. The position develops data processes through working with databases, ETL pipelines, data automation, and data delivery. The Senior Enterprise Data Specialist is expected to maintain in-depth knowledge of enterprise data processes and technology and is expected to seek solutions to complex problems independently before escalating issues.

What You’ll Do

Works independently, researches tasks thoroughly, and attempts solutions before escalation:

• Maintain strong knowledge of the enterprise processes supported and the technology that supports them; recommend and execute solutions to issues.

• Provide expertise and guidance to Data Operations staff to assist in resolving issues.

• Contribute to the development of requirements for data processes.

• Represent PATH when gathering requirements and during routine interactions with internal clients.

Data Engineering: The primary responsibility is to support PATH leadership in developing systems and processes that warehouse and govern OPTrust’s enterprise data. This includes:

• Working with management and stakeholders to identify shortcomings in current data sourcing, loading, storage, and delivery methods, related to cost, efficiency, or internal client needs.

• Designing and presenting solutions, including updating or creating database data models, ETL processes, and extractors.

• Assisting management in evaluating new datasets and aligning them with OPTrust’s systems and processes.

• Implementing solutions independently in a timely manner.

• Testing solutions and existing systems as directed.

• Documenting data models and processes, ensuring documentation is current.

• Helping develop and deliver long-term strategic goals for data architecture.

• Creating short-term tactical solutions to support long-term data management roadmaps.

• Contributing to metadata management and data quality processes.

Business Analysis: Collaborate with business partners to understand data gaps, create specifications, and deliver solutions, including:

• Understanding enterprise functions like HR, Finance, IT, and compliance.

• Developing expertise in supporting systems.

• Ensuring data management practices are integrated into new initiatives.

• Building relationships with stakeholders, vendors, and providing resource support on data issues.

Database Administration: Support data systems maintenance and feature development, including:

• Gaining expertise in OPTrust’s data model.

• Acting as a contact for vendor engagements.

• Creating design specifications and writing SQL queries, data loaders, validators, and exporters.

• Resoling operational issues escalated by junior staff.

What You Bring

• Post-secondary education in a quantitative, engineering, or computer science field, or demonstrated capability as a Data Engineer/Architect with programming skills.

• 8+ years of industry experience.

• At least 5 years’ experience in Financial Services and Pension domain (preferred).

• Strong interpersonal and communication skills; ability to explain complex concepts to non-technical audiences.

• Expert SQL skills and database administration knowledge.

• 3+ years’ experience working in an Agile environment, with a solid understanding of SDLC methodologies.

• Extensive experience with large-scale data integration projects and data warehousing models.

• Experience in creating source-to-target mappings and documentation.

• Experience with data quality tools and processes, including profiling, cleansing, and de-duplication using ETL tools.

• Experience with version control systems like GitHub or GitLab is a plus.

• Supporting reporting teams experience is preferred.

• Proficiency in programming languages such as SSIS (preferred), Informatica, Python, with experience in statistical analysis and data transformations.

• Hands-on experience with data extraction, cleansing, and modification from sources like files, XML, and databases (Oracle, SQL Server).

• Experience with large-scale data migration projects is a plus.

• Experience developing APIs and working with BI tools (Power BI preferred) is a plus.

• Understanding of standard data models including security masters, reference, and market data.

• A client-oriented mindset and ability to manage multiple projects with tight deadlines.

• Sound judgment and discretion for handling confidential matters.

• Excellent communication skills for effective stakeholder engagement.

• Alignment with OPTrust’s values: collaboration, integrity, respect, flexibility, excellence, and continuous improvement.

Please submit your application via Workday by June 3rd, 2025.

OPTrust is committed to diversity, inclusion, and equity, and encourages applications from all backgrounds. For accommodations, contact [e-mail].

We are engaged in reconciliation efforts with Indigenous communities and encourage participation in our initiatives.

Thank you for your interest; only shortlisted candidates will be contacted.