Senior Data Modeler (DW/ Databricks)

MetLife - Bridgewater, NJ

Hiring: Senior Data Modeler (DW/Databricks) Company: MetLife Location: Bridgewater, NJ (Hybrid – minimum 3 days per week in office) Job Posted Time: 2026-09-02 17:59:42 Employment Type: Full-time Target Skills & Keywords: Data Modeling, Dimensional Modeling, Databricks, Delta Lake, Unity Catalog, Star Schema, Snowflake Schema, Data Vault, 3NF, Erwin, ER/Studio, Azure Synapse, SQL, Oracle, Cosmos DB, Snowflake, Data Governance, Data Lineage, Collibra, Alation, MDM 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 - Ideally 8+ years of experience in Datawarehouse modeling - Hands-on experience building and optimizing star schemas and dimensional models within Databricks (Delta Lake, Unity Catalog, Databricks SQL or similar technologies) to support enterprise analytics and reporting - Proven experience mentoring project teams Required Skills: - 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 - Collaborate with partners across Business, Technology, Operations, and Data & Analytics capabilities, including Data Governance, Data Quality, Data Architecture, Data Science, DevOps, and BI & Insights - 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 Qualifications: - Bachelor's degree in Computer Science, Information Technology, or an equivalent field of experience - Data management/modeling certification (e.g., CDMP, Erwin certification) preferred - Experience with data cataloging and governance tools such as Collibra or Alation preferred - Experience with master data management (MDM) and data lineage frameworks preferred - Experience in B2B/Financial services/insurance domain with exposure to Generative AI technology and tools preferred Compensation: - Expected salary range: $115,000 – $154,000 - May also be eligible for annual short-term incentive Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don’t miss this opportunity to join a forward-thinking team!