Snowflake DBT Engineer

New York City, NY - USA

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Title: Snowflake DBT Engineer

Location: New York (Hybrid 2-3 Days)

Duration: 6 Months

Exp 10 Years

Job description

Primary Skill: Snowflake Airflow

Secondary Skill: DBT Sql server and PostgreSQL

We are seeking a highly skilled Data Engineer with extensive experience in Snowflake Data Build Tool dbt Snaplogic SQL Server PostgreSQL Azure Data Factory and other ETL tools The ideal candidate will have a strong ability to optimize SQL queries and a good working knowledge of Python A positive attitude and excellent teamwork skills are essential

Key Responsibilities

Data Pipeline Development Design develop and maintain scalable data pipelines using Snowflake dbt Snaplogic and ETL tools

SQL Optimization Write and optimize complex SQL queries to ensure high performance and efficiency

Data Integration Integrate data from various sources ensuring consistency accuracy and reliability

Database Management Manage and maintain SQL Server and PostgreSQL databases

ETL Processes Develop and manage ETL processes to support data warehousing and analytics

Collaboration Work closely with data analysts data scientists and business stakeholders to understand data requirements and deliver solutions

Documentation Maintain comprehensive documentation of data models data flows and ETL processes

Troubleshooting Identify and resolve datarelated issues and discrepancies

Python Scripting Utilize Python for data manipulation automation and integration tasks

Qualifications

Experience Minimum of 8 years of experience in data engineering

Technical Skills

Proficiency in Snowflake dbt Snaplogic SQL Server PostgreSQL and Azure Data Factory

Strong SQL skills with the ability to write and optimize complex queries

Knowledge of Python for data manipulation and automation

Knowledge of data governance frameworks and best practices

Soft Skills

Excellent problem solving and analytical skills

Strong communication and collaboration skills

Positive attitude and ability to work well in a team environment

Certifications Relevant certifications eg Snowflake Azure are a plus

Skills

Mandatory Skills : Snowflake Data Vault (ODS) Modeling Dimensional Data Modeling

Title: Snowflake DBT Engineer Location: New York (Hybrid 2-3 Days) Duration: 6 Months Exp 10 Years Job description Primary Skill: Snowflake Airflow Secondary Skill: DBT Sql server and PostgreSQL We are seeking a highly skilled Data Engineer with extensive experience in Snowflake Data Build T...