Data Modeler
CGI
Toronto, ON, Canada
USD 95k-145k / year
Posted on Mar 25, 2026
Position Description
This role is hybrid and requires you to be at a Client office at a minimum 2 days per week - subject to change at any time.
The Data Modeler will be a part of a SaaS migration project of the current Client Onboarding System. We are looking for a Data Modeler who is a self-starting, results-oriented, highly motivated individual with great attention to detail and excellent problem-solving skills. A candidate for this role will need to multitask, lead workstreams and be comfortable working in a fast-paced and agile environment with tight project delivery timelines.
Your future duties and responsibilities
Work with business users and technology to obtain data requirements and analyze source systems data.
Design and develop conceptual, logical and physical data models for the operational and analytical data models.
Work closely with the technical and application architects and developers to implement the data architecture and application solution.
Document data flows, identify appropriate data sources, entities, relationships and redundancies.
Manage data integrity and data quality.
Maintain technical & business metadata, for SaaS or Internal ingestion frameworks.
Design data structures and document data meanings, definitions and intended use.
Support data migration, data strategies, standards, guidelines, data quality process, data validation and governance across the enterprise/and for this project.
Required Qualifications To Be Successful In This Role
Together, as owners, let’s turn meaningful insights into action.
Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…
You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.
Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.
You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.
At CGI, we value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all CGI partners to thrive. As an equal-opportunity employer, being able to perform your best during the recruitment process is important to us. If you require an accommodation, please inform your recruiter.
To learn more about accessibility at CGI, contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.
Come join our team—one of the largest IT and business consulting services firms in the world.
This role is hybrid and requires you to be at a Client office at a minimum 2 days per week - subject to change at any time.
The Data Modeler will be a part of a SaaS migration project of the current Client Onboarding System. We are looking for a Data Modeler who is a self-starting, results-oriented, highly motivated individual with great attention to detail and excellent problem-solving skills. A candidate for this role will need to multitask, lead workstreams and be comfortable working in a fast-paced and agile environment with tight project delivery timelines.
Your future duties and responsibilities
Work with business users and technology to obtain data requirements and analyze source systems data.
Design and develop conceptual, logical and physical data models for the operational and analytical data models.
Work closely with the technical and application architects and developers to implement the data architecture and application solution.
Document data flows, identify appropriate data sources, entities, relationships and redundancies.
Manage data integrity and data quality.
Maintain technical & business metadata, for SaaS or Internal ingestion frameworks.
Design data structures and document data meanings, definitions and intended use.
Support data migration, data strategies, standards, guidelines, data quality process, data validation and governance across the enterprise/and for this project.
Required Qualifications To Be Successful In This Role
- Relational and dimensional data modelling and database design, Data modelling skills, including Data Mapping Analysis, Transformation Analysis.
- Strong SQL, Schema Conversion/Translation and some Python knowledge.
- Knowledge of data architectural approaches, patterns and emerging technologies (RDBMS, KeyValue).
- Exposure or knowledge of Cloud platforms, cloud architecture, capabilities and processes like GCP/AWS.
- Ability to translate business needs into technical solutions. Strong Analytical skills.
- Experience creating architecture and strategy artifacts. Also, it can generate data dictionaries for the target state.
- Experience with XML, JSON, and CSV files Ingestion formats.
- Experience working in an Agile environment.
- Knowledge of the Data Governance process for metadata and lineage management is a strong asset. Exposure to any Data Governance and Data lineage tools.
- Domain Knowledge in financial Services and enterprise functions is a strong asset.
- Knowledge of database administration, database performance tuning, source & target data structures, ETL processes/products.
- Bachelor's Degree, in computer engineering or information science.
- Nice to have Fenergo Implementation experience
- CGI is providing a reasonable estimate of the pay range for this role. The determination of this range includes factors such as skill set level, geographic market, experience and training, and licenses and certifications. Compensation decisions depend on the facts and circumstances of each case. A reasonable estimate of the current range is $95,000–$145,000. This role is an existing vacancy.
Together, as owners, let’s turn meaningful insights into action.
Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…
You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.
Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.
You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.
At CGI, we value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all CGI partners to thrive. As an equal-opportunity employer, being able to perform your best during the recruitment process is important to us. If you require an accommodation, please inform your recruiter.
To learn more about accessibility at CGI, contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.
Come join our team—one of the largest IT and business consulting services firms in the world.