Senior Data Modeler Data Product Designer

Position Description:

CGI is seeking a Senior Data Modeller / Data Product Designer to design end-to-end data structures across our Payments data ecosystem from MongoDB-based transactional Operational Data Stores (ODS) through to Azure Databricks curated data products.

This role is focused on schema design data product design and context-layer modelling. The successful candidate will help define how Payments data is represented governed reused and consumed across operational and analytical platforms.

The role is approximately 75% data modelling / data product design and 25% data engineering enablement working closely with business analysts data engineers analytics teams architects and Payments partners.

The ideal candidate can bridge semi-structured JSON/MongoDB modelling Databricks/Delta schema design and reusable domain-oriented data products. The team will provide training on ISO 20022 payment schema relationships which will be used to help build a Payments context layer across payment types

Your future duties and responsibilities:

Design JSON schemas for MongoDB-based transactional ODS capabilities aligned to business workflows query patterns and schema evolution needs.
Design corresponding Databricks/Delta table schemas for curated reusable data products.
Define reusable Payments data products across individual payment types and combined cross-payment views.
Design a context layer / canonical Payments model that supports cross-product analytics reporting and downstream consumption.
Translate business requirements into logical and physical data models for both operational and analytical use cases.
Support schema evolution versioning migration and backward compatibility across MongoDB and Databricks.
Design data products aligned to Unity Catalog structures access patterns discoverability and governed sharing.
Differentiate between source-aligned domain-aligned and consumer-aligned data products.
Collaborate with data engineering teams to operationalize models through ingestion curation and transformation pipelines.
Support governance expectations including metadata data quality lineage access controls and appropriate documentation.
Work with business and technology partners to ensure data products are understandable reusable and fit for consumption

Required qualifications to be successful in this role:

8 years of experience in data modelling across operational and analytical platforms.
Strong experience designing JSON / semi-structured schemas preferably for MongoDB or similar document databases.
Strong experience designing SQL / analytical schemas for data platforms warehouses or lakehouses.
Experience translating business workflows and query patterns into durable scalable schema designs.
Experience with schema evolution versioning backward compatibility and migration strategies.
Experience designing reusable datasets or data products for analytics reporting APIs or downstream consumers.
Strong understanding of data product concepts including usability reuse ownership documentation and consumer alignment.
Working knowledge of Databricks / Delta Lake schema design including partitioning and performance considerations.
Familiarity with Unity Catalog or equivalent governed catalog / metadata structures.
Strong SQL skills.
Ability to work closely with BSAs engineers architects and business stakeholders.
Excellent communication documentation analytical thinking and problem-solving skills.
NICE TO HAVE
Payments domain knowledge.
Awareness of ISO 20022 Payments schemas and relationship structures.
Experience designing canonical data models or context layers across multiple source systems.
Experience with MongoDB indexing sharding performance tuning or MongoDB Atlas.
Experience with PySpark Spark SQL Delta Lake optimization and Databricks performance patterns.
Experience with Azure Databricks Azure Data Factory Azure Synapse or similar cloud data services.
Experience with Kafka event schemas schema registry or streaming data patterns.
Familiarity with data governance processes such as privacy impact assessments data access controls metadata standards lineage and regulated-environment audit expectations.
Experience with Collibra or similar catalog / data governance tooling.

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 $70000.00$135000.00. This role is an existing vacancy.


#LI - OA1

Skills:

• Angular
• Java
• Java Enterprise Editions JEE
• Oracle
• Spring Boot
• SQL

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll 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. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll 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.

Youll shape your career by joining a company built to grow and last. Youll 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 teamone of the largest IT and business consulting services firms in the world.