Senior Data Modeler (DW/ Databricks)

MetLife
Bridgewater, NJ, United States
16 days ago
Apply on dejobs.org
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$115,000.0 - $154,000.0
Working hours
Regular working hours
Job source

Tech stack

Unity 3d Third Normal Form Data Architecture Data Dictionary Data Governance Data Profiling Data Vault Modeling Data Warehousing Relational Databases DevOps Dimensional Modeling Meta-Data Management
+17 more
NoSQL Oracle (Applications) Cloud Services SQL Databases Snowflake Generative AI Data Lakes Information Technology Data Lineage Collibra Data Analytics Star Schema Cosmos DB Data Management Physical Data Models Azure Synapse Analytics Databricks

Job description

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., * 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

Requirements

  • 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, * 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.

Benefits & conditions

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 [1] click here.

About the company

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., 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 [2] #AllTogetherPossible. Join us!

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on dejobs.org
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:37 min

Comparing traditional SQL tables versus NoSQL non-tabular databases

Stanimira Vlaeva · JS Congress

2:17 min

Mapping the maturity roadmap for scaled devops adoption

Dominik Krichbaum Dominik Krichbaum · World Congress 2026 Europe

2:36 min

Development tools for spatial computing and drones

Zaid Zaim Zaid Zaim · World Congress 2023

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

3:16 min

Terminology differences between relational and NoSQL databases

Tim Faulkes · LIVE

2:36 min

Integrating business experts and conceptualizing analytical use cases

Stefan Donsa Stefan Donsa +1 · LIVE

Videos

See all

Related articles

See all