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 2 x Senior Data Engineer to join the Data and Analytics team in the Wealth Technology group at CI Wealth. The Data and Analytics team supports the organization through data management data governance reporting and business intelligence and insights. 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 clientfacing 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 endtoend 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 CIs 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.
- Support and mentor junior team members fostering a collaborative and growthoriented environment while providing technical guidance and expertise.
- Lead or participate in data migration projects transitioning legacy systems to modern platforms and architectures while minimizing disruption and data loss.
Qualification Requirements
Experience
- 6 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
- Postsecondary degree in a quantitative discipline.
Knowledge Skills and Abilities
- Comprehensive understanding of data pipeline architecture modern data stack architecture and cloudbased platforms including AWS Snowflake and other cloudnative solutions.
- Indepth 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 leading or contributing to migration projects to modern data platforms like Snowflake and/or AWS.
- Experience in the Financial Services Industry is an asset.
- Ability to work within an organization based upon continuous improvement.
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 highestquality investments and advice. Our commitment to the highest levels of performance means that whatever their position CI employees must be comfortable in a fastpaced 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 inoffice 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 Topup 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 or callext. 4747.
Required Experience:
Senior IC