Data Engineer, Data Integration & Performance Platform

OMERS; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

OMERS, a leading pension plan, is seeking a Data Engineer to enhance its Data Integration & Performance Platform. This role requires expertise in database development and investment applications, supporting investment professionals to optimize workflows and deliver on strategic goals. You'll work in a dynamic environment that prioritizes employee growth and wellness.

Benefits

Flexible work schedule

Employee resource groups

Wellness programs

Qualifications

• 7 years of experience in technology roles.
• 5 years of work experience in the Finance industry preferred.
• Experience with investment applications is an asset.

Responsibilities

• Collaborate within cross-functional teams to deliver projects.
• Design, develop, unit test, and implement technical solutions.
• Troubleshoot and resolve technical issues related to data integration.

Skills

Analytical skills

Problem-solving

Interpersonal skills

Communication

Education

Bachelor’s degree in Information Systems

Tools

SQL

ETL tools

.Net

Informatica

SSRS

ASP.Net

Job description

Data Engineer, Data Integration & Performance Platform

Join to apply for the Data Engineer, Data Integration & Performance Platform role at OMERS

Data Engineer, Data Integration & Performance Platform

Join to apply for the Data Engineer, Data Integration & Performance Platform role at OMERS

Get AI-powered advice on this job and more exclusive features.

Choose a workplace that empowers your impact.

Join a global workplace where employees thrive. One that embraces diversity of thought, expertise and experience. A place where you can personalize your employee journey to be — and deliver — your best.

We are a purpose-driven, dynamic and sustainable pension plan. An industry leading global investor with teams in Toronto to London, New York, Singapore, Sydney and other major cities across North America and Europe. We embody the values of our 600,000+ members, placing their best interests at the heart of everything we do.

Join us to accelerate your growth & development, prioritize wellness, build connections, and support the communities where we live and work.

Don’t just work anywhere — come build tomorrow together with us.

Know someone at OMERS or Oxford Properties? Great! If you're referred, have them submit your name through Workday first. Then, watch for a unique link in your email to apply.

This is an opportunity to join a fast-paced team, working to support our partners within OMERS Capital Markets, Total Portfolio Management, Treasury, and Corporate Finance, while performing functions to deliver on our pension promise. The team supports investment professionals on a day-to-day basis, as well as ongoing projects to deliver new capabilities, refine workflows, and align to the strategic platform roadmap. The incumbent will be responsible for providing solution design, development & maintenance support for investment applications and integrations. The incumbent will function in a team-oriented context with opportunities for interacting directly with platform teams, and investment professionals.

The official title within the team is Senior Technical Analyst, Data Integration & Performance Platform

We believe that time together in the office is important for OMERS and Oxford, the strength of our employees, and the work we do for our pension members. Our flexible hybrid work guideline requires teams to come to the office a minimum of 4 days per week.

Scope of Position

Reporting to the Senior Manager, Technical Services, Capital Markets Finance, the Senior Technical Analyst responsibilities include developing database stored procedures and functions, building SSRS or Crystal reports, maintaining ASP.Net web applications, integrating data between investment platforms, troubleshooting production issues, and configuring scheduled jobs. The role requires a solid understanding of investment business processes and experience maintaining & supporting investment applications combined with excellent analytical skills, including solution design and documentation, root cause analysis of production issues, testing of application or integration changes, and implementation change management. It requires strong interpersonal, organizational and project management skills combined with the ability to readily adapt to rapidly changing investment and technology environments.

Responsibilities

• Collaborate within cross-functional teams to deliver projects and enhancements
• Design, develop, unit test, and implement technical solutions that meet the needs of our internal partners
• Provide support to colleagues in the development of new reports, and the resolution of reporting and other data-related issues
• Proactively identify opportunities to enhance technical processes to deliver efficiencies, and/or reduce operational risk
• Work closely with IT Operations and platform vendors to ensure systems are optimized for performance and efficiency
• Develop and maintain technical documentation for all solutions
• Prepare implementation plans, define workflow solutions, and establish process controls and standards within investment platforms
• Troubleshoot and resolve technical issues related to data integration and solutions
• Expand knowledge of investment products (equity, credit, derivatives, alternatives) across lifecycle events
• Stay current on the latest trends and technologies in data integration and solution development
  
  

Qualifications

• Bachelor’s degree in Information Systems, Computer Science, or related field
• 7 years of experience in technology roles
• 5 years of work experience in the Finance industry; buy side investment management preferred
• Demonstrated project skills and experience in all phases of solution development life cycle
• Experience working with investment applications is an asset: trading systems (CRD, Bloomberg), accounting systems (Calypso, SimCorp or Eagle PACE), data warehouse (Eagle PACE), and reconciliation systems
• 5 years of experience developing database tables, functions, triggers, and stored procedures
• Experience with various database technologies (SQL, Oracle, others)
• Experience with ETL tools such as Informatica, Talend, or SSIS
• 5 years of experience with programming language using Java, .Net with VB or C#
• 5 years of experience with scripting language using VBScript, PowerShell. Python and Perl will be an asset
• Experience with SSRS or Crystal report builder
• Experience with web development using Asp.Net, HTML, JavaScript
• Experience working with scheduler applications: TWS or others
• Experience working with cloud technology; Microsoft Azure is an asset
• Exposure with Microsoft Power Platform, including Power BI and Power Apps, is an asset
• Experience with Microsoft Azure DevOps and Repos
• Experience with business process mapping, requirements gathering, analysis, design and documentation
• Ability to solve complex problems, consolidate and organize large amounts of data and information
• Ability to work on multiple assignments with competing priorities independently as well as in a team environment
• Analytical and detail-oriented with a high degree of accuracy
• Excellent communication and interpersonal skills with the ability to communicate complex technical subjects to non-technical audiences
• Highly motivated to work in a fast-paced environment, and works well under pressure
• A sense of urgency for task completion and for members’ experience are essential
  
  

As one of Canada’s largest defined benefit pension plans, our people-first culture is at its best when our workforce reflects the communities where we live and work — and the members we proudly serve.

From hire to retire, we are an equal opportunity employer committed to an inclusive, barrier-free recruitment and selection process that extends all the way through your employee experience. This sense of belonging and connection is cultivated up, down and across our global organization thanks to our vast network of Employee Resource Groups with executive leader sponsorship, our Purpose@Work committee and employee recognition programs.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

Referrals increase your chances of interviewing at OMERS by 2x

Sign in to set job alerts for “Data Engineer” roles.

Richmond Hill, Ontario, Canada 18 hours ago

Software Engineer, Backend (All Levels / All Teams)

Toronto, Ontario, Canada CA$120,000.00-CA$190,000.00 1 month ago

Toronto, Ontario, Canada CA$104,000.00-CA$114,000.00 15 hours ago

Software Engineer I, Entry Level (Fall 2024-Spring 2025) - Toronto

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.