Senior Snowflake Developer

ALLTECH CONSULTING SVC INC; New York (NY); On-site; USD 120,000 - 160,000; Full time

Job summary

A leading consulting firm is looking for a Data Engineer specializing in DBT and Snowflake. This role involves designing data pipelines, writing ETL processes, and collaborating with cross-functional teams to ensure operational excellence. Ideal candidates will have extensive experience in cloud platforms and a strong analytical skill set to support data-driven decisions.

Qualifications

• Minimum of 7+ years in Data Engineering or Management.
• 4-5 years in SQL application development.
• Experience with DBT and Snowflake required.

Responsibilities

• Design and develop scalable data pipelines using modern data stack technologies.
• Write ETL processes and develop data pipelines for Operational Business Intelligence.
• Collaborate with teams to understand observability requirements.

Skills

Data Engineering

SQL

DBT

Snowflake

Python

Data Modelling

ETL

Airflow

Job description

Mandatory Skills:Data Engineer – DBT + Snowflake + Airflow+ SQL

Job Description:

• Design and develop scalable data pipelines using modern data stack technologies for Cloud data platform.
• Write ETL processes, design data applications and develop data pipelines for Operational Business Intelligence Mart
• Role involves analyzing technical metadata, Data Pipeline logs and data lineage for data platform, and providing insights to support data platform operational decisions.
• Collaborate with cross-functional teams to understand and Elucidate Observability requirements for the data platform considering SLA, operational needs, DQ and proactive monitoring.
• Work with other engineers on the team to elevate technology and consistently apply best practices.

DBT Experience is must required:

1. DBT macros and overwriting
2. DBT Custom Schemas
3. DBT Materialization details
4. Snowflake Cluster Keys
5. Snowflake SQL functions

Required Skill and Experience:

• A minimum of 7+ years of IT experience in data engineering or data management field
• 4 – 5 years of experience in application development using SQL, PLSQL
• Strong working knowledge and min of 2 years’ experience in DBT, Snowflake
• Hands-on experience with Airflow is highly recommended
• Strong working experience with Python, python pandas.
• Recent experience as a Senior Data Engineer in any public cloud, preferably on Azure as well as on a cloud warehouse like Snowflake is required
• 2+ years of experience in building data pipelines using various ETL and ELT tools
• Experience in building cloud native solutions, preferably on Azure including the use of DevOps CI / CD tools and containers.
• Proven experience as a Data Analyst or in a similar role.
• Strong proficiency in Data Modelling, process metadata, observability, and monitoring data platforms.
• Familiarity with data modelling tools / techniques is a plus
• Azure or Snowflake training / certification is a plus
• Strong analytical, problem solving, communication, collaborative and organizational skills
• Self-driven, self-directed, passionate analytical and focused on delivering the right results