Data Solutions Designer

CI Investments Inc.; Golden Horseshoe; On-site; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Training Reimbursement

Paid Professional Designations

Employee Savings Plan (ESP)

Corporate Discount Program

Enhanced group benefits

Parental Leave

Top-up program

Job summary

CI Investments Inc. is seeking a Data Solutions Designer to guide end-to-end data flows from source systems to BI platforms, data science models, and external consumers. You will shape platform architecture, data modeling, and governance within a modern AWS/Snowflake environment.

The role emphasizes collaboration with data engineering, analytics, and AI teams, with an onsite four-day week to support collaboration and business needs. Strong data governance and regulatory alignment are essential.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Science, Engineering, or related field.
• Master’s degree in Data Analytics, Information Systems, or Financial Engineering preferred.
• Relevant certifications (Snowflake, AWS, dbt, TOGAF) are a plus.

Responsibilities

• Design end-to-end data solutions for BI, data processes, analytics and AI/ML initiatives.
• Develop data flow diagrams and system interaction models.
• Define data flows from ingestion to delivery, including real-time and batch patterns.
• Ensure support for operational and analytical use cases (dashboards, APIs, external data).
• Collaborate with data engineering, analytics, and AI teams on solution designs.
• Provide architectural guidance within AWS and Snowflake-based ecosystem.
• Model logical and physical data models for reporting needs.
• Support metadata, documentation, and lineage with governance tools.
• Align designs with platform standards and regulatory requirements.

Skills

End-to-End Solution Design

Cross-functional communication

Data governance

Strategic thinking

Architectural guidance

Education

Bachelor's degree

Master's degree (preferred)

Certifications (Snowflake, AWS, dbt, TOGAF)

Tools

Snowflake

AWS

dbt

Tableau Data Catalogs

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

We are seeking a Data Solutions Designer to join our Data, Analytics & AI (DNA) team in shaping data-driven solutions that enable investment insights, operational efficiency, and client reporting across our asset management business.

In this role, you will help design and guide the implementation of end-to-end data flows- from source systems through to final consumption by business intelligence platforms, data science models, and third-party consumers. This includes contributing to platform architecture, data modeling, and solution review across a modern stack.

This role follows our in-office work model and requires employees to be onsite four days per week to support collaboration and business needs.

• Design End-to-End Data Solutions Design robust data solutions supporting business intelligence, data processes, analytics and AI/ML initiatives.
• Develop technical flowcharts, data flow diagrams (DFDs), and system interaction models to visualize and validate proposed data solution designs.
• Define data flows from ingestion through transformation, storage, and delivery—including real-time and batch patterns.
• Ensure solutions support both operational and analytical use cases (e.g. dashboards, APIs, external data delivery).
• Collaborate Across Teams Partner with data engineering, analytics, and AI teams to evaluate and enhance solution designs.
• Provide guidance on architectural decisions, platform capabilities, and technology choices within our AWS and Snowflake-based ecosystem.
• Modeling & Metadata Design logical and physical data models to support various levels of reporting and analysis.
• Partner with Data Governance to help promote standards for metadata, documentation, and lineage tracking using tools like Alation, DBT and Tableau Data Catalogs.
• Platform & Governance Alignment Ensure all designs align with platform standards, data governance policies, and regulatory requirements relevant to asset management.
• Contribute to improving data product delivery patterns, reusability, and performance optimization.
• Review & Influence Review proposed solution designs and challenge approaches to ensure strategic alignment, maintainability, and fit-for-purpose outcomes.
• Act as a thought partner in refining how we deliver data, analytics, and AI capabilities to the business.

Education

• Bachelor’s degree in Computer Science, Information Systems, Data Science, Engineering, or a related field (required).
• Master’s degree in Data Analytics, Information Systems, or Financial Engineering (preferred).
• Relevant certifications (e.g. Snowflake, AWS, dbt, TOGAF) are a plus.

Experience

• 8+ years of experience in data architecture, data solution design, or data engineering—preferably within financial services or asset management.
• Strong understanding of data platforms and architecture, including experience with Snowflake for cloud data warehousing, AWS for cloud services and data pipelines, dbt for transformation and documentation.
• Demonstrated experience designing data flows and models to support BI, reporting, and/or AI/ML use cases.

Skills

• End-to-End Solution Design Thinking - The ability to see the full lifecycle of a solution - from data ingestion, processing, and modeling to delivery and consumption - while aligning it to business goals.
• Ability to work cross-functionally and communicate clearly with both technical and business stakeholders.
• Solid understanding of data governance, quality, privacy, and regulatory considerations in financial environments.

Desirable experience and skills

• Familiarity with investment data domains such as holdings, transactions, benchmarks, risk, or client reporting.
• Experience with data sharing, APIs, or delivering data to external consumers or partners.
• Experience with building DevOps pipelines for Data and/or AI/ML 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.

We are focused on building a diverse and inclusive workforce.

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

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.

CI Financial is an independent company offering global wealth management and asset management advisory services. 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.