Apply on Employer Site

Relanto · 3 days ago

Senior Data Modeler – Snowflake

United States

Full-time

Remote

Senior Level

5+ years exp

Relanto is seeking an experienced Data Modeler with strong expertise in Snowflake Data Cloud to design, optimize, and govern scalable data models. The role involves developing and maintaining data models that support analytics, reporting, and advanced data use cases.

Artificial Intelligence (AI)Digital Marketing

H1B Sponsor Likely

Responsibilities

Design, develop, and maintain conceptual, logical, and physical data models optimized for Snowflake

Implement dimensional (Star/Snowflake schema) and normalized data models to support analytics and reporting

Translate business and functional requirements into scalable, high-performance data models

Optimize Snowflake schemas for query performance, cost efficiency, and scalability

Define and enforce data modeling standards, naming conventions, and best practices

Partner with Data Engineers to guide table design, clustering strategies, and data partitioning approaches

Support data governance, metadata management, and data lineage initiatives

Perform impact analysis for schema changes and manage versioning of data models

Work closely with BI and Analytics teams to ensure models meet reporting and dashboarding needs

Participate in design reviews and provide recommendations on data architecture improvements

Qualification

SnowflakeData modelingSQLDimensional modelingETL/ELT pipelinesData warehousingData governanceData lineageData modeling toolsSupply chain knowledge

Required

Bachelor's or Master's degree in Computer Science, Information Systems, Data Engineering, or a related field

Must have minimum 5+ years of relevant experience

Strong experience in data modeling (conceptual, logical, physical)

Hands-on expertise with Snowflake including:

Schema design and optimization

Clustering and performance tuning

Understanding of micro-partitioning

Proficiency in SQL (advanced querying and optimization)

Experience with dimensional modeling

Knowledge of Supply chain/Demand Planning

Familiarity with ETL/ELT pipelines and integration with Snowflake

Experience using data modeling tools such as Erwin, ER/Studio, PowerDesigner, Lucidchart, or similar

Understanding of data warehousing, data lakes, and modern cloud data platforms

Company

Relanto

Relanto transforms enterprises with AI-enabled integrated planning, forecasting and digital innovation.

Founded in 2021

Seattle, Washington, USA

501-1000 employees

https://www.relanto.ai

H1B Sponsorship

Relanto has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (58)

2024 (70)

2023 (9)