Senior Database Architect / Developer (MSSQL)

CI Financial Corp.; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading financial services firm in Toronto is seeking a skilled MSSQL Senior Data Engineer to manage SQL Server databases and utilize SSIS for data integration. The ideal candidate will have at least 10 years of experience, strong collaboration and communication skills, and a background in financial brokerage systems. This role offers a supportive environment with opportunities for professional growth.

Benefits

Training Reimbursement

Fitness membership discounts

Enhanced group benefits

Employee Savings Plan

Qualifications

• Minimum of 10 years experience in a similar role.
• Familiarity with financial brokerage systems.
• Ability to mentor team members.

Responsibilities

• Manage and optimize Microsoft SQL Server databases.
• Utilize SSIS for data integration and transformation.
• Conduct thorough code reviews for quality assurance.

Skills

MS SQL proficiency

Collaboration

Communication

Data integrity

Education

Bachelor's in Computer Science or related field

Azure Data Engineer Certification

Tools

Git

ETL Tools (e.g., Snowflake)

Jira

Job description

ABOUT US

At CI, we see a great place to work as one that is a safe place for everyone to have a voice, where people are empowered to take ownership over meaningful work, where there is an opportunity to grow through stretching themselves, where they can work on innovative products and projects, and where employees are supported and engaged in doing so.

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.

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.

WHAT YOU WILL DO

• 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.

CI Financial is an independent company offering global wealth management and asset management advisory services through diverse financial services firms. Since 1965, we have consistently anticipated and responded to the changing needs of investors. We are driven by a commitment to provide individuals and institutions with the highest-quality investments and advice.

Our commitment to the highest levels of performance means that whatever their position, CI employees must be comfortable in a fast-paced environment that will stretch them to tap into their highest potential. Employees with a healthy dose of ambition, a desire to commit to a curious mindset for continuous learning, and a willingness to go the extra mile thrive at CI.

WHAT WE OFFER

• Modern HQ location within walking distance from Union Station
• Training Reimbursement
• Paid Professional Designations
• Employee Savings Plan (ESP)
• Corporate Discount Program
• Enhanced group benefits
• Parental Leave Top–up program
• Fitness membership discounts
• Volunteer Paid Day

We are focused on building a diverse and inclusive workforce. If you are excited about this role and are not confident you meet all the qualification requirements, we encourage you to apply to investigate the opportunity further.

Please submit your resume in confidence by clicking “Apply”. Only qualified candidates selected for an interview will be contacted. CI Financial Corp. and all of our affiliates (“CI”) are committed to fair and accessible employment practices and provide reasonable accommodations for persons with disabilities. If you require accommodations in order to apply for any job opportunities, require this posting in an additional format, or require accommodation at any stage of the recruitment process please contact us at [e-mail], or call 416-364-1145 ext. 4747.