Snowflake Data Modeler

  • Buffalo, NY
  • Posted 1 day ago | Updated 1 day ago

Overview

On Site
Depends on Experience
Full Time
Able to Provide Sponsorship

Skills

Snowflake Data Modeler
Data Modeler
dimensional modeling
star/snowflake schemas
third normal form
Architecture
Azure Cloud

Job Details

Position: Snowflake Data Modeler

Location: Buffalo, NY
Full Time / Permanent Hire
Salary: Negotiable

Job Description:

Multiple years of experience in data modeling with at least 2+ years working with Snowflake
Strong expertise in dimensional modeling, star/snowflake schemas, third normal form (3NF), and denormalized structures
Design and implement conceptual, logical, and physical data models in Snowflake.
Experience with data modeling tools such as Erwin, ER/Studio
Translate business requirements into efficient and optimized data structures and schemas.
Collaborate with data architects and data engineers to align models with ETL/ELT pipelines and integration strategies.
Define and manage data modeling standards, naming conventions, and metadata documentation.
Develop data dictionaries, ER diagrams, and data lineage artifacts.
Ensure data models are optimized for performance, storage, and maintainability in the Snowflake environment.
Understanding of Azure cloud platforms
Partner with BI/Analytics teams to support reporting and dashboarding needs.
Participate in data governance and data quality efforts across the organization

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.

About Benvia