DBT Snowflake Developer at Remote only Boston, MA

Contract

DBT Snowflake Developer

 

Role: DBT Snowflake Developer

Location: Remote

Type of Hire: Contract

 

Skill Matrix to be filled by Candidates:

 

Mandatory Skills
Years of Experience
Year Last Used
Rating Out of 10
DBT
 
 
 
Snowflake
 
 
 
ETL
 
 
 
SQL
 
 
 
 

Job Description          

Key Responsibilities:

Data Modeling & Architecture: Design and implement scalable data models and architectures within the Snowflake environment to meet analytics and operational needs.
SQL Development: Write, optimize, and maintain complex SQL queries, stored procedures, and scripts to process, transform, and analyze data.
ETL/ELT Processes: Develop and manage data pipelines using Snowflake features such as Snowpipe, tasks, and streams, integrating with external ETL tools where needed.
Performance Optimization: Monitor and optimize Snowflake environments for performance, ensuring efficient query execution and cost management.
Data Governance: Implement data security, masking, and access control in accordance with organizational and regulatory requirements.
Collaboration: Work closely with data architects, analysts, and business stakeholders to gather requirements and deliver robust data solutions.
 

Must-Have:

Strong expertise in SQL, including query optimization, window functions, and advanced scripting.
Hands-on experience with Snowflake’s architecture, features, and tools (e.g., Snowpipe, streams, tasks, data sharing).
Experience with data warehousing concepts such as star/snowflake schemas and fact/dimension tables.
Familiarity with cloud platforms (e.g., AWS, Azure, GCP) and integrations with Snowflake. Knowledge of performance tuning in large-scale data environments.
 

Preferred:

Experience with ETL tools like Informatica, Matillion, dbt, or Talend.
Proficiency in programming languages such as Python for data workflows.
Familiarity with data visualization tools like Tableau, Power BI, or Looker.
 

To apply for this job email your details to prasanth.s@alchemysolutions.us