2,354,452open jobs
147,370companies
283,382added this week
Browse all
Location
In office (New York)
Seniority
Staff · 10+ years exp
Visa
H-1B filings in 12 months: 1,327 · for this role: 11 · green card filings: 215

Confirmed on the employer's own hiring board on Nov 17, 2026. First seen by Alion on Oct 21, 2026. Mphasis scores B on the Alion truth index.

Overview
Company
Impact
Profile match
Mphasis is an Indian IT services and consulting company headquartered in Bengaluru, providing application development and maintenance, cloud and infrastructure services, data and AI, cybersecurity, DevOps and business process services. Its clients are concentrated in banking, capital markets and insurance, alongside healthcare, logistics, travel and technology firms, and Blackstone has been its majority shareholder since buying the stake of Hewlett Packard Enterprise in 2016, with subsidiaries including Blink UX and Datalytyx. Hiring covers software and AI engineers, data architects, cloud and infrastructure engineers, cybersecurity specialists, project leads, testers and support staff.

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.

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,354,452 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Leadership
Remote, many countries
Similar stack
Same company
New York
Engineering Manager 3 hours ago
$240k – $280k per year · In office · Full-Time · 3+ years exp · United States
TypeScript
C#
Databases
PostgreSQL
Redis
Apache Kafka
DevOps
AWS
Amazon S3
Wi-Fi
Apply
$128k – $214k per year · Hybrid · Full-Time · 10+ years exp · Bachelor's Degree · Wilmington
DevOps
Azure
Management
Scrum
Apply
$124k – $207k per year · In office · Lake Forest
Databases
Databricks
AI/ML
Airflow
AI Agents
Machine Learning
DevOps
GitHub Actions
CI/CD
AWS
Docker
Kubernetes
Amazon EKS
AWS Lambda
Amazon S3
IAM
Apply
Tech Lead Manager 5 hours ago
Hybrid · Full-Time · 8+ years exp · San Francisco
AI/ML
Fine-tuning
Reinforcement Learning
Function Calling
AI Agents
Synthetic Data
PPO
Post-training
Human-in-the-Loop
Structured Outputs
Knowledge Graph
Machine Learning
Apply
$165k – $189k per year · Hybrid · Full-Time · Brooklyn
Python
Go
TypeScript
AI/ML
Copilot
Claude Code
AI Agents
DevOps
Terraform
Azure
CI/CD
AWS
Cybersecurity
SOC 2
FedRAMP
Apply
Remote (likely EAEU) · Full-Time · 6+ years exp · Moscow
Java
SQL
C++
C++
Protobuf
DevOps
Amazon S3
Linux
Apply
Remote (EMEA) · United Kingdom
DevOps
AWS
Amazon S3
HPC
Apply
Head of SRE 1 day ago
Remote (EAEU) · Full-Time · Moscow
PHP
Databases
PostgreSQL
Apache Kafka
DevOps
CI/CD
Kubernetes
Error Budget
SLI/SLO/SLA
Linux
Apply
Remote (EAEU) · Bachelor's Degree · Moscow
AI/ML
Cursor
Claude
Claude Code
DevOps
GitLab
Apply
up to $93k per year (net) · Remote (EAEU) · Almaty
Java
DevOps
CI/CD
Kubernetes
Management
Agile
Apply
$90k – $149k per year · Hybrid · Full-Time · 9+ years exp · Bachelor's Degree · Buffalo · Baltimore · Wilmington · New York · Bridgeport
Apply
$174k – $261k per year · Equity · In office · Full-Time · 8+ years exp · Pleasanton · Denver · Frisco · Boston · Atlanta
DevOps
GCP
AWS
Apply
In office · Bachelor's Degree · New York
Apply
Remote (United States) · Full-Time · 3+ years exp · Bachelor's Degree · New York
DevOps
GCP
Azure
AWS
Linux
Windows
Apply
In office · Full-Time · 3+ years exp · New York
Apply
See all jobs
This is one of many
2,354,452 more open roles from verified company boards, updated every day.