Data Engineer

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 for a Data Engineer to join the Data Solutions team in the Wealth Technology group at CI Wealth. The Data Solutions team focuses on developing data-driven solutions, driving innovation, and uncovering key insights to support strategic initiatives. The successful candidate will work on data pipeline and data transformation tasks that underly these strategic pillars.

RESPONSIBILITIES

• Collaborate with business teams and Data Analysts to gather and understand requirements, ensuring alignment with business objectives and data needs.
• Translate business needs into detailed technical requirements in collaboration with subject matter experts (SMEs) to ensure accuracy and feasibility.
• Recommend and design scalable, efficient, and effective data architectures and workflows to support current and future business requirements.
• Design, develop, and maintain data assets to enable seamless extraction, transformation, and loading (ETL/ELT) processes from diverse data sources, making data accessible to client-facing applications, data warehouses, and internal tools.
• Build, operate, and optimize highly scalable and reliable data pipelines and infrastructure to support analytics, reporting and operational use cases.
• Drive end-to-end ownership of projects, including planning, development, testing, and deployment, ensuring timely and successful delivery.
• Collaborate with Quality Assurance (QA) and Support teams to identify, troubleshoot, and resolve issues in production environments, ensuring the stability and reliability of data systems.
• Work with Release Management to plan, coordinate, and implement data pipeline updates, adhering to CI's deployment standards and minimizing disruption to production systems.
• Implement and enforce best practices for observability, data lineage, and governance, ensuring transparency, reliability, and compliance across all data systems.
• Participate in data migration projects, transitioning legacy systems to modern platforms and architectures while minimizing disruption and data loss.

EXPERIENCE

• 3+ years of professional experience in data engineering, with a strong focus on designing, developing, and optimizing scalable data pipelines, ETL/ELT workflows, and data integration solutions using modern tools and technologies.

EDUCATION/TRAINING

• Post-secondary degree in a quantitative discipline.

KNOWLEDGE, SKILLS, AND ABILITIES

• Comprehensive understanding of data pipeline architecture, modern data stack architecture, and cloud-based platforms, including AWS, Snowflake, and other cloud-native solutions.
• In-depth knowledge and experience with the following tools and concept:
• Data extraction – SQL, Python, API invocation, CDC
• Database systems – PostgreSQL, Sybase, MySQL, DynamoDB
• Data storage repositories – SFTP, AWS S3
• Scheduling of data jobs – CRON, Apache Airflow, AWS Step Functions
• ETL/ ELT tools and workflow – Snowflake, PySpark, AWS Glue, EMR, AWS Lambda, SCD
• CI/CD pipelines – Bitbucket, Git, Jenkins, CloudFormation, Terraform, Flyway
• Strong knowledge of observability and data lineage implementation to ensure pipeline transparency and monitoring.
• A strong analytical mindset and sophisticated written and verbal communication skills.
• Experience in the Financial Services Industry is an asset.
• Ability to work within an organization based upon continuous improvement.

WHAT WE OFFER

• Modern HQ location within walking distance from Union Station
• Equipment Purchase Program
• Training Reimbursement
• Paid Professional Designations
• Employee Share Purchase Program (ESPP)
• Corporate Discount Program
• Enhanced group benefits
• Parental Leave Top–up program
• Fitness membership discounts
• Volunteer paid Days

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 , or call ext. 4747.