Position Description:

Position Description

Lead Analyst-Data Modeler

Position Description

At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 72,000 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 www.cgi.com.

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

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

Your future duties and responsibilities:

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.

Required qualifications to be successful in this role:

MUST HAVE
- 8+ years of experience in data modelling across operational and analytical platforms.
- Solid 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.

Skills:

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

What you can expect from us:

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.

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 team—one of the largest IT and business consulting services firms in the world.

📌 Lead Analyst-DataModeler (Bengaluru)
🏢 CGI
📍 Bengaluru