Senior Enterprise Data Specialist

Senior Enterprise Data Specialist

Type: 15Month Contract

Location: Toronto (Hybrid)

Posting Date: March 10 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 fastpaced 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 purposedriven 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 worldclass defined benefit pension plan.

• A dedicated inclusion diversity and equity strategy with meaningful opportunities to participate including our employeeled resource groups.

About the role

This position is responsible for supporting the development and administration of processes that ensure OPTrusts 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 and 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 indepth knowledge of enterprise data processes and technology and is expected to seek solutions to complex problems independently before escalating issues.

What youll do

Works independently researches tasks thoroughly and attempts solutions before escalation:

• Maintain strong knowledge of the Enterprise processes he/she supports and the technology that supports them and should be able to recommend and execute solutions to many issues.

• Provides expertise and/or guidance to Data Operations staff to assist in resolving issues.

• Provides feedback to and contributes to development of requirements for data processes.

• Represents PATH when gathering requirements and other routine interactions with internal clients.

Data Engineering: The Senior Enterprise Data Specialists primary responsibility is to support PATH leadership in developing systems and processes that warehouse and govern OPTrusts Enterprise data. As part of this role they will:

• Work with management and internal stakeholders to identify shortcomings in existing ways OPTrust sources loads stores and delivers information. These shortcomings can be related to cost efficiency or inability to fulfill the needs of internal clients.

• Design and present solutions to data shortcomings including updating or creating database data models ETL processes and extractors.

• Assist management in evaluating new datasets and aligning them to OPTrusts systems and processes.

• Independently work with OPTrusts data systems to implement solutions in a timely manner.

• Perform testing of solutions and existing systems as directed.

• Document existing and new data models and processes and ensures documents are kept up to date.

• Help senior leadership in PATH develop and deliver longterm strategic goals for data architecture vision

• Help create shortterm tactical solutions to achieve longterm objectives and an overall data management roadmap.

• Contribute to the establishment of processes for governing the identification collection and use of corporate metadata; take steps to assure metadata accuracy and validity.

• Contribute to the establishment of methods and procedures for tracking data quality completeness redundancy and improvement.

Business Analysis: The Senior Enterprise Data Specialist works collaboratively with business partners across the organization to understand their process/data gaps creates specifications and delivers solutions. As part of this responsibility the Senior Enterprise Data Specialist:

• Maintains an understanding of Enterprise functions including HR Finance IT and compliance and the interactions between them.

• Develops technical expertise of the systems (internal and external) that primarily support PATH program and other enterprise functions.

• Collaborates with business partners on new initiatives to ensure effective data management practices are instilled into their processes.

• Assists business partners in finding solutions to sourcing storing and processing data ensures that solutions are aligned with existing Enterprise Data Group systems and processes.

• Builds relationships with business partners vendors and acts as a resource on data issues.

Database Administration: Assists Manager PATH and Team Leads in maintaining OPTrusts data systems and developing new features.

• Develops expertise in OPTrusts data model including: Party Organization Agreement security masters composites transactions reference data.

• Acts as a point of contact for engagements with external vendors on large projects.

• Creates design specs for projects and writes SQL queries data loaders data validators and data exporters that support data management processes.

• Acts as the first line of defense in resolving operational issues escalated by more junior staff.

What you bring

• PostSecondary Education in a quantitative engineering or computer science field OR a demonstrated capability in as a Data Engineer/Architect and programming.

• 8 overall industry experience

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

• Strong interpersonal and oral communication skills; ability to explain complex concepts to nontechnical people.

• Expert SQL skills and knowledge of database administration.

• 3 years of experience in working in an Agile environment and solid understanding of System Development Life Cycle (SDLC) concepts and methodologies

• Extensive experience in building and managing large scale data integration (via ETL) projects and building various models in Data warehousing for analytical teams

• Direct experience in creating source to targeting mappings and document.

• Direct experience in using data quality tools and a full understanding of data quality processes including data profiling handling data cleansing and deduplication with ETL tools.

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

• Direct experience supporting Reporting teams is preferred.

• Ability to program in one or more of: SSIS (preferred) Informatica Python Experience with statistical analysis and data transformations in these languages is mandatory.

• Handson experience in Extraction Cleansing and Modification of data from/to various Data Sources like Flat Files Sequential files XML and Databases like Oracle SQL Server etc.

• Handson experience with large scale data migration projects is a plus.

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

• An understanding of standard data models including security masters reference and market data agreements organization party.

• A clientoriented mindset as this role requires supporting and working with other teams across the organization.

• Ability to work on multiple projects with tight deadlines.

• Sound judgment and discretion for dealing with confidential and sensitive matters.

• Effective written and oral communication skills to communicate effectively with relevant internal and external stakeholders.

• Exemplify OPTrusts values: collaboration and teamwork integrity respect flexibility excellence and continuous improvement.

Please submit your application via Workday by March 24 2025.

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 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 were seeking ways to respond to the Truth and Reconciliation Commission of Canadas 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 employeeled 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.