Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Modeler

$95k - $145k per year
Data Modeler

Position Description
This role is hybrid and requires you to be at a Client office at a minimum 4 days per week subject to change at any time. 

We are seeking a Senior Data Modeller / Data Product Designer to join our Enterprise Payments team. This role will be responsible for designing end-to-end data structures across our Payments data ecosystem, from MongoDB-based operational data stores through to Azure Databricks curated data products.

The successful candidate will play a key role in defining how Payments data is modelled, governed, shared, and consumed across operational and analytical platforms. This position is ideal for someone who has deep expertise in data modelling and data product design and enjoys collaborating with business and technology partners to deliver scalable, reusable, and well-governed data solutions.

This role consists of approximately 75% data modelling and data product design and 25% data engineering enablement.

Your future duties and responsibilities
Design JSON schemas for MongoDB-based operational data stores, aligned with business processes, query patterns, and schema evolution requirements.
Design and maintain Databricks/Delta Lake schemas that support curated and reusable data products.
Develop reusable Payments data products across individual payment domains and enterprise-wide payment views.
Design and evolve a Payments context layer and canonical data model to support analytics, reporting, and downstream data consumption.
Translate business requirements into logical and physical data models for operational and analytical use cases.
Support schema versioning, migration strategies, backward compatibility, and ongoing model evolution.
Design data products aligned with governance standards, metadata requirements, discoverability, and access controls within Unity Catalog or similar platforms.
Define and differentiate source-aligned, domain-aligned, and consumer-aligned data products.
Collaborate with business analysts, architects, data engineers, and other stakeholders to operationalize data models through ingestion, transformation, and curation pipelines.
Support data governance initiatives including metadata management, data quality, lineage, documentation, and access management.
Create clear and comprehensive documentation to ensure data assets are reusable, understandable, and fit for purpose.

Required qualifications to be successful in this role
8+ years of experience in data modelling across operational and analytical environments.
Strong experience designing JSON and semi-structured data models, particularly within MongoDB or similar document-based databases.
Strong experience designing relational, analytical, or lakehouse schemas using SQL-based platforms.
Proven ability to translate business workflows, requirements, and query patterns into scalable, maintainable data models.
Experience supporting schema evolution, versioning, migration, and backward compatibility strategies.
Experience designing reusable datasets, data products, or data domains for analytics, reporting, APIs, or enterprise consumption.
Strong understanding of data product principles, including ownership, usability, discoverability, documentation, and consumer alignment.
Working knowledge of Databricks and Delta Lake schema design, including performance and partitioning considerations.
Familiarity with Unity Catalog or equivalent metadata and governance frameworks.
Advanced SQL skills.
Strong stakeholder management, communication, analytical thinking, and problem-solving abilities.
Experience collaborating with cross-functional teams including business stakeholders, business analysts, architects, and engineers.

Experience working within the Payments domain.
Familiarity with ISO 20022 payment messaging standards and schema structures.
Experience designing canonical data models or enterprise context layers spanning multiple source systems.
Knowledge of MongoDB indexing, sharding, performance tuning, and MongoDB Atlas.
Experience with PySpark, Spark SQL, Delta Lake optimization, and Databricks performance best practices.
Experience with Azure Databricks, Azure Data Factory, Azure Synapse, or similar cloud-based data platforms.
Understanding of event-driven architectures, Kafka, schema registries, and streaming data patterns.
Familiarity with data governance practices including metadata management, lineage, privacy requirements, audit controls, and regulated data environments.
Experience with Collibra or similar data catalog and governance tools.

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

#LI-AV1!

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.

That same commitment to fairness extends to how we use technology. To support our recruitment team, AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.

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.

