Senior Data Modeller

1 week ago

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

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

    1 week 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 Modelling

    1 day ago

    Pune, Maharashtra, India Reveille Technologies,Inc Full time ₹ 1,00,00,000 - ₹ 2,00,00,000 per year

    We're Hiring: Senior Data Engineer (with AI Exposure)Location:AllHexawarelocations (PAN India)Experience:9–12 YearsStart Date:Immediate Joiners PreferredAbout the RoleWe are looking for aSenior Data Engineerwith strong data engineering fundamentals and a passion for driving intelligent data solutions. You'll be working on complex data platforms that...

  • Data Modeler

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

  • Senior Data Modeler

    17 hours ago

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

    About the RoleWe are looking for an experienced Data Modeler to join our data engineering team for a leading banking project. The ideal candidate will have hands-on experience in data modeling using Erwin, a deep understanding of Medallion architecture, and strong analytical skills to translate business requirements into scalable, high-quality data...

  • Data Modeler

    2 weeks ago

    Pune, Maharashtra, India, Maharashtra Optimum Solutions Pte Ltd Full time

    Role: Senior/Lead Data Modeller Experience: 6+ Yrs Location: PuneNotice Period: Immediate to 15 days onlyInterview: Virtual discussionMode: Hybrid – 4 days a weekAbout the RoleWe are looking for an experienced Data Modeler to join our data engineering team for a leading banking project. The ideal candidate will have hands-on experience in data modeling...

  • Data Modeller/Senior Consultant Specialist

    1 week ago

    Pune, Maharashtra, India HSBC Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Job descriptionSome careers shine brighter than others.If you're looking for a career that will help you stand out, join HSBC and fulfil your potential. Whether you want a career that could take you to the top, or simply take you in an exciting new direction, HSBC offers opportunities, support and rewards that will take you further.HSBC is one of the largest...

  • Data Modeler

    1 week ago

    Pune, Maharashtra, India Parkar Digital Full time ₹ 5,00,000 - ₹ 8,00,000 per year

    About Us:At Parkar, we stand at the intersection of innovation and technology, revolutionizing software development with our cutting-edge Low Code Application Platform, For almost a decade, our expertise has expanded to four countries, offering a full range of software development services, including product management, full-stack engineering, DevOps, test...

  • Senior Data Modeler

    1 day ago

    Pune, Maharashtra, India Inwinteck Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Responsibilities:* Lead data modeling initiatives using Erwin and metadata management techniques.* Collaborate with stakeholders on requirements gathering and design implementation. Proactive and consultative mindsetStrong stakeholder engagemeProvident fund

  • Data Modeller

    2 weeks ago

    Pune, Maharashtra, India Persistent Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    About Position:We are looking for an experienced Data Modeller to join our growing team. The ideal candidate will have a strong background in working with Data Modeller (Power BI, Tabular Models, old MDX background). You will work closely with our engineers and business teams to ensure optimal performance, scalability, and availability of our data...

  • Data Modeler

    1 week ago

    Pune, Maharashtra, India Persistent Full time ₹ 1,04,000 - ₹ 1,30,878 per year

    About Position:We are seeking a highly skilled and experienced Data Modeler to join the Optum Advisory Team. The ideal candidate will bring deep expertise in cloud-based data engineering, healthcare data modeling, and consulting, with a strong background in Azure, Databricks, Azure Data Factory (ADF), Kafka, and Snowflake. This role requires a self-starter...