Senior Data Modeler (DW/ Databricks)

MetLif; Bridgewater Township (NJ); Hybrid; USD 115,000 - 154,000; Full time

Job summary

MetLife is seeking a Senior Data Modeler to translate business requirements into scalable data models within the Databricks lakehouse. The role designs and optimizes dimensional models (star and snowflake), contributes to data dictionaries, and collaborates with cross-functional teams to deliver enterprise analytics.

The hybrid role requires 3 days in the office in New Jersey. If you have 5–8+ years of data modeling and hands-on Databricks experience, this is a compelling opportunity with strong

Qualifications

• Bachelor’s degree in computer science, IT, or equivalent
• 5-8+ years in data modeling (conceptual to physical) incl. dimensional modeling
• Hands-on Databricks experience building star/snowflake schemas for analytics
• Proficiency with Erwin or ER/Studio, SQL/NoSQL, cloud platforms (Azure Synapse, Databricks, Cosmos DB, Snowflake)
• Strong communication, analytical, storytelling, and stakeholder engagement; mentoring experience

Responsibilities

• Translate business requirements into scalable data models for enterprise analytics
• Develop dimensional models and metadata assets for performance and deployment
• Perform data profiling, validation, and lineage analysis
• Contribute to design, solutioning, and estimation for enterprise data initiatives
• Collaborate with Business, Technology, Operations, and Data & Analytics teams

Skills

Data modeling experience

Dimensional modeling

Databricks experience

SQL/NoSQL

Education

Bachelor’s degree in Computer Science or Information Technology

Tools

Erwin

ER/Studio

Azure Synapse

Databricks Delta Lake

Unity Catalog

Databricks SQL

Cosmos DB

Snowflake

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/Studio, SQL/NoSQL schema design, relational databases (SQL, Oracle), and cloud data platforms (Azure Synapse, Databricks, Cosmos DB, Snowflake)
• Strong communication, analytical, storytelling, and stakeholder engagement skills, with proven experience in mentoring project teams

Preferred Qualifications

• Ideally 8+ years of experience in Datawarehouse modeling.
• Data management/modeling certification (e.g., CDMP, Erwin certification) and experience with data cataloging and governance tools such as Collibra or Alation
• Experience with master data management (MDM), and data lineage frameworks
• Experience in B2B/Financial services/insurance domain with exposure to Generative AI technology and tools

Benefits We Offer

Our U.S. benefits address holistic well-being with programs for physical and mental health, financial wellness, and support for families. We offer a comprehensive health plan that includes medical/prescription drug and vision, dental insurance, and no-cost short- and long-term disability. We also provide company-paid life insurance and legal services, a retirement pension funded entirely by MetLife and 401(k) with employer matching, group discounts on voluntary insurance products including auto and home, pet, critical illness, hospital indemnity, and accident insurance, as well as Employee Assistance Program (EAP) and digital mental health programs, parental leave, paid time off, paid holidays, volunteer time off, tuition assistance and much more! For more information regarding MetLife’s U.S. benefits, please.

Location Expectation: This is a hybrid role requiring a minimum of 3 days per week in office.

The expected salary range for this position is $115,000 - $154,000. This role may also be eligible for annual short-term incentive compensation and stock-based long-term incentives. All incentives and benefits are subject to the applicable plan terms.

About MetLife

Recognizedon Fortune magazine's list of the "World's Most Admired Companies",Fortune World’s 25 Best Workplaces™, as well as the Fortune 100 Best Companiesto Work For®, MetLife, through its subsidiaries and affiliates, is one of theworld’s leading financial services companies; providing insurance, annuities,employee benefits and asset management to individual and institutionalcustomers. With operations in more than 40 markets, we hold leading positionsin the United States, Latin America, Asia, Europe, and the Middle East.

As part of our New Frontier strategy, MetLife is building an AI-enabled, people-centered future. We’re looking for people who bring curiosity, adaptability, and a growth mindset as we use AI to enhance how we serve customers, support communities, and evolve the way work gets done. At MetLife, AI is a responsible partner that supports human judgment, creativity, and continuous improvement while helping us build trust, inclusion, and long-term value.

Our purposeis simple - to help our colleagues, customers, communities, and the world atlarge create a more confident future. United by purpose and guided by our corevalues - Win Together, Do the Right Thing, Deliver Impact Over Activity, andThink Ahead - we’re inspired to transform the next century in financialservices. At MetLife, it’s #AllTogetherPossible . Join us!

MetLife is an Equal Opportunity Employer. All employment decisions are made without regards to race, color, national origin, religion, creed, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity or expression, age, disability, marital or domestic/civil partnership status, genetic information, citizenship status (although applicants and employees must be legally authorized to work in the United States), uniformed service member or veteran status, or any other characteristic protected by applicable federal, state, or local law (“protected characteristics”). If you need an accommodation due to a disability, please email us at [e-mail]. This information will be held in confidence and used only to determine an appropriate accommodation for the application process. MetLife maintains a drug-free workplace.

This posting is for a current vacancy and is anticipated to remain open for at least 90 days from the listed posting date.