Senior Enterprise Data Specialist

Senior Enterprise Data Specialist

Senior Enterprise Data Specialist

Type: Permanent

Location: Toronto

Posting Date: October 7, 2024

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 – from London, Toronto, and Sydney – makes a meaningful impact. Our environment is fast-paced, but we find time to have fun and give back to the community as well. Our strength resides in our team members with different backgrounds and perspectives creating an inclusive and fulfilling place to work for everyone.

What OPTrust Offers You







- Unique culture rooted in our core values – collaboration and teamwork, integrity, respect, flexibility, and excellence and continuous improvement – reflected across the team.
- Dedicated business strategy for inclusion, diversity and equity with multiple, meaningful opportunities to participate.
- Flexible, hybrid work model being implemented to balance the benefits of working from home and the collaborative teamwork experience in the office.
- Membership in our world-class defined benefit pension plan.
- A purpose-driven environment, including the opportunity to contribute to OPTrust’s climate change and responsible investing programs.
- Professional development opportunities and learning initiatives including access to LinkedIn Learning, in-house speaker series, tuition reimbursement program and professional association memberships.
- Comprehensive benefits package focused on your health and wellness, including dental, vision and extended health benefits.
- Opportunity to take parental and adoption leaves to spend time with family.






- Competitive vacation package and time away from work such as work-life balance days.

If you strive for excellence and continuous improvement, value a collaborative and flexible team culture, and approach everything with integrity and respect, then we invite you to apply to join our team!

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 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 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 documentation.
- 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 October 21, 2024.

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. We know a diversity of backgrounds, cultures and perspectives are critical to creating long-term value. OPTrust is an organization engaged in building on our unique and diverse strengths. If you require an accommodation at any time during the recruitment process, or have preferred pronouns, please send a message to *******@optrust.com, or discuss your needs with the Recruitment Consultant during the telephone screen. We will do our best to work with you and provide appropriate accommodation.

We thank all interested applicants, however only those under consideration will be contacted.

#J-18808-Ljbffr

▶️ Senior Enterprise Data Specialist
🖊️ OPTrust
📍 Toronto