Vacancy posted 20 days ago
Similar jobs that could be interesting for youBased on the Data Modeler in Toronto, ON vacancy
  •  ...leading organizations unlock the value of technology and build a more sustainable, more inclusive world. Job Description The IT Data Modeler is responsible for designing, developing, and maintaining enterprise data models that support insurance operations, reporting,... 
    Suggested
    Permanent employment
    Full time
    Local area

    Capgemini

    Toronto, ON
    12 days ago
  • $80 per hour

     ...D'Angelo , Larry Summers , and Jack Dorsey . Position: Data Engineer (Coding Agent Experience) Type: Contract...  ...complete and evaluate complex data engineering tasks. Review model-generated implementations involving ETL pipelines , data warehouses... 
    Suggested
    Remote job
    Contract work
    Summer work

    Mercor

    Toronto, ON
    8 days ago
  •  ...Business Data Analyst – NoSQL | Microsoft SQL Server | Data Analysis Job Description: Data Analyst w NOSQL~Microsoft SQL Server 2019...  ...to produce IT requirements. • Working knowledge of data modelling, schema structure, data mapping and data transformation. • Good... 
    Suggested
    Contract work

    Astra North Infoteck Inc.

    Toronto, ON
    27 days ago
  •  ...Advanced experience with: · Python · PySpark · SQL · Data Modeling Techniques · ETL/ELT Development   Position Summary...  ..., Innovation & Analytics is seeking an experienced SCM Data Modeler with strong Databricks expertise to design, build, and... 
    Suggested
    Contract work

    Astra North Infoteck Inc.

    Toronto, ON
    a month ago
  • $95.3 - $114.37 per hour

     ...RQ11266 - Data Architect/Modeller - Senior 9 months (176 business days) + Possible extension Hybrid - 40 St. Clair Ave W, Toronto Must Have :  Resource will build upon the Conceptual and Logical Data Models which are technology-and application-independent... 
    Suggested
    Work at office
    Remote work
    Home office

    Source Code

    Toronto, ON
    a month ago
  •  ...of the Risk Scorecard and measuring performance of the predictive model. This is a unique opportunity that will broaden your experience...  ...Strategy Design Studio), Coding for SQL or python required for data analysis Knowledge of bureau data for modeling and review Excellent... 
    Full time
    Contract work
    Work at office
    Flexible hours
    Shift work

    Rogers Communications

    Toronto, ON
    14 minutes ago
  • $72k - $108k per year

     ...Job Type:  Permanent   Work Model:  Hybrid   Reference code: 133523 Primary Location:  Toronto, ON All Available Locations:  Toronto...  ...in project planning and progress tracking. Dive into financial data, scrutinize accounting records, and create sophisticated financial... 
    Permanent employment
    Internship
    Flexible hours

    Deloitte

    Toronto, ON
    15 minutes ago
  •  ...who expect an immediate, natural response. Improving these systems requires more than selecting the newest model. It requires disciplined evaluation, high-quality data, modeling judgment, experimentation, and production feedback loops. We are looking for an applied AI Modeling... 
    Long term contract
    Full time
    Temporary work
    Internship
    Immediate start

    Palona AI

    Toronto, ON
    19 days ago
  • $60k - $80k per year

     ...airports, ports, highways, and large-scale site development. The BIM Modeler will support the technical and project delivery teams by...  ...solutions within Aecon’s Integrated Digital Delivery (IDD) Common Data Environment (CDE). The role ensures all BIM deliverables are produced... 
    Permanent employment
    Temporary work
    Local area

    AECON

    Toronto, ON
    14 days ago
  •  ...visiting Context SYSTRA Canada is looking for a Transportation Modeller to join the team. The role focuses on developing and applying...  ...and junction levels. Coordinate the modelling work and data exchange between strategic models and micro-level simulation models... 
    Toronto, ON
    12 days ago
  •  ...visiting Context SYSTRA is looking for a Transportation Modeller Transport to join the team. The role focuses on demand forecasting...  ...wider transportation systems. Coordinate the modelling work and data exchange between strategic models and micro-level simulation... 
    Toronto, ON
    12 days ago
  •  ...Sensor Modeling & Simulation Engineer (M&S) Preferred Location: Ottawa or Toronto Reports...  ...owns the sensor and electronic-warfare models end to end — RF/radar, EW, multi-sensor fusion...  ..., TDOA/FDOA geolocation). Synthetic-data or RL training pipelines; integrating models... 
    Full time

    dominion%20dynamics

    Toronto, ON
    8 hours ago
  • $88k - $132k per year

     .... We are seeking a Senior Consultant with modelling experience acquired in the banking industry...  ...Development and validation of credit risk models (e.g. AIRB, IFRS 9, stress testing) based...  ...models   Strong quantitative skills in data analytics and modelling incl. artificial intelligence... 

    Ernst & Young

    Toronto, ON
    17 days ago
  •  ...platform, and our science team is looking to bring on an expert in Process Modelling who will be able to make significant technical contributions to our process simulation engine. The Process Modeller will be responsible for developing mathematical models for the Basetwo... 

    Basetwo

    Toronto, ON
    a month ago
  • $101k - $169k per year

     ...Job Type:  Permanent   Work Model:  Hybrid   Reference code: 133157 Primary Location:  Toronto, ON All Available Locations:  Toronto, ON   Our Purpose   At Deloitte, our Purpose is to make an impact that matters. We exist to inspire and help our people,... 
    Permanent employment
    Flexible hours

    Deloitte

    Toronto, ON
    15 minutes ago
  • $85 per hour

     ...Responsibilities Use frontier AI coding agents to complete and evaluate complex infrastructure engineering tasks. Review model-generated implementations involving cloud platforms , Kubernetes , CI/CD systems , observability , and infrastructure... 
    Remote job
    Contract work
    Summer work

    Mercor

    Toronto, ON
    6 days ago
  •  ...Company: Gridlines Gridlines is a rapidly growing financial modelling consultancy practice. We are transforming the world of financial...  ...join us on this journey. Role: We are seeking an experienced model audit professional that is passionate about financial modelling... 
    Full time
    Work at office
    Remote work
    Work from home
    Flexible hours

    Gridlines

    Toronto, ON
    a month ago
  •  ...’t wait to get to know you!  The Work   The Associate Director, REM Modelling ("ADRM") is responsible for the development, enhancement, implementation, and ongoing monitoring of quantitative models supporting the Bank's Reverse Mortgage (REM) business. The role provides... 
    Full time

    eqbank

    Toronto, ON
    23 days ago
  •  ...Senior Modeler Join us on our journey and help us create our next unannounced linear adventure game which is set in historical China and features a realistic visual style and authentic traditional combat gameplay. The project is making use of Unreal Engine 5 and is co-developed... 
    Work at office

    Highdive

    Toronto, ON
    more than 2 months ago
  • $40k - $60k per year

     ...Job Type:  Co-op/Intern   Work Model:  Hybrid  Reference code: 134620  Primary Location:  Toronto, ON All Available Locations:...  ...verbal), including experience in conducting research, synthesizing data, writing reports and preparing presentations, working in pressure... 
    Internship
    Flexible hours
    Day shift

    Deloitte

    Toronto, ON
    15 minutes ago
  • $80k - $90k per year

     ...elevating relevancy in E-commerce for everyday shoppers. As a Data Engineer on Fluent's Data Engineering team, you will bring your Databricks...  ...business: the syndicated and custom consumer segments we build, model, and deliver to leading data marketplaces. These data products... 
    Full time
    Work at office
    Remote work

    Fluent, LLC

    Toronto, ON
    5 days ago
  • $64k - $85k per year

     ...leave a lasting legacy for generations to come! The AutoCAD 3D Modeler (Dry Utility Modeler (3D), Utility Design), is responsible for...  ...civil interfaces. Convert 2D utility design drawings, survey data, record information, and existing model inputs into accurate 3D utility... 

    AECON

    Toronto, ON
    16 days ago
  • $84k - $175k per year

     ...Job Type:  Permanent   Work Model:  Hybrid   Reference code: 134814 Primary Location:  Toronto, ON All Available Locations:  Toronto...  ...the job coaching -- As a Manager and Senior Architect on our Data Modernization & Analytics team within the AI & Data practice, you... 
    Permanent employment
    Flexible hours
    Shift work

    Deloitte

    Toronto, ON
    2 days ago
  • usd84.46k - usd100k per year

     ...Senior Data Engineer    Join Livingston and grow your career in the constantly changing world of international trade. Livingston is...  ...EDI, and telematics/IoT sources. Architect and optimize data models and data warehouse/lakehouse structures to support reporting, forecasting... 
    Long term contract
    Full time
    Flexible hours

    Livingston International

    Toronto, ON
    15 minutes ago
  • $90k - $175k per year

     ...Type de poste : Permanent   Modèle de travail :  Hybride   Numéro de demande: 132027  Lieu principal : Toronto, ON Emplacements additionnels : Toronto, ON; Burlington, ON; Calgary, AB; Edmonton, AB; Fredericton, NB; Halifax, NS; Kitchener, ON; Laval, QC; Moncton... 
    Permanent employment
    Apprenticeship
    Work at office
    Flexible hours
    Day shift

    Deloitte

    Toronto, ON
    15 minutes ago
  • $75k - $95k per year

     ...stakeholders across a wide range of functions to implement and solve data engineering challenges? Are you equally skilled at delivering...  ...be responsible for building and maintaining the data pipelines, models, and infrastructure that deliver reliable, high-quality data to teams... 
    Full time
    Internship
    Work at office
    Flexible hours

    Financeit

    Toronto, ON
    24 days ago
  • $90k - $125k per year

     ...lifelong learners. About The Role As a Data Engineer you’ll be tasked with designing,...  ...and best practices. Perform data modelling, data extraction, transformation, and loading...  ...Experience building production-grade data models with optimized performance supporting operational... 
    Full time
    Work from home
    Flexible hours

    Konrad

    Toronto, ON
    8 hours ago
  • $73k - $99.5k per year

     ...problems. The opportunity The Decision Modelling team sits at the intersection of corporate...  ...sectors to develop integrated financial models and decision tools that support:...  ...technical stakeholders Familiarity with data visualization tools (e.g., Power BI) Exposure... 
    Weekend work

    Ernst & Young

    Toronto, ON
    20 days ago
  • $75k - $100k per year

     ...internal title will be Specialist, Digital, working primarily in a data analytics capacity across client engagements. As a Specialist,...  ...with data engineers and other analysts to support data modeling and reporting layers Communicate insights clearly through visualizations... 
    Full time
    Work from home
    Flexible hours

    Konrad

    Toronto, ON
    8 hours ago
  • $118k - $152k per year

     ...The Role Capco is looking for an experienced Data Architect with deep expertise across data flows, data integration, data sources...  ...environments. Deep understanding of data flows, data integration, data modelling, data sources, data platforms, and the full data lifecycle.... 
    Long term contract
    Internship
    Immediate start

    Capco

    Toronto, ON
    6 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Modeler. Be the first to apply!