
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