Talent.com
Delphi - Data Modeller - Synapse Analytics

Delphi - Data Modeller - Synapse Analytics

DelphiIndia
4 days ago
Job description

About the Role :

We are seeking an experienced Data Modeler to join our team. The ideal candidate will have a strong background in conceptual, logical, and physical data modeling, as well as experience with master data management, normalization, denormalization, and dimensional modeling. This role will be responsible for designing, optimizing, and managing data models to ensure integrity, consistency, and efficiency of data within the organization.

What Youll Do :

Data Modeling & Design :

  • Design and implement conceptual, logical, and physical data models to meet business requirements.
  • Apply ER (Entity-Relationship) modeling techniques to develop clear and structured data models.
  • Apply normalization and denormalization principles to optimize data storage and retrieval.
  • Develop master data models and participate in Master Data Management (MDM) processes.

Dimensional Modeling & Optimization :

  • Create and optimize star and snowflake schema designs for high-performance data warehouse systems.
  • Design fact and dimension tables to support data analytics and business intelligence solutions.
  • Data Quality & Lineage :

  • Ensure the accuracy, consistency, and completeness of data models.
  • Implement data cataloging strategies, track data lineage, and conduct impact analysis to support data governance practices.
  • SQL Query Optimization :

  • Write and optimize complex SQL queries to extract, transform, and load (ETL) data.
  • Collaborate with developers to ensure efficient data querying and performance optimization.
  • Collaboration & Stakeholder Engagement :

  • Work closely with data analysts, engineers, and business stakeholders to understand data requirements and ensure data models meet business needs.
  • Provide insights on how data modeling can support analytical capabilities and decision-making.
  • What Youll Bring :

  • Bachelors or masters degree in computer science, Information Systems, Data Science, or a related field.
  • Proven experience with conceptual, logical, and physical data models.
  • Strong knowledge of ER modeling and principles of normalization and denormalization.
  • Experience in Master Data Management (MDM) and managing master data domains.
  • Expertise in dimensional modeling, particularly in creating star and snowflake schemas.
  • Experience in developing fact and dimension tables for data warehouses.
  • Ability to write and optimize complex SQL queries for data extraction and analysis.
  • Familiarity with data cataloging, lineage tracking, and impact analysis.
  • Experience with data governance and best practices in data modeling.
  • Familiarity with data modeling tools such as Erwin, IBM Infosphere Data Architect, or Microsoft Visio.
  • Experience with database platforms like SQL Server, Oracle, or PostgreSQL.
  • Familiarity with data warehousing concepts and platforms (e.g., Azure Synapse, Snowflake, etc.).
  • Strong analytical and problem-solving skills.
  • Excellent communication and collaboration skills to work with cross-functional teams.
  • Detail-oriented with a strong focus on data accuracy and optimization.
  • Ability to adapt to changing business needs and data requirements.
  • (ref : hirist.tech)

    Create a job alert for this search

    Data Data • India

    Related jobs
    • Promoted
    Big Data Developer (Hive, Pyspark)

    Big Data Developer (Hive, Pyspark)

    Tata Consultancy Servicesnagpur, maharashtra, in
    Big Data Developer (Hive, Pyspark).Years of Experience : 4 to 10 yrs.Date of Interview : 5th Nov, 2025.Mode of Interview : Virtual Drive(Cisco or Webex). Hands-on experience of Hadoop, Python, PySpark,...Show moreLast updated: 18 days ago
    • Promoted
    ML Ops

    ML Ops

    EXLNagpur, IN
    Deploy, monitor, and scale ML models on.GCP (Vertex AI, GKE, Cloud Functions).GitHub Actions / Jenkins / cloud-native tools. Containerize and orchestrate workloads with.MLflow, Feast, Prometheus / Gra...Show moreLast updated: 30+ days ago
    • Promoted
    ETL & Tableau Data Engineer

    ETL & Tableau Data Engineer

    Magma ConsultancyNagpur, IN
    ETL & Tableau Data Engineer (Remote | Full-Time | Join in 2 Weeks).We are a forward-thinking technology and data consulting firm dedicated to helping organizations unlock the full potential of thei...Show moreLast updated: 2 days ago
    • Promoted
    Model Validation

    Model Validation

    Tata Consultancy ServicesIndia
    Year of Experience- 6 to 15 Years.Location-Bangalore, Hyderabad, Chennai, Pune, Kolkata.As a Senior Quantitative Analytics Associate, you will be responsible for leading independent validations and...Show moreLast updated: 3 days ago
    • Promoted
    Data Scientist

    Data Scientist

    upGrad RekrutNagpur, IN
    You will work on end-to-end data-driven solutions — from data cleaning to model deployment — enabling key insights for strategic decisions. Analyze large, complex datasets to extract meaningful busi...Show moreLast updated: 9 days ago
    • Promoted
    Looker Developer

    Looker Developer

    RiDiK (a Subsidiary of CLPS. Nasdaq : CLPS)nagpur, maharashtra, in
    We are looking for a skilled BI Developer to support a large client in the Healthcare domain.The role will involve enhancing and maintaining reports using Looker / LookML, developing dimensional data...Show moreLast updated: 18 days ago
    • Promoted
    Data Modeler With Snowflake-Contract

    Data Modeler With Snowflake-Contract

    Gravity Infosolutions, Inc.Republic Of India, IN
    Hyderabad / Bangalore / Pune / Chennai.Expertise in identifying and designing data relationships between.Hands-on experience in Data Vault 2. Ability to collaborate with cross-functional teams to ensure d...Show moreLast updated: 28 days ago
    • Promoted
    Data Modeler

    Data Modeler

    StratusIndia, India
    Lead a team of data engineers to develop data analytic solutions such as data warehouse and data marts on Azure Databricks. Experience with Agile development methodologies and tools, such as Jira, t...Show moreLast updated: 9 days ago
    • Promoted
    MLOps Engineer

    MLOps Engineer

    Capgemininagpur, maharashtra, in
    Experience in developing MLOps framework cutting ML lifecycle : model development, training, evaluation, deployment, monitoring including Model Governance. Expert in Azure Databricks, Azure ML, Unity...Show moreLast updated: 16 days ago
    • Promoted
    Snowflake Data Modeller / DBA

    Snowflake Data Modeller / DBA

    ConfidentialIndia
    We are hiring a dedicated Snowflake DBA with 3-5 years of experience to manage and optimize our Snowflake data platform on Azure. In this role, you will handle day-to-day administration, performance...Show moreLast updated: 22 days ago
    • Promoted
    Senior Data Architect- Snowflake

    Senior Data Architect- Snowflake

    USEReadyNagpur, IN
    USEReady is a data and analytics firm that provides the strategies, tools, capability, and capacity that businesses need to turn their data into a competitive advantage. USEReady partners with cloud...Show moreLast updated: 2 days ago
    • Promoted
    LLM Scientist

    LLM Scientist

    Insight GlobalIndia, India
    Familiarity with LangSmith, LangFuse, or similar LLM monitoring tools.Show moreLast updated: 5 days ago
    • Promoted
    LLM Research Data Scientist

    LLM Research Data Scientist

    Innodata Inc.Nagpur, IN
    Location- Remote Job(Full Time).Master's degree in Data Science, computer Science or a related field.High proficiency with AI tools (e. Copilots, GenAI platforms) and applying them to complex real-w...Show moreLast updated: 30+ days ago
    • Promoted
    Data Modeler

    Data Modeler

    AscendionPune, Republic Of India, IN
    The Principal Data Modeler / Architect will lead a critical database modernization initiative to reverse engineer, redesign, and normalize our existing OLTP data architecture.This role requires a sea...Show moreLast updated: 11 days ago
    • Promoted
    Data Modeler with Snowflake-Contract

    Data Modeler with Snowflake-Contract

    Gravity Infosolutions, Inc.India, India
    Hyderabad / Bangalore / Pune / Chennai.Expertise in identifying and designing data relationships between.Hands-on experience in Data Vault 2. Ability to collaborate with cross-functional teams to ensure d...Show moreLast updated: 28 days ago
    • Promoted
    Data Integration Developer (Level 1)

    Data Integration Developer (Level 1)

    BluticNagpur, IN
    Data Integration Developer (Level 1).ETL processes and reports using.This entry-level role is ideal for developers looking to grow their skills in enterprise data solutions while contributing to cr...Show moreLast updated: 9 days ago
    • Promoted
    Data Modeler

    Data Modeler

    Best Infosystems Ltd.Pune, Republic Of India, IN
    Data Modeler_Full-Time_Pune / Bangalore (Hybrid, 3 Days WFO).Pune / Bangalore (Hybrid, 3 Days WFO).Creation and management of business data models in all their forms, including conceptual models, log...Show moreLast updated: 30+ days ago
    • Promoted
    ATOM Systems - Data Modeler Consultant

    ATOM Systems - Data Modeler Consultant

    ATOM Systems Private Limited, India
    Job Description Name of the position : Data Modeler Consultant Location : Remote of resources needed : 03 Mode : Cont...Show moreLast updated: 30+ days ago