Job Description

Senior Data Modeler

We are seeking an experienced Senior Data Modeler to join our dynamic team in the Insurance/Financial Services domain. In this role, you will design, develop, and manage complex data models using Databricks, focusing on Data Vault 2.0 and Lakehouse architecture. Your expertise will drive data governance, metadata lineage, and advanced SQL capabilities to support our data-driven decision-making processes. This position demands a deep understanding of dimensional modeling and hands-on experience with tools like Databricks, Delta Lake, and Unity Catalog.

Experience Required:

10+ years

Key Responsibilities:

• Design and implement advanced data models using Databricks.
• Specialize in Data Vault 2.0 for robust data architecture.
• Develop and manage Delta Lake and Unity Catalog environments.
• Create dimensional models in Star and Snowflake schemas.
• Ensure advanced SQL queries optimize data retrieval and performance.
• Build and maintain Bronze, Silver, and Gold data models.
• Implement data governance, metadata, and lineage practices.
• Collaborate with cross-functional teams to define data requirements.
• Leverage ERwin and SQLDBMER Studio for data modeling documentation.
• Stay updated with industry trends to enhance data modeling strategies.

Qualification Criteria:

• Minimum of 10 years of experience in data modeling.
• Strong implementation experience with Data Vault 2.0.
• Hands-on experience with Databricks, Delta Lake, and Unity Catalog.
• Extensive knowledge of dimensional modeling techniques.
• Advanced SQL skills for creating efficient data queries.
• Proficiency in creating Bronze, Silver, and Gold data models.
• Expertise in data governance, metadata, and lineage.
• Experience in the Insurance/Financial Services domain.
• Experience with ERwin and SQLDBMER Studio.
• Strong analytical and problem-solving skills.

Primary Skills:

• Databricks
• Data Vault 2.0
• Dimensional Modeling

Key Skills:

• Delta Lake
• Unity Catalog
• Advanced SQL
• Metadata
• Data Governance
• Insurance/Financial Services
• ERwin
• SQLDBMER Studio
• Data Architecture
• Data Modeling
• SQL Server