Senior Data Modeler — Databricks Dimensional Architect

MetLife; New York (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

MetLife in New York seeks a Senior Data Modeler to translate business needs into scalable conceptual, logical, and physical data models. You’ll build dimensional models within Databricks and contribute to enterprise analytics across hybrid cloud environments.

You’ll partner with Data Governance, Architecture, and BI teams to ensure data quality, lineage, and cataloging while delivering production-grade data solutions that enable bold decisions and trusted insights across the organization.

Qualifications

• Bachelor's degree in computer science, Information Technology, or equivalent
• 5-8+ years of conceptual, logical, and physical data modeling with dimensional modeling and data vault
• Experience building star schemas and dimensional models within Databricks (Delta Lake, Unity Catalog)
• Proficiency with data modeling tools such as Erwin

Responsibilities

• Translate business requirements into scalable conceptual, logical, and physical data model designs, including dimensional (star and snowflake) schemas built within Databricks Lakehouse environments
• Develop and optimize dimensional data models, data dictionaries, ER diagrams, and metadata/catalog assets for performance and deployment across on-premises and cloud platforms
• Perform data profiling, validation, and lineage analysis to ensure model accuracy and consistency
• Contribute to design, solutioning, and estimation efforts for complex enterprise-wide data initiatives as part of a team
• Collaborate with partners across Business, Technology, Operations, and Data & Analytics capabilities

Skills

Dimensional modeling

Databricks

Delta Lake

Unity Catalog

Data profiling

Data lineage

ER diagrams

Collaboration with stakeholders

Education

Bachelor's degree in computer science or information technology

Tools

Erwin

Job description

MetLife in New York seeks a Senior Data Modeler to translate business needs into scalable conceptual, logical, and physical data models. You’ll build dimensional models within Databricks and contribute to enterprise analytics across hybrid cloud environments.

You’ll partner with Data Governance, Architecture, and BI teams to ensure data quality, lineage, and cataloging while delivering production-grade data solutions that enable bold decisions and trusted insights across the organization.