Lead Analyst-DataModeler

Position Description
Lead Analyst-Data Modeler
Position Description
At CGI were a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72000 professionals located in 40 countries. Founded in 1976 CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources expertise stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at .

This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans. We wish to thank all applicants for their interest and effort in applying for this position however only candidates selected for interviews will be contacted. No unsolicited agency referrals please.


Position: Lead Analyst
Experience: 8-12yrs
Shift: 1PM to 10PM
Main location: Bangalore/Chennai
#LI-AD11
Employment Type: Full Time
Education Qualification: Any graduation or related field or higher with minimum 3 years of Relevant experience.
Position Description: We are looking for an experienced 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

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

MUST HAVE
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.

• Data Analysis
• Data Modeling
• Data preparation
• Databricks
• JSON Web Token (JWT)
• MongoDB
• SQLite

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.

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.

Come join our teamone of the largest IT and business consulting services firms in the world.