Role & 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 Skills

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

Preferred candidate profile

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

Perks and perks

📌 Data Modeler (Bengaluru)
🏢 CGI
📍 Bengaluru