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 a Data Engineer to join our CI GAM IT department. The successful candidate will work closely with our IT Client Reporting team on the development, modernization and maintenance of our statements and tax processes. In this role, you will assist with solutioning business requirements by extracting data, enhancing, and modifying applications to be used in client reporting.  You will also be assisting in transforming our legacy applications for cloud adoption. 

RESPONSIBILITIES:

• Design, build, and modernize our statements and tax reporting processes in the Snowflake Data Cloud environment.
• Develop integration processes using SQL and Python to produce curated data models.
• Optimize and maintain data architecture, including schema design, performance tuning, and query optimization.
• Develop and maintain comprehensive documentation for data processes, architecture, and procedures.
• Collaborate with business partners, business systems analysts, and other stakeholders to deliver data-driven solutions and insights.
• Participate in code reviews, provide mentorship to junior data engineers, and contribute to team knowledge sharing.
• Maintain and support existing legacy applications and processes for both CI GAM and CI Wealth

QUALIFICATION REQUIREMENTS:

• Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.

Experience

• 3+ years of experience in data engineering, data architecture, or a similar role in a professional environment
• Experienced in Snowflake Data Cloud, DBT and Airflow, including data modeling and cloud data architecture.
• Proficiency in SQL for data extraction, manipulation, and analysis.
• Developed using Python for data processing and automation.
• Solid experience with different data storage solutions in AWS such as Snowflake, S3 and Redshift
• Experience with AWS services such as Step Functions, Glue, and Secrets Manager.
• Strong analytical and problem-solving skills, with the ability to work effectively in a fast-paced, collaborative environment.
• Excellent communication skills, with the ability to translate complex technical concepts for non-technical stakeholders.
• Experience in the Financial Services Industry is an asset

Preferred Skills

• Strong knowledge in agile methodologies, DevOps practices, including CI/CD pipelines, containerization, and infrastructure as code (IaC).
• Experienced in the use of Atlassian collaboration tools.
• Experienced in shell-scripting language like KSH and SQR.
• Familiar with job scheduler tools like Autosys, cron, etc.
• Experience in Restful API is a plus
• Experience in cyber-security measures is a plus
• Good interpersonal and team skills.
• Excellent oral and written communication skills.
• Strong organizational, analytical skills.

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 accessible.recruitment@ci.com, or call 416-364-1145 ext. 4747.