Senior Data Engineer (Database Developer)

Fundserv Inc.; Toronto; Hybrid; CAD 90,000 - 130,000; Full time

Job summary

A leading company in the Canadian investment industry is seeking a Senior Data Engineer to design and develop database systems and data models. The role involves building data pipelines, optimizing database performance, and collaborating with agile teams. The ideal candidate will have strong SQL and PL/SQL skills, experience with Oracle databases, and a good understanding of cloud technologies. This position offers a hybrid work model and numerous employee benefits, including wellness programs and RRSP matching.

Benefits

Employer-paid premiums for group health plans

Up to $2,000 per year for mental health practitioners

Wellness benefits for gym memberships

RRSP matching program

$500 one-time stipend for home office equipment

Out-of-province work policy

Access to learning platforms

EI top-up programs for maternity and parental leave

Qualifications

• Strong understanding of relational database design and logical/physical data models.
• Practical experience with SQL and PL/SQL for database operations.
• Comfortable working in Unix/Linux environments.

Responsibilities

• Develop and optimize SQL and PL/SQL scripts.
• Build and manage data pipelines for reporting and ETL workflows.
• Monitor database performance and troubleshoot issues.

Skills

Relational database design

SQL

PL/SQL

Data pipeline optimization

Unix/Linux scripting

Cloud technologies

Tools

Oracle 19c/23c

Talend

Azure Synapse

Kafka

Job description

We are looking for a Senior Data Engineer (Database Developer) who will be responsible for designing and developing our database systems, data models, and schemas, as well as building data pipelines to assemble large, complex data sets for analytical purposes.

Fundserv has been the indispensable hub for the Canadian investment industry for over 30 years, connecting Manufacturers, Distributors, Intermediaries, and Service Providers to build solutions that simplify business interactions and promote industry innovation. We focus on our corporate values: Collaboration, Adaptability, Integrity, and Respect.

In this role, you will…

1. Work in an agile team while collaborating with different teams across product lines to develop specifications and deliver high-quality solutions.
2. Develop and optimize SQL and PL/SQL scripts, procedures, and functions.
3. Support database design and implement solutions to improve data structures.
4. Install, configure, and maintain Oracle databases and related components.
5. Build and manage data pipelines for reporting and ETL workflows.
6. Monitor database performance and troubleshoot issues in Oracle environments.

Why you are the person we’re looking for…

You’ve demonstrated the ability to do the following, gained through education and/or experience:

1. Strong understanding of relational database design and logical/physical data models.
2. Practical experience with SQL and PL/SQL for database operations, scripting, and automation.
3. Strong working knowledge of relational database platforms, especially Oracle 19c/23c and ExaCC, with a good understanding of Cloud technologies such as Azure and Oracle OCI (experience is a big plus).
4. Comfortable working in Unix/Linux environments, including scripting languages.
5. Proven ability to build and optimize data pipelines and workflows using technologies such as Talend, Azure Synapse, or Kafka.

We recognize diverse experience paths; if you believe you would excel in this role despite not matching all criteria exactly, we encourage you to apply!

Why Work Here

Our Benefits and Perks

• Employer-paid premiums for group health plans, including a Healthcare Spending Account
• Up to $2,000 per year for mental health practitioners and dedicated mental health days
• Wellness benefits for gym memberships, workout equipment, meditation, and wellness apps
• RRSP matching program
• $500 one-time stipend for home office equipment and monthly home-internet subsidy
• Out-of-province work policy allowing up to 20 days per year for employees with 2+ years of service
• Access to learning platforms like LinkedIn Learning and Pluralsight, plus additional training opportunities
• EI top-up programs for maternity, parental leave, and family caregiving

Our Hybrid Work Policy

We value flexibility and work-life balance through our purpose-led hybrid model — coming in for specific reasons, not to fill a quota.