Senior Data Modeler (DW/ Databricks)

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

At MetLife, data isn't just a tool - it is a catalyst for growth. As part of our Data & Analytics organization, you'll unlock trusted insights that drive bold decisions, power personalized customer experiences, and deliver lasting business impact. We're building the future of data - one that's governed responsibly, engineered for scalability, and designed for growth. When you join us, you're not just supporting the business - you're empowering it. Let's transform insight into impact and data into action, together.

The Opportunity

The Senior Data Modeler is responsible for translating business requirements into scalable conceptual, logical, and physical data models that support production-grade data and analytics solutions across MetLife's global Data & Analytics organization. This is an exciting opportunity to bring advanced data modeling expertise to enterprise-wide initiatives, working closely as part of a cross-functional team to build dimensional models directly within Databricks.

Key Responsibilities

• Translate business requirements into scalable conceptual, logical, and physical data model designs, including dimensional (star and snowflake) schemas built and deployed within Databricks Lakehouse environments
• Develop and optimize dimensional data models, data dictionaries, ER diagrams, and metadata/data catalog assets for performance, scalability, and deployment across on-premises and cloud platforms (Azure Synapse, Databricks, Delta Lake, Unity Catalog)
• Perform data profiling, validation, and lineage analysis to ensure model accuracy, consistency, and adherence to enterprise and industry-standard modeling best practices
• Contribute to design, solutioning, and estimation efforts for complex, enterprise-wide data initiatives as part of a collaborative data modeling team
• Collaborate with partners across Business, Technology, Operations, and Data & Analytics capabilities, including Data Governance, Data Quality, Data Architecture, Data Science, DevOps, and BI & Insights

Required Qualifications

• Bachelor's degree in computer science, Information Technology, or an equivalent field of experience
• 5-8+ years of experience in conceptual, logical, and physical data modeling, including advanced dimensional modeling (3NF, star schema, snowflake schema) and data vault modeling
• Hands-on experience building and optimizing star schemas and dimensional models within Databricks (Delta Lake, Unity Catalog, Databricks SQL or experience with similar technologies) to support enterprise analytics and reporting
• Proficiency with data modeling tools such as Erwin or ER/