Senior Data Engineer

CI Financial; Toronto; On-site; CAD 70,000 - 120,000; Full time

Benefits offered by this job

Training reimbursement

Paid professional designations

Employee savings plan

Corporate discount program

Enhanced group benefits

Parental leave top-up

Paid time off for volunteering

Job summary

CI Financial is seeking a Senior Data Engineer to join the Data, AI & Analytics (DNA) Team. You will design, build and optimize scalable data pipelines supporting ELT/ETL across diverse sources and platforms.

Collaborate with business and analytics stakeholders to translate requirements into robust data solutions. You will contribute to reusable frameworks, enforce standards, and maintain CI/CD pipelines for data platforms to ensure reliability and security.

Qualifications

• 8+ years of hands-on experience in data engineering and building scalable ELT/ETL pipelines.
• Strong SQL expertise and experience with dbt model design and testing.
• Experience with CI/CD pipelines for data platforms and managing deployments.

Responsibilities

• Design, build, and optimize highly scalable data pipelines for ELT/ETL across diverse source systems and platforms.
• Develop reusable frameworks and automation to standardize data ingestion, transformations, and monitoring.
• Perform thorough code reviews and enforce data engineering standards for the platform.

Skills

ELT/ETL pipelines

SQL proficiency

Snowflake

dbt

CI/CD for data

Data modeling

Tools

Bitbucket

Jenkins

Git workflows

Data Vault 2.0

Job description

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.

We are currently seeking a Senior Data Engineer to join the Data, AI & Analytics (DNA) Team. A successful data engineering candidate will demonstrates a deep understanding of database concepts, data pipeline design, while also having the ability to communicate complex ideas clearly, and have experience in implementing scalable solutions that have positively impacted business outcomes.

WHAT YOU WILL DO

• Design, build, and optimize highly scalable, reliable data pipelines to support ELT/ETL to/from diverse source systems and platforms.
• Develop reusable frameworks and automation to standardize data ingestion, transformations, reconciliations, testing, and monitoring.
• Perform thorough code reviews to ensure solutions meet performance, scalability, security, and maintainability standards.
• Define, document, and enforce data engineering standards for the platform.
• Partner closely with business & analytics stakeholders to translate requirements into scalable technical solutions.
• Maintain and improve the CI/CD pipeline for data platforms, including source control, build, test, and deployment workflows (e.g., Bitbucket, Jenkins, automated testing).
• Troubleshoot and resolve production issues such as data quality defects, pipeline failures, performance bottlenecks, and dependency breaks.
• Proactively identify opportunities to optimize and harden existing pipelines for reliability, observability, and operational efficiency.

WHAT YOU WILL BRING

• 8+ years of hands‑on experience in data engineering, building and operating scalable ELT/ETL pipelines and data integration solutions.
• 4+ years of experience with data warehousing and Snowflake.
• Strong SQL expertise and solid experience with dbt, including model design and testing
• Experience with CI/CD pipelines for data platforms, including source control, automated testing, and deployments (e.g., Bitbucket, Jenkins, Git-based workflows).
• Strong understanding of data architecture and data modeling
• Ability to diagnose and solve complex, open‑ended problems and deliver production‑ready solutions.
• Experience supporting production data platforms, including troubleshooting performance, and pipeline reliability issues.
• Experience with Data Vault 2.0 is an asset.
• Experience in the Financial Services Industry is an asset.

This opportunity is for an existing vacancy with the company. The anticipated base salary range for this position is $69,500 - $119,500. Exact salary depends on several factors such as experience, skills, education, and budget. Salary range may vary based on geographic location. In addition to base salary, this position is eligible for participation in a bonus program. In addition, The Company offers a variety of benefits to eligible employees, including health insurance coverage, wellness programs, life and disability insurance, retirement savings plans, paid leave programs, education-related programs, paid holidays and vacation time, and many others. Many of these benefits are subsidized or fully paid for by the company.

This role follows our in‑office work model and requires employees to be onsite four days per week to support collaboration and business needs.

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.

A Supportive Environment for Success

We offer an in-office environment, competitive benefits, and a supportive workplace to help our employees thrive both personally and professionally.

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
• Paid time off for Volunteering

We are focused on building a diverse and inclusive workforce.

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.