Data Engineer

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. WHAT YOU WILL DO

• Design, develop, and optimize highly scalable data pipelines to enable seamless extraction, transformation, and loading (ETL/ELT) processes to/from diverse systems
• Collaborate with business and analytics team to gather and understand requirements, ensuring alignment with business objectives and data needs.
• Build frameworks to accelerate and standardize data ingestion, transformations, validations, and monitoring.
• Leverage Snowflake to create accurate, single version of the truth.
• Document & assist development teams with best practice, data delivery solutions using the core platform and data management tools.
• Take ownership of key aspects of project delivery, including planning, development, testing, and deployment, while working closely with cross-functional teams to ensure successful and timely outcomes.
• Troubleshoot and resolve production issues, including performance bottlenecks, data quality problems, and system failures; proactively optimize existing workflows for reliability and efficiency.

WHAT YOU WILL BRING Experience

• 5+ years of experience in data engineering, with a strong focus on designing and developing scalable data pipelines, ETL/ELT workflows, and data integration solutions.
• Experience with data warehousing concepts and technologies.
• Expertise in SQL, with experience using dbt and Snowflake preferred.
• Strong problem-solving skills with the ability to tackle open-ended challenges and deliver high-quality solutions.
• Solid understanding of data management principles, including data architecture, data quality, data modeling, and data governance.
• Experience with DevOps practices, including CI/CD pipelines and automated deployment/testing frameworks.
• Experience with Data Vault 2.0 is considered an asset.
• Ability to work with business stakeholders to understand requirements and explain complex technical solutions in simple terms.

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