Senior Snowflake Developer and Data Modeler

USEReady; Dallas (TX); On-site; USD 90,000 - 150,000; Full time

Job summary

An established industry player is seeking a Senior Snowflake Developer and Data Modeler to join its Business Intelligence team. This role involves designing and optimizing Snowflake data solutions to enhance data warehousing and analytics initiatives. The ideal candidate will have extensive experience in Snowflake, SQL, and data modeling, along with a proven track record in implementing Data Vault methodologies. Join a dynamic team where your expertise will drive impactful data solutions, ensuring high performance and security in a fast-paced environment. This is a fantastic opportunity to contribute to innovative data projects in a collaborative setting.

Qualifications

• 5+ years of experience with Snowflake as a developer or data engineer.
• Advanced knowledge in SQL, CDC, SnowSQL, and performance tuning.

Responsibilities

• Design and develop scalable Snowflake data warehouses and ETL pipelines.
• Collaborate with teams to define data solutions and ensure data security.

Skills

Snowflake

SQL

Data Vault 2.0

ETL Processes

Python

Kafka

Data Modeling

Problem-Solving

Education

Data Vault Certification

Snowflake Certifications (SnowPro Core, SnowPro Advanced)

Tools

SnowSQL

AWS

Azure

GCP

DBT

Job description

Senior Snowflake Developer and Data Modeler

Direct message the job poster from USEReady

Job Title: Senior Snowflake Developer and Data Modeler

Duration: 12 Months Contract

Note:

Candidates beyond general Data and Snowflake expertise/experience, the candidate must:

• Have expertise/experience with Data Vault, not just theoretical, but actual use. As data modeling is part of the role, the candidate should already have their Data Vault certification.
• While it is beneficial for the candidate to have knowledge of different toolsets that integrate with Snowflake, it is a requirement that the candidate have expertise/experience using the native Snowflake tools.
• Understanding the Azure toolsets would be a plus, but not a must.

Job Description:

Seeking a highly skilled Senior Snowflake Developer and Data modeler to join the Business Intelligence and Data Warehousing team. The ideal candidate will have extensive experience in Snowflake Cloud Data Platform, Data modeling, ETL processes, and SQL development. This role will be responsible for designing, modeling, developing, and optimizing Snowflake solutions to support data warehousing, reporting, and analytics initiatives.

Responsibilities:

• Design, model and develop scalable Snowflake data warehouses and optimize performance
• Implement data ingestion, transformation, and ETL pipelines using Snowflake, SQL, and Python
• Develop stored procedures, functions, and views to support business intelligence and reporting
• Optimize Snowflake performance by using best practices such as clustering, caching, and partitioning
• Integrate Snowflake with cloud platforms (AWS, Azure, GCP) and third-party tools
• Collaborate with data engineers, analysts, and business teams to define data solutions
• Ensure data security, access control, and compliance within Snowflake
• Collaborate with IT Security team to implement Business Continuity and Disaster Recovery process

Must-have Requirements:

• At least 5 years of experience working with Snowflake as a developer or data engineer
• Advanced knowledge in SQL, CDC, SnowSQL, Snow Pipes, Streams, Tasks, Stored procedures, Functions
• Proven track record of implementing Data Vault 2.0 methodology in Snowflake along with developing conceptual, logical and physical data models and ERDs
• Knowledge of Real-time or Near-real-time streaming data using Kafka with Snowpipe
• Knowledge of Cloud platforms (AWS, Azure, or GCP) and data integration
• Experience with performance tuning, indexing, and query optimization in Snowflake
• Strong problem-solving skills and ability to work in agile environments

Preferred Requirements:

• Snowflake certifications (SnowPro Core, SnowPro Advanced)
• Experience with CI/CD pipelines and DevOps practices for Snowflake
• Knowledge of DBT is a plus
• Snowflake Admin experience is preferred

Vimal Charan

Phone: [phone] | Mob: [phone]

Seniority level

• Director

Employment type

• Contract

Job function

• Consulting

Industries

• Data Infrastructure and Analytics