Title: Snowflake DBT Engineer
Location: New York (Hybrid 2-3 Days)
Duration: 6 Months
Exp 10+ Years
Job descriptionPrimary 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
SkillsMandatory Skills : Snowflake, Data Vault (ODS) Modeling, Dimensional Data Modeling
...Pastry and Dessert Chef is responsible for the precise execution and flawless presentation of all desserts, pastries, and house-made ice creams served in the restaurant. This role requires technical skill in baking and confectionery, meticulous attention to detail, and a...
...brings the world of work home by providing superior customer service to Fortune 500 companies via a virtual call center setting. We are currently recruiting... ...efficiently Experience as a customer service representative or sales representative or related industry...
...UX/UI designer Location: Remote Summary: Our client is seeking a talented UX/UI designer (Spanish bilingual) to help translate their site to Spanish, combining innovation with the power of technology. This is a long-term, open-ended contract...
...Allen Home Care Services, Inc. is looking for an LPN or an RN to provide private duty nursing to a pediatric patient in the Sikeston/Benton area. This position is part time nights. Care: Respiratory monitoring Bi-pap Dressing & grooming Shift: ~9p-7a...
...Reference #: 5181593 THE POSITION Would you like physical work in the outdoors, for a state agency that provides fishing and boating opportunities for individuals and families in Pennsylvania's many lakes, river, and streams? Would you be interested in a position that...