Snowflake Data Modeler

  • Posted 13 hours ago | Updated 13 hours ago

Overview

Remote
Depends on Experience
Contract - W2

Skills

Data Modeler

Job Details

10+ years of experience in data modeling, data architecture, or data engineering roles.

4+ years of experience modeling data in Snowflake or other cloud data warehouses.

Strong understanding and hands-on experience with Medallion Architecture and modern data platform design.

Experience using data modeling tools (Erwin etc.).

Proficiency in data modeling techniques: 3NF, dimensional modeling, data vault, and star/snowflake schemas.

Expert-level SQL and experience working with semi-structured data (JSON, XML).

Familiarity with Azure data services (ADF, ADLS, Synapse, Purview)

Key Responsibilities:

Design, develop, and maintain data models that meet data processing, analytics, and reporting needs, with a specific focus on Snowflake data warehousing.

Lead the design and implementation of logical, physical, and canonical data models across enterprise data domains in Snowflake.

Architect data models for Bronze, Silver, and Gold layers as per the Medallion Architecture, ensuring performance, modularity, and reusability.

Collaborate with data architects, engineers, and business analysts to translate business needs into scalable data models.

Drive data model governance, including standards, documentation, versioning, and review processes.

Conduct data profiling and gap analysis between source systems and target models.

Participate in data integration efforts by providing source-to-target mappings and defining transformation rules.

Build data model to support time travel kind of reporting

Ensure compliance with data governance, data quality, and data security requirements.

Build models to support operational & analytical reports

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.