Senior Snowflake Developer Data Engineer with Data Vault

Overview

On Site
$80 - $90
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)
No Travel Required

Skills

Data Vault
Data Vault Certification
Snowflake

Job Details

Job Title: Senior Snowflake Developer Data Engineer with Data Vault

Location: Dallas, TX

Duration: 12 Month Contract

Note:

  • Data Vault Certification is not must to have but must have any of them. And must have Data Vault 2.0 experience. 1st preference will be given to someone who are having both the certifications.
  • Relocation is allowed

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

  1. Have experience with Data Vault, not just theoretical, but actual use. As data modeling is part of the role, previous experience is required and candidate should already have their Data Vault certification.
  2. 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.
  3. 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, Google Cloud Platform) 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:

  • Atleast 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 ERD's
  • Hands-on Python development experience
  • Should have knowledge of Real time or Near-real time streaming data using Kafka with Snowpipe
  • Knowledge of Cloud platforms (AWS, Azure, or Google Cloud Platform) 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)
  • Data Vault Certification
  • Experience with CI/CD pipelines and DevOps practices for Snowflake
  • Knowledge of DBT is a plus
  • Snowflake Admin experience is preferred
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.