Job Description

Senior Data Modeler

We are seeking a highly skilled Senior Data Modeler to join our dynamic team. In this critical role, you will be responsible for designing, implementing, and maintaining data models that support our data lake infrastructure on Databricks. Your expertise in Data Vault 2.0, Delta Lake, and advanced SQL will be pivotal in delivering high-quality data models that drive business insights and decision-making. Ideal candidates will have a strong background in dimensional modeling, metadata lineage, and governance, particularly within the insurance and financial services domain. This position requires a professional with a decade of experience in data modeling and a deep understanding of data architecture and modeling tools.

Experience Required:

10+ years

Key Responsibilities:

• Design and implement complex data models using Databricks Lakehouse, Delta Lake, and Unity Catalog.
• Lead the implementation of Data Vault 2.0 methodology for robust data modeling.
• Develop and maintain dimensional models in Star and Snowflake schemas.
• Create Bronze, Silver, and Gold data models to ensure data quality and integrity.
• Ensure metadata and lineage documentation is up-to-date and accessible.
• Establish and enforce data governance policies and procedures.
• Collaborate with data engineers and analysts to integrate data models into broader data architecture.
• Support data architecture and modeling using ERwin, SQL Developer, and other related tools.
• Provide expertise and guidance on data architecture best practices within the insurance and financial services domain.
• Contribute to the continuous improvement of data modeling processes and tools.

Qualification Criteria:

• At least 10 years of experience in data modeling and architecture.
• Proven expertise in Data Vault 2.0 implementation and Databricks Lakehouse.
• Strong background in dimensional modeling and advanced SQL.
• Experience creating and managing Bronze, Silver, and Gold data models.
• Proficiency in metadata, lineage, and governance practices.
• Familiarity with the insurance and financial services domain.
• Experience with data modeling tools like ERwin, SQL Developer, and Databricks.
• Strong analytical skills to derive insights from complex data sets.
• Excellent communication and collaboration skills.
• Ability to work in a fast-paced, dynamic environment.

Primary Skills:

• Databricks
• Data Vault 2.0
• Dimensional Modeling

Key Skills:

• Delta Lake
• Unity Catalog
• Advanced SQL
• Metadata
• Lineage
• Governance
• Insurance
• Financial Services
• ERwin
• SQL Developer
• Data Architecture
• Data Modeling
• Microsoft SQL Server

Skills

DatabricksData Vault 2.0Dimensional Modeling