Find your next job. Start today.

From the employer's own careers site

Lead Data Engineer

Date Posted: Oct 21, 2026
Apply on company website
Sign in to keep track of your applications.
Get jobs like this sent to you
Your own AI Job Agent checks every new job against your CV and sends only the ones that fit, on WhatsApp. ₹199 a month, GST included. Full refund if it does nothing.
Start my Job Agent on WhatsApp

Job Detail

  • location_on
    Location Hyderabad, Telangana, India
  • desktop_windows
    Job Type: Full Time/Permanent
  • schedule
    Shift:
  • analytics
    Career Level:
  • group
    Positions:
  • calendar_view_day
    Experience:
  • male
    Gender: No Preference
  • school
    Degree:
  • calendar_month
    Apply Before: Dec 30, 2026

Job Description

JOB DESCRIPTION - DB DATA MODELLER

Conceptual | Logical | Physical | Dimensional | Semantic Data Modelling

Experience

10+ years

Role Level

Senior DB Data Modeller

Primary Focus

Enterprise and Analytical Data Models

Domain

Insurance and Benefits Management

Role Summary

Seeking a Senior DB Data Modeller with 10+ years of experience translating complex business requirements into scalable, governed and implementation-ready data models. The role will develop conceptual, logical, physical, dimensional, canonical and semantic models for operational, analytical and AI-ready platforms, supported by Insurance and Benefits Management domain experience.

Key Responsibilities

  • Create and maintain conceptual, logical and physical data models for transactional databases, data warehouses and Lakehouse platforms.
  • Design normalized relational models and dimensional star/snowflake schemas for operational reporting, analytics, BI and AI use cases.
  • Define canonical models for benefits, employer, client, plan, member, enrollment, policy, premium, claims, renewal and carrier data.
  • Work with business analysts, data owners and architects to identify entities, attributes, relationships, cardinality, keys and business rules.
  • Develop source-to-target mappings, transformation rules and model specifications for ETL/ELT and API integration teams.
  • Perform data profiling and SQL analysis to validate source structures, model assumptions, referential integrity and data quality.
  • Define naming standards, data types, domains, reference data, slowly changing dimensions, effective dating and history patterns.
  • Maintain data dictionaries, model metadata, business definitions, lineage and traceability through governed repositories and catalogues.
  • Conduct model reviews with architects, DBAs, engineers, BI teams and business stakeholders; resolve duplication and semantic conflicts.
  • Support physical implementation, indexing, partitioning, query-performance tuning, model versioning, release impact analysis and production issue resolution.

Mandatory Technical Skills

Conceptual, logical and physical data modelling; relational and dimensional modelling; normalization and denormalization; star and snowflake schemas; entity-relationship modelling; canonical and semantic models; master and reference data; data profiling and source-to-target mapping; advanced SQL; PostgreSQL, SQL Server, Oracle or comparable relational databases; data-warehouse and Lakehouse modelling; Delta Lake and Azure Databricks concepts; Power BI semantic models; metadata, lineage and business glossary; data quality and reconciliation; model versioning and change control; ERwin, ER/Studio, SAP PowerDesigner, Visio or comparable modelling tools; Git, Jira or Azure DevOps; Agile delivery practices.

Experience and Qualifications

  • 10+ years of experience in data modelling, database design, data warehousing, data architecture or enterprise data management.
  • Proven experience delivering conceptual, logical and physical models for complex enterprise and analytical solutions.
  • Strong hands-on SQL, data profiling, mapping, dimensional modelling and relational database-design experience.
  • Experience collaborating with business, architecture, database, data-engineering, BI, governance and testing teams.
  • Experience implementing modelling standards, model governance, documentation and design-review controls.
  • Bachelor’s degree in Computer Science, Information Technology, Data Engineering or a related discipline; relevant data-modelling certification is preferred.

Domain Experience

  • Insurance or employee-benefits experience across employer, client, plan, member, eligibility, enrollment, policy, carrier, premium, claims and renewal data.
  • Understanding of sensitive and regulated information, employer-level isolation, effective dating, auditability and governed metric definitions.
  • Experience modelling canonical benefits data, certified metrics and semantic structures for role-based BI or natural-language analytics is advantageous.

Core Competencies

Structured data thinking, analytical problem-solving, business-to-technical translation, model precision, documentation discipline, stakeholder facilitation and the ability to balance consistency, performance, scalability, governance and implementation practicality.

Source: Mphasis careers — Read the original posting and apply

This role is listed by the employer on its own careers site. Kaam Ki Khoj does not process applications for it.

See how well you match this job

Make a free profile in a minute — no CV needed — and we score every job against it.

Make my profile

Already registered? Sign in

Company Overview

Mphasis
Mphasis · Bengaluru, Karnataka, India
97 open roles

Mphasis is an employer in the IT/Computers - Software, Software Services sector with operations in India. This is a directory listing maintained by Kaam Ki Khoj so that candidates can find the organisation; it is not an official company page and Kaam... Read More

Apply safely

From the employer's own careers site. Kaam Ki Khoj reads this job from mphasis.ripplehire.com. You apply there, on the employer's own website.

Applying is free. A genuine employer never asks you to pay: no registration fee, deposit, training fee or kit charge, and never your OTP or bank PIN. If anyone asks for money for this job, it is a scam.

How to spot a fake job · Check an offer free

Report this job

Related Jobs

One upload, every employer

Let the right employer find you

Upload your CV once — we read it, build your profile and put you in front of every employer hiring on Kaam Ki Khoj. No forms, no fees.

Upload your CV Browse jobs