Top Benefits
About the role
Description
ABOUT US
CI Investment Services is a leading Canadian Broker Dealer that provides a wide range of innovative brokerage and trading services to a diverse client base that includes portfolio managers, introducing brokers, and institutional investors.
Job Overview
We distinguish ourselves in the Canadian clearing broker industry by owning our entire technology stack in-house. Our Toronto-based team is a close-knit, collaborative group with a clear vision and goal. We are seeking a skilled and detail-oriented MSSQL Senior Data Engineer to join our team. The ideal candidate will be responsible for managing and optimizing our Microsoft SQL Server databases and leveraging SQL Server Integration Services (SSIS) for efficient data integration and transformation. This role involves collaborating with DBAs and enforcing best practices for database management.
Key Responsibilities
-
Data Purging: Remove old or irrelevant data to maintain database efficiency.
-
Index Optimization: Create or modify indexes to improve query performance.
-
Stored Procedure Optimization: Optimize stored procedures to enhance performance and efficiency.
-
Code Reviews: Conduct thorough reviews of stored procedures to ensure quality and performance.
-
Standards Implementation: Implement standards, deployments, and changes to the data model.
-
Consultation: Act as a consultant for changes to the data model, providing expert advice and guidance.
-
Normalization: Structure the database to reduce redundancy and improve data integrity.
-
Archiving: Move infrequently accessed data to separate storage to optimize database performance.
-
SSIS Integration: Utilize SSIS for data integration, transformation, and workflow automation.
What You Will Bring
-
Educational Background :
-
Bachelor’s degree in Computer Science, Computer Engineering, or a related field.
-
Azure Data Engineer Certification, SQL Server Database Administrator Certification or similar.
-
Communication Skills :
-
Ability to work in a highly collaborative team environment
-
Strong written and verbal command of the English language
-
Can clearly communicate and mentor our data team
-
Active listener that will fully concentrate, understand, and respond to team members perspectives and requirements.
Technical Skills :
-
Advanced Proficiency in MS SQL required.
-
Familiar with GIT, Source Control features (branching/merging), and CI/CD pipelines, Atlassian Confluence, Jira, TFS.
-
Mastery of Database design and normalization
-
Experience with ETL/ELT Tools and workflows an asset (Snowflake, PySpark, AWS Glue, AWS Lambda)
Preferred Experience :
-
Minimum of 10 years of relevant work experience in a similar role. Ideally with double-entry financial book of record / accounting ledger systems.
-
Interest in the financial space and brokerage industry specifically.
Why Join Us?
-
Innovative Environment : Work with legacy and modern technology in a fast-paced, dynamic industry.
-
Professional Growth : Opportunities for continuous learning and career advancement.
-
Collaborative Culture : Be part of a supportive team that values collaboration and innovation.
-
Impactful Work : Contribute to a critical, high visibility area of our business.
About CI Financial
CI Financial is an independent company offering global asset management and wealth management advisory services. We are driven by a commitment to provide individuals and institutions with the highest-quality investments and advice—and offer a comprehensive and innovative selection of strategies and services.
Our employees are at the heart of everything we do. They must be comfortable in a fast-paced environment in an industry that is always changing. A healthy dose of ambition, a willingness to go the extra mile and a strong sense of camaraderie are what we look for in our team members.
You can find job postings for all CI Financial companies on this page.
And if you’d like to learn more about our lines of business, you can do so on the following pages: CI Global Asset Management, CI Assante Wealth Management, CI Investment Services, and CI Direct Investing.
Top Benefits
About the role
Description
ABOUT US
CI Investment Services is a leading Canadian Broker Dealer that provides a wide range of innovative brokerage and trading services to a diverse client base that includes portfolio managers, introducing brokers, and institutional investors.
Job Overview
We distinguish ourselves in the Canadian clearing broker industry by owning our entire technology stack in-house. Our Toronto-based team is a close-knit, collaborative group with a clear vision and goal. We are seeking a skilled and detail-oriented MSSQL Senior Data Engineer to join our team. The ideal candidate will be responsible for managing and optimizing our Microsoft SQL Server databases and leveraging SQL Server Integration Services (SSIS) for efficient data integration and transformation. This role involves collaborating with DBAs and enforcing best practices for database management.
Key Responsibilities
-
Data Purging: Remove old or irrelevant data to maintain database efficiency.
-
Index Optimization: Create or modify indexes to improve query performance.
-
Stored Procedure Optimization: Optimize stored procedures to enhance performance and efficiency.
-
Code Reviews: Conduct thorough reviews of stored procedures to ensure quality and performance.
-
Standards Implementation: Implement standards, deployments, and changes to the data model.
-
Consultation: Act as a consultant for changes to the data model, providing expert advice and guidance.
-
Normalization: Structure the database to reduce redundancy and improve data integrity.
-
Archiving: Move infrequently accessed data to separate storage to optimize database performance.
-
SSIS Integration: Utilize SSIS for data integration, transformation, and workflow automation.
What You Will Bring
-
Educational Background :
-
Bachelor’s degree in Computer Science, Computer Engineering, or a related field.
-
Azure Data Engineer Certification, SQL Server Database Administrator Certification or similar.
-
Communication Skills :
-
Ability to work in a highly collaborative team environment
-
Strong written and verbal command of the English language
-
Can clearly communicate and mentor our data team
-
Active listener that will fully concentrate, understand, and respond to team members perspectives and requirements.
Technical Skills :
-
Advanced Proficiency in MS SQL required.
-
Familiar with GIT, Source Control features (branching/merging), and CI/CD pipelines, Atlassian Confluence, Jira, TFS.
-
Mastery of Database design and normalization
-
Experience with ETL/ELT Tools and workflows an asset (Snowflake, PySpark, AWS Glue, AWS Lambda)
Preferred Experience :
-
Minimum of 10 years of relevant work experience in a similar role. Ideally with double-entry financial book of record / accounting ledger systems.
-
Interest in the financial space and brokerage industry specifically.
Why Join Us?
-
Innovative Environment : Work with legacy and modern technology in a fast-paced, dynamic industry.
-
Professional Growth : Opportunities for continuous learning and career advancement.
-
Collaborative Culture : Be part of a supportive team that values collaboration and innovation.
-
Impactful Work : Contribute to a critical, high visibility area of our business.
About CI Financial
CI Financial is an independent company offering global asset management and wealth management advisory services. We are driven by a commitment to provide individuals and institutions with the highest-quality investments and advice—and offer a comprehensive and innovative selection of strategies and services.
Our employees are at the heart of everything we do. They must be comfortable in a fast-paced environment in an industry that is always changing. A healthy dose of ambition, a willingness to go the extra mile and a strong sense of camaraderie are what we look for in our team members.
You can find job postings for all CI Financial companies on this page.
And if you’d like to learn more about our lines of business, you can do so on the following pages: CI Global Asset Management, CI Assante Wealth Management, CI Investment Services, and CI Direct Investing.