Senior Data Modeler (DW/ Databricks)

MetLife; Bridgewater (MA); Hybrid; USD 115,000 - 154,000; Full time

Benefits offered by this job

Health plan

401(k) with employer matching

Paid time off

Job summary

MetLife’s Data & Analytics team seeks a Senior Data Modeler to translate business requirements into scalable data models and to build dimensional schemas within the Databricks Lakehouse. You will design conceptual, logical, and physical models for enterprise analytics and collaborate across business, technology, operations, and governance functions.

The role requires 5–8+ years of data modeling experience, expertise in star/snowflake schemas and data vaults, and hands-on Databricks/Delta Lake

Qualifications

• Bachelor's degree in a relevant field is required.
• 5-8+ years of data modeling experience incl. dimensional modeling and data vault.
• Hands-on Databricks and cloud platforms like Azure Synapse or Snowflake are required.

Responsibilities

• Translate business requirements into scalable data models (conceptual, logical, physical).
• Develop and optimize dimensional models, data dictionaries, ER diagrams, and metadata assets.
• Profile, validate, and lineage analytics to ensure model accuracy and consistency.
• Collaborate with Business, Technology, Operations, and Data & Analytics teams.

Skills

Data modeling

Dimensional modeling

Databricks

Azure Synapse

Communication skills

Mentoring

Education

Bachelor’s degree in Computer Science or related field

Tools

Erwin

ER/Studio

SQL/NoSQL

Databricks SQL

Unity Catalog

Delta Lake

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

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.

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 click here.

About MetLife

Recognized on Fortune magazine’s list of the "World's Most Admired Companies", Fortune World’s 25 Best Workplaces™, as well as the Fortune 100 Best Companies to Work For®, MetLife, through its subsidiaries and affiliates, is one of the world’s leading financial services companies; providing insurance, annuities, employee benefits and asset management to individual and institutional customers. With operations in more than 40 markets, we hold leading positions in 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 purpose is simple - to help our colleagues, customers, communities, and the world at large create a more confident future. United by purpose and guided by our core values - Win Together, Do the Right Thing, Deliver Impact Over Activity, and Think Ahead - we’re inspired to transform the next century in financial services. 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.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liabilities.

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