Senior Data Engineer

Fundserv Inc.; Toronto; On-site; CAD 170,000 - 184,000; Full time

Job summary

Fundserv Inc. in Toronto, Ontario, is seeking a Senior Data Engineer to design and develop database systems, data models, schemas, and data pipelines for analytics.

You will work in an Agile environment, optimize SQL/PLSQL, support schema changes, and maintain Oracle databases, ensuring data integrity, security, and deployment readiness.

Qualifications

• Strong relational DB design and data modeling experience.
• SQL/PLSQL scripting and automation expertise.
• Oracle 19c/23ai with Exadata familiarity and OCI/Azure knowledge.
• Experience with Oracle Forms and Oracle APEX.
• Unix/Linux environments and shell scripting capability.
• Building data pipelines with Talend, Azure Synapse or Microsoft Fabric.
• Automated database deployments using Liquibase.

Responsibilities

• Design and develop database systems, data models and schemas.
• Build data pipelines for large analytical data sets.
• Work in Agile teams to define database requirements and specs.
• Develop and optimize SQL/PLSQL scripts and procedures.
• Support design, schema changes and data model improvements.
• Install, configure and maintain Oracle databases and components.
• Monitor health, troubleshoot performance, and tune databases.
• Manage security, backups, and deployment support.
• Create and maintain technical documentation.

Skills

Relational DB design

SQL/PLSQL scripting

Oracle 19c/23ai

Exadata Cloud (ExaCC)

Oracle Forms/APEX

Unix/Linux scripting

ETL pipelines

Talend

Azure Synapse

Microsoft Fabric

Liquibase

Tools

Liquibase deployment tool

Job description

We are looking for a Senior Data Engineer who will be responsible for designing and developing database systems, data models and schemas, as well as building data pipelines assembling large, complex data sets for analytical purposes.

In this role, you will…

• Work in an Agile team while collaborating with other teams across product lines to define database requirements and technical specifications.
• Develop and optimize SQL and PL/SQL scripts, procedures, packages, and functions.
• Support database design, schema changes, and data model improvements to enhance performance, scalability, and data integrity.
• Install, configure, and maintain Oracle databases and related components.
• Build and support ETL processes and data pipelines for reporting and downstream integrations.
• Monitor database health, troubleshoot Oracle performance issues, and implement tuning improvements.
• Manage database security, access controls, backup/recovery processes, and deployment support.
• Create and maintain technical documentation and track database development activities.

Why you are the person we’re looking for…

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

• Strong understanding of relational database design and logical/physical data modeling.
• Practical experience using SQL and PL/SQL for database operations, scripting, and automation.
• Strong working knowledge of relational database platforms, especially Oracle 19c/23ai and Exadata Cloud Customer (ExaCC) familiarity with cloud technologies, including Oracle OCI and Azure, is a strong plus.
• Experience with Oracle Forms and Oracle APEX for maintaining, supporting, or developing database-driven applications.
• Comfortable working in Unix/Linux environments, including shell scripting and automation.
• Proven ability to build and optimize data pipelines and workflows using technologies such as Talend, Azure Synapse, or Microsoft Fabric.
• Experience in automated database deployment experience using Liquibase

The following is not required but will be a bonus:

• AI-assisted database development is a nice-to-have capability that may help streamline development and maintenance activities.

Target total compensation including bonus: $138,000 – $149,500 per year

(Starting base salary range: $120,000 - $130,000/year)

AI Statement

• Fundserv leverages the use of artificial intelligence (AI) to support our recruitment process through assistance with initial resume screening. However, AI is not used to make final assessment, selection or hiring decisions, and the hiring team maintains oversight over the end-to-end recruitment process.

This job posting is for an existing vacancy.