Senior Data Modeller

3 days ago

Bengaluru, Karnataka, India Facctum Full time ₹ 12,00,000 - ₹ 36,00,000 per year

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

Proficient in data warehousing, dimensional modelling (star and snowflake schemas), and metadata management, with hands-on experience in a wide range of tools and platforms including Erwin, PowerDesigner, dbt, any RDMS, MongoDB, and cloud environments (AWS/Azure/GCP).

Proven ability to collaborate across business, engineering, and analytics teams to ensure data integrity, performance, and governance.

Key Responsibilities
Design and Develop Data Models :

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

Collaborate With Stakeholders

  • Work closely with business analysts, data architects, data engineers, and BI teams to understand data requirements.
  • Translate business needs into scalable, maintainable data architecture.

Ensure Data Quality And Consistency

  • Define and enforce naming standards, data types, constraints, and normalization rules.
  • Help implement master data and reference data structures for consistency across systems.

Support Data Governance

  • 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 right labels and policies around it.
  • Ensure GDPR Compliance is in place at the data model.

Optimize Data Performance

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

Model For Data Warehousing & BI

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

Maintain And Evolve Models

  • Version-control and manage changes to data models as business requirements evolve.
  • Conduct impact analysis for changes to existing data models or systems.

Requirements And Skills

  • 8 to 12 years of experience in design, develop, 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 handing data using js.
  • Strong hands-on with SQL (complex queries), dbt, Python (for data transformation).
  • Experience in Data Modeling Tools like Erwin, ER/Studio, PowerDesigner, Lucidchart (Any one).
  • Databases: MongoDB and any RDMS is mandatory.
  • Cloud: Expertise in Data services (AWS, AZURE, GCP).

)

  • Senior Data Modeller

    5 days ago

    Bengaluru, Karnataka, India Weekday Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    This role is for Weekday's client.Job Description:We are looking for a talented and experienced Senior Data Modeler to join our growing team. As a Senior Data Modeler, you will be responsible for designing, implementing, and maintaining data models to enhance data quality, performance, and scalability. You will collaborate with cross-functional teams...

  • Senior Data Modeler

    2 days ago

    Bengaluru, Karnataka, India Rite Software Solutions And Services Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Job Overview:We are seeking a highly skilled Senior Data Modeler with strong expertise in conceptual, logical, and physical data modeling. The ideal candidate will be proficient in data modeling tools like ERwin, ER/Studio, or similar, with a deep understanding of different database modeling techniques, including Star, Snowflake, and 3NF. This role requires...

  • Data Modeling

    7 days ago

    Bengaluru, Karnataka, India VidPro Consultancy Services Full time ₹ 1,20,000 - ₹ 6,00,000 per year

    Location: Hyderabad / Bangalore / PuneExperience: 7-16 YearsWork Mode: HybridMandatory Skills: ERstudio, Data Warehouse, Data Modelling, Databricks, ETL, PostgreSQL, MySQL, Oracle, NoSQL, Hadoop, Spark, Data Architect and Supplychain (preferred)Job Description:We are looking for a talented and experienced Senior Data Modeler to join our growing team. As a...

  • Senior Data Scientist

    7 days ago

    Bengaluru, Karnataka, India IC Data Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Senior Data Scientist (Remote Sensing)About the jobSagri Inc. is a pioneering social impact startup founded in 2018 with the vision of "realizing the coexistence of humanity and the earth." We utilize satellite data and AI technology to address global food crises and climate change challenges. Our core products - Actaba, Detaba, and Sagri - offer innovative...

  • Senior Data Modeller

    4 days ago

    Bengaluru, Karnataka, India PureSoftware Ltd Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Experience as a Data Modeler or Database Designer, with specific experience in the life insurance industry.Proficiency in Erwin Data Modeler for designing conceptual, logical, and physical data models.Strong SQL skills and experience working with relational databases (e.g., SQL Server, Oracle, DB2).Solid understanding of data modeling techniques, principles,...

  • Senior Data Scientist

    4 days ago

    Bengaluru, Karnataka, India Anicca Data Science Solutions Full time ₹ 1,20,000 - ₹ 3,60,000 per year

    Job Description – Senior Data ScientistLocation:Bengaluru (Full-time, Onsite)About Anicca DataAnicca Data is a leading team of Data Science and Technology experts specializing in:Personalization, Recommendation Engines, and Product Search RankingLoyalty Programs and Customer AnalyticsSupply Chain Optimization (Demand Forecasting, Inventory, Replenishment &...

  • Senior Associate Data Scientist

    1 week ago

    Bengaluru, Karnataka, India NTT DATA Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Make an impact with NTT DATAJoin a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society. Our workplace embraces diversity and inclusion – it's a place where you can grow, belong and thrive.Your day at NTT DATAThe Senior...

  • Data Modeler

    1 day ago

    Bengaluru, Karnataka, India Galaxy i technologies Inc Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Hi, Everyone******Contract to Hire******Contract to Hire*******100% Closure & Immediate Interview, SurelyJob Title: Data ModelerLoc: Pan India (Onsite)Job Description:Job Title: DeveloperWork Location: PAN Indiabut Preferably Mumbai, MH / Pune, MH / Hyderabad, TG / Bangalore, KA / Chennai, TNSkills Required: Data Concepts & Data Modelling, Data Architecture...

  • Senior Data Engineer- Data Modeler

    2 weeks ago

    Bengaluru, Karnataka, India Quantiphi Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Company Profile:Quantiphi is an award-winning Applied AI and Big Data software and services company, driven by a deep desire to solve transformational problems at the heart of businesses. Our signature approach combines groundbreaking machine-learning research with disciplined cloud and data-engineering practices to create breakthrough impact at...

  • Data Modeler

    5 days ago

    Bengaluru, Karnataka, India The Reliable Jobs Full time ₹ 8,00,000 - ₹ 24,00,000 per year

    About the Role : We are seeking a highly skilled and motivated Data Modeler with deep expertise in Cloud Data Platforms, SQL, Dimensional Modeling, and Performance Tuning to join our growing Data Engineering team. The ideal candidate will have experience in the Consumer-Packaged Goods (CPG) domain and a proven track record of designing scalable,...