Senior Data Modeller

2 weeks ago


Pune, India Facctum Full time

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)


  • Senior Data Modeler

    4 weeks ago


    Pune, Maharashtra, India ElementSkill Full time

    We are seeking a highly skilled Senior Data Modeler to lead the design, governance, and optimization of enterprise data models within our Data & Analytics platform. In this role, you will develop scalable, modular, and business-aligned models that serve as the foundation for analytics and reporting across multiple regions and clients.Working closely with...


  • Pune, Maharashtra, India Facctum Full time ₹ 10,00,000 - ₹ 25,00,000 per year

    About the JobWe 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...

  • Senior Data Modeler

    2 weeks ago


    Pune, India Talent et au-dela Full time

    As aSenior Data Modeller, you will play a key role in designing, governing, and optimizing the core data models within our Data & Analytics platform. You will lead the development of scalable, modular, and business-aligned models that serve as the foundation for analytics and reporting across multiple regions and clients. Collaborating closely with data...

  • Senior Data Modeler

    4 days ago


    Pune, Maharashtra, India Talent et au-dela Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    As aSenior Data Modeller, you will play a key role in designing, governing, and optimizing the core data models within our Data & Analytics platform. You will lead the development of scalable, modular, and business-aligned models that serve as the foundation for analytics and reporting across multiple regions and clients. Collaborating closely with data...

  • Senior Data Modeler

    4 days ago


    Pune, Maharashtra, India Gentrack Full time ₹ 10,00,000 - ₹ 25,00,000 per year

    The CompanyGentrack provides leading utilities across the world with innovative cleantech solutions. The global pace of change is accelerating, and utilities need to rebuild for a more sustainable future.  Working with some of the world's biggest energy and water companies, as well as innovative challenger brands, we are helping companies reshape what it...

  • Data Modeller

    2 days ago


    Bengaluru, Chennai, Pune, India Hexaware Technologies Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    If you want to apply for the position then kindly share the following details below on Total ExpCTCECTCNPLocDescription for Internal CandidatesSenior Data Modeler Job Description Position overview Seeking an experienced Senior Data Modeler to design, develop, and maintain robust data models and enterprise data architecture to support analytical and...

  • Data Modeler

    1 week ago


    Pune, Maharashtra, India Abacus Insights Full time ₹ 40,00,000 - ₹ 1,20,00,000 per year

    Abacus Insights is a mission-driven, growth-stage technology company focused on transforming the healthcare industry, ultimately creating a more personalized patient experience, improving health outcomes, and lowering the overall cost of healthcare. Abacus Insights provides a flexible, efficient, and secure platform that organizes and exchanges healthcare...


  • Pune, India Data Axle Full time

    Job Description About Data Axle: Data Axle Inc. has been an industry leader in data, marketing solutions, sales and research for 50 years in the US. Data Axle has set up a strategic global centre of excellence in Pune. This centre delivers mission critical data services to its global customers powered by its proprietary cloud-based technology...

  • Data Modeler

    6 days ago


    Pune, India Teradata Full time

    **Role**: Data Modeler Specialist **Educational Requirements**: Bachelor’s degree from a reputed Educational Institute. Post-graduate degree is a plus **Technical Skill Set Required**: 5-8 years of IT Exp 3+ Years of Teradata Development experience Performed Low/ High Level Design activities Good understanding of Teradata database architecture and...

  • Data Modeller

    4 days ago


    Bengaluru, Delhi, NCR, Pune, India Infogain Full time ₹ 8,00,000 - ₹ 12,00,000 per year

    Job Summary:We are looking for a Data Modeler to support our Data Engineering team in building and maintaining standardized data models and Single View of Customer models. The role involves preparing and visualizing data models, ensuring compliance with PACS DAWG standards, maintaining data dictionaries, and supporting NoSQL data modelling initiatives.Key...