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

📌 Senior Data Modeler (Chennai)
🏢 CGI
📍 Chennai