DB DATA MODELLER

Mphasis

New York (NY)

On-site

USD 120,000 - 180,000

Full time

2 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Mphasis is seeking a Senior DB Data Modeller in New York with 10+ years translating complex requirements into scalable data models. You will develop conceptual, logical, physical, dimensional, canonical and semantic models for operational, analytical and AI-ready platforms within Insurance and Benefits Management contexts.

You will collaborate with analysts, data owners and architects to define entities, mappings and governance, and to support ETL/ELT and API integrations, ensuring data quality

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.

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.

Skills

Conceptual data modelling
Logical data modelling
Physical data modelling
Dimensional modelling
Relational modelling
Canonical & semantic models
SQL
Data profiling
Master data management
Delta Lake / Azure Databricks
Power BI semantic models
ETL/ELT mappings
ER modeling
Git / Jira / Azure DevOps

Education

Bachelor’s degree in Computer Science / Information Technology / Data Engineering
Data-modelling certification (preferred)

Tools

ERwin
ER/Studio
SAP PowerDesigner
Visio
Git
Jira
Azure DevOps

Job description

Conceptual | Logical | Physical | Dimensional | Semantic Data Modelling

Experience

10+ years

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Manager - Data Engineering
Manager - Data Engineering

Mphasis • New York (NY)

On-site
USD 85,000 - 165,000
Data Warehouse Data Modeler
Data Warehouse Data Modeler

JPS Tech Solutions • Iowa

On-site
USD 120,000 - 170,000
Data Modeler
Data Modeler

Quantum Technologies LLC • New York (NY)

On-site
USD 110,000 - 150,000
Data Modeler
Data Modeler

Robotics Technologies LLC • New York (NY)

On-site
USD 120,000 - 170,000
Data Modeler
Data Modeler

Valiant Technologies LLC • New York (NY)

On-site
USD 120,000 - 170,000
Data Modeler
Data Modeler

Ethereum Technologies LLC • New York (NY)

On-site
USD 120,000 - 180,000
Data Modeler
Data Modeler

Robotic Process Automation LLC • New York (NY)

On-site
USD 120,000 - 190,000
Enterprise Data Architect
Enterprise Data Architect

TechDigital Group • Alpharetta (GA)

On-site
USD 140,000 - 190,000
Architect
Architect

Virtusa Corporation • Minneapolis (MN)

On-site
USD 110,000 - 140,000
Senior Ontology Data Modeler
Senior Ontology Data Modeler

Veriipro • West Des Moines (IA)

On-site
USD 110,000 - 170,000