We are looking for a Senior Data Engineer who will be responsible for designing and developing our database system, data models and schemas, as well as building data pipelines assembling 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 innovation in the industry. We do this by focusing on our corporate values of Collaboration, Adaptability, Integrity, and Respect.
In this role, you will…
- Work in an agile team while collaborating with different teams across product lines in developing specifications and delivering high quality solutions.
- Develop and optimize SQL and PL/SQL scripts, procedures, and functions.
- Support database design and implement solutions to improve data structure.
- Install, configure, and maintain Oracle databases and related components.
- Build and manage data pipelines for reporting and ETL workflows.
- 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:
- Strong understanding of relational database design and logical/physical data model.
- Practical use of SQL and PL/SQL for database operation, scripting and automation.
- Strong working knowledge of relational database platforms, especially Oracle 19c/23ai and ExaCC (including Good understanding of Cloud technologies, Azure and Oracle OCI experience is a big plus).
- Comfortable working in Unix/Linux environment, including working with scripting language.
- Proven ability to build and optimize data pipelines and workflows using technologies such as Talend, Azure Synapse, or Kafka.
We recognize that there are different paths to gaining skills, so if you have diverse experience which doesn’t match the criteria exactly but you think you would be great in this role, we invite you to apply!
Why Work Here
Our Benefits and Perks
We’ve consistently been recognized as a GTA Top Employer and a Canada Top Small & Medium Employer. Below are some of the reasons why:
- Employer-paid premiums for group health plan, including a Healthcare Spending Account
- Up to $2,000 per year for mental health practitioners and corporate-wide mental health days per year
- Wellness benefit for gym memberships, workout equipment, meditation and wellness apps, and more!
- RRSP matching program
- $500 one-time stipend for home office equipment and monthly home-internet subsidy
- Out of Province policy offers up to 20 days of out-of-province work per calendar year for employees with 2+ years of service
- Access to tools like LinkedIn Learning and Pluralsight and additional training opportunities
- EI top-up programs for maternity and parental leave, family medical, and family caregiver leave
Our Hybrid Work Policy
We recognize the importance of flexibility and work-life balance, and as such our hybrid model is purpose-led – we come in for a reason, not to fill a quota.