Senior Data Modeller

About the Job

We are looking for a skilled Senior Data Modeller who can design, develop, and maintain robust data models that support enterprise-scale data management, analytics, and reporting solutions. Skilled in translating complex business requirements into scalable and efficient conceptual, logical, and physical data models across transactional and analytical systems.

Key Responsibilities:

• Create conceptual, logical, and physical data models to represent business entities and relationships.
• Define data structures that support both operational (OLTP) and analytical (OLAP) use cases.
• Work closely with business analysts, data architects, data engineers, and BI teams to understand data requirements.
• Translate business needs into scalable, maintainable data architecture.
• Define and enforce naming standards, data types, constraints, and normalisation rules.
• Help implement master data and reference data structures for consistency across systems.
• Participate in or lead efforts around data governance, data lineage, and metadata management.
• Maintain data dictionaries and documentation for modelled data assets.
• Classify PCI datasets with the right labels and policies around them
• Ensure GDPR Compliance is in place at the data model
• Design models for high performance and scalability, considering indexing, partitioning, and access patterns.
• Work with DBAs and engineers to tune queries and ensure model efficiency.
• Create dimensional models (e.g., star and snowflake schemas) for use in data warehouses, data marts, and BI tools.
• Support ETL/ELT design by providing source-to-target mappings and transformation logic.
• Version-control and manage changes to data models as business requirements evolve.
• Conduct impact analysis for changes to existing data models or systems.

Requirements

Experience and Skills:

• 8 to 12 years of experience in the design, development, and maintenance of different data models
• Experience in building Conceptual, Logical & Physical Data Models, including dimensional Modelling (Star, Snowflake)
• Experience in building Data Warehouse & assisting in ETL Design
• Proven experience in Data Governance & Quality Standards
• Proven experience in Master & Reference Data Modelling
• Strong hands-on with Mongo CRUD, aggregation pipelines and experience handling data using JS.
• Strong hands-on with SQL (complex queries), dbt, Python (for data transformation)
• Experience in Data Modelling Tools like Erwin, ER/Studio, PowerDesigner, Lucidchart (Any one)
• Databases: MongoDB and any RDMS are mandatory
• Cloud: Expertise in Data services (AWS, AZURE, GCP)

Desired Skills and Experience

• 8 to 12 years of experience in the design, development, and maintenance of different data models

• Experience in building Conceptual, Logical & Physical Data Models, including dimensional Modelling (Star, Snowflake)

• Experience in building Data Warehouse & assisting in ETL Design

• Proven experience in Data Governance & Quality Standards

• Proven experience in Master & Reference Data Modelling

• Strong hands-on with Mongo CRUD, aggregation pipelines and experience handling data using JS.

• Strong hands-on with SQL (complex queries), dbt, Python (for data transformation)

• Experience in Data Modelling Tools like Erwin, ER/Studio, PowerDesig
• 8 to 12 years of experience in design, development, and maintenance of different data models

• Experience in building Conceptual, Logical & Physical Data Models, including dimensional Modelling (Star, Snowflake)

• Experience in building Data Warehouse & assisting in ETL Design

• Proven experience in Data Governance & Quality Standards

• Proven experience in Master & Reference Data Modelling

• Strong hands-on with Mongo CRUD, aggregation pipelines and experience handling data using JS.

• Strong hands-on with SQL (complex queries), dbt, Python (for data transformation)

• Experience in Data Modelling Tools like Erwin, ER/Studio, PowerDesigner, Lucidchart (Any one)

• Databases: MongoDB and any RDMS are mandatory

• Cloud: Expertise in Data services (AWS, AZURE, GCP)

ner, Lucidchart (Any one)

• Databases: MongoDB and any RDMS are mandatory

• Cloud: Expertise in Data services (AWS, AZURE, GCP)