Description

You will lead data modeling efforts for the data warehouse infrastructure, designing logical and physical models for Snowflake and Data Mart layers.

This role is on-site.

Responsibilities

• Design logical and physical data models for Snowflake Data Warehouse and Data Mart layers.
• Develop dimension models utilizing SCD1, SCD2, and SCD3 techniques.
• Interpret schemas and analyze source payloads, including JSON and XML structures.
• Build and manage data pipelines using DBT.

Required Skills

• 12+ years of professional experience in data modeling.
• Expert proficiency in SQL.
• Strong experience with Snowflake data warehousing.
• Hands-on experience with DBT pipelines.
• Familiarity with data visualization tools like Power BI.
• Experience handling JSON and XML data structures.
• Knowledge of Data Warehouse design principles.
• Domain expertise in Workers Compensation (WC), Commercial Multi-Peril (CMP), Excess Surplus (ES), and Excess Casualty.

Key Skills

Education

Any Gradute