Senior Enterprise Data Specialist

Senior Enterprise Data Specialist

Type: Permanent

Location: Toronto

Posting Date: January 6, 2025

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 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 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 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 Specialist’s primary responsibility is to support PATH leadership in developing systems and processes that warehouse and govern OPTrust’s 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 OPTrust’s systems and processes.
• Independently work with OPTrust’s 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 long-term strategic goals for data architecture vision
• Help create short-term tactical solutions to achieve long-term 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 OPTrust’s data systems and developing new features.

• Develops expertise in OPTrust’s 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

• Post-Secondary 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 non-technical 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 de-duplication 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.
• Hands-on 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.
• Hands-on 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 client-oriented 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.
• Excellent written and oral communication skills to communicate effectively with relevant internal and external stakeholders.
• Exemplify OPTrust’s values: collaboration and teamwork, integrity, respect, flexibility, excellence, and continuous improvement.

Please submit your application via Workday by January 20, 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 [email protected], 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.