DataOps Engineer (Snowflake)

CI Financial; Toronto; On-site; CAD 85,000 - 110,000; Full time

Job summary

CI Financial is seeking a skilled DataOps Engineer to join their Data, AI & Analytics team. The role involves optimizing data pipelines, managing the Snowflake platform, and ensuring efficiency and scalability in data processes. The ideal candidate will have strong expertise in Snowflake, CI/CD practices, and data pipeline orchestration tools. CI Financial offers a supportive environment with competitive benefits and opportunities for growth.

Benefits

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

Qualifications

• 3+ years of experience in data engineering or DataOps.
• Extensive experience with Snowflake and CI/CD practices.
• Proficiency in SQL and Python.

Responsibilities

• Optimize data pipelines and manage the Snowflake platform.
• Design and maintain data pipeline orchestration using Apache Airflow.
• Monitor performance and troubleshoot data quality issues.

Skills

Snowflake

CI/CD

SQL

Python

Problem Solving

Education

Bachelor's degree in Computer Science

Bachelor's degree in Information Systems

Bachelor's degree in Engineering

Tools

Apache Airflow

Jenkins

GitLab CI

Docker

Kubernetes

Job description

1 week ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

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.

CI Financial is seeking a skilled DataOps Engineer to join our Data, AI & Analytics (DNA) team. In this role, you will optimize data pipelines and manage the Snowflake platform to ensure efficiency, scalability, and reliability. You’ll integrate Snowflake with CI/CD practices for seamless data pipeline delivery, while automating workflows, troubleshooting issues, and optimizing architecture for performance and scalability. Your contributions will drive efficient collaboration and continuous improvement across teams.

KEY RESPONSIBILITIES:

• Snowflake Expertise: Leverage Snowflake as the central platform for data storage, transformation, and analysis. Ensure best practices for schema design, platform setup and performance optimization.
• Airflow Orchestration: Design, implement, and maintain data pipeline orchestration using Apache Airflow to ensure the scheduling, monitoring, and execution of tasks across various stages of the data pipeline.
• Monitoring & Troubleshooting: Monitor the performance of Snowflake queries, data pipelines, and CI/CD workflows, identifying performance bottlenecks and resolving data quality or deployment issues.
• Pipeline Automation: Design, implement, and maintain automated data pipelines using Snowflake, ETL/ELT tools, and orchestration tools (e.g., Apache Airflow).
• Optimizing Data Architecture: Help design and optimize Snowflake's architecture, ensuring efficient data storage, query performance, clustering, and partitioning strategies.
• Testing & Quality Assurance: Implement testing strategies for data accuracy, consistency, and reliability. Automate testing and validation within the CI/CD pipeline to ensure high-quality deployments.
• Documentation: Maintain thorough documentation of data workflows, Snowflake architecture, CI/CD configurations, and processes for team transparency and knowledge sharing.
• CI/CD Pipeline Management: Maintain CI/CD processes for data pipelines and Snowflake-related workflows to streamline deployment and minimize downtime.
• Collaboration: Work closely with data engineers, data scientists, and other stakeholders to implement data management best practices that leverage Snowflake’s capabilities and ensure continuous delivery through CI/CD pipelines.

Qualifications:

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field (or equivalent experience).
• 3+ years of experience in data engineering, DevOps, or DataOps, with strong expertise in Snowflake and CI/CD pipeline development.
• Extensive experience with Snowflake, including schema design, platform capabilities, performance tuning, and query optimization.
• Proven experience with CI/CD tools and practices (e.g., Jenkins, GitLab CI, etc.) to automate the deployment of data pipelines and infrastructure.
• Expertise in data pipeline orchestration tools (e.g., Apache Airflow, Prefect, or similar).
• Proficiency in SQL, Python, or other programming languages used in data manipulation, pipeline automation, and CI/CD processes.
• Familiarity with cloud platforms (e.g., AWS, GCP, Azure) and their integration with Snowflake.
• Experience with version control systems (e.g., Git) and containerization tools (Docker, Kubernetes) is a plus.
• Knowledge of ETL/ELT processes and tools, particularly those that integrate with Snowflake.
• Strong understanding of data security, privacy, and compliance regulations in the context of cloud data platforms.
• Excellent problem-solving, troubleshooting, and communication skills.

Preferred Qualifications:

• Knowledge of asset management, financial services, or wealth management industries
• Snowflake certifications (e.g., Snowflake Data Engineer or Architect).
• Familiarity with data science and machine learning workflows.
• Experience with other cloud-based data tools (e.g., dbt, Fivetran, Matillion).

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

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

Referrals increase your chances of interviewing at CI Financial by 2x

Get notified about new Data Specialist jobs in Toronto, Ontario, Canada.

GBM - Data and Operational Initiatives Internship/Co-Op - Fall 2025

Data Analyst - (SAS, SQL and Tableau)- Banking

Velocity - Data Analyst Internship/Co-Op - Fall 2025

Part-time Data Quality Analyst (Fraud Investigation)

PPM Data Analytics & Power BI Specialist

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.