Snowflake ETL Engineer Job at ShiftCode Analytics, New York, NY

dkNtQlRySTJqdUhwWlQrNzhUZlQrSWMrUGc9PQ==
  • ShiftCode Analytics
  • New York, NY

Job Description

ETL Engineer

Job Description: We are currently seeking a highly skilled and experienced ETL engineer with a strong background in Snowflake. This is an onsite position, requiring a minimum of 3 days per week in the office. The ideal candidate will have extensive experience with MS SQL Server, T-SQL, Snowflake DB, and other related technologies. Experience with Azure Data Factory, Azure Databricks, and Python is also highly desirable.

Responsibilities:

  • Designing, developing, and implementing ETL/ELT processes using Snowflake and other related technologies.
  • Building and maintaining data pipelines to extract, transform, and load data from various sources into Snowflake.
  • Writing efficient and optimized SQL queries, stored procedures, and T-SQL scripts for data manipulation and transformation.
  • Ensuring data integrity and accuracy throughout the ETL process.

Requirements:

  • Minimum of 8 years of experience working with MS SQL Server, including strong proficiency in T-SQL.
  • At least 6 years of hands-on experience with Snowflake DB, including data modeling, performance tuning, and security.
  • Proficiency in Azure Data Factory, with a minimum of 5 years of experience in designing and implementing data integration workflows.
  • Familiarity with Azure Databricks, with a minimum of 4 years of experience using it for big data processing and analytics.
  • Strong programming skills in Python, with a minimum of 5 years of experience in writing ETL/ELT processes using Python.
  • Excellent understanding of ETL principles and best practices, with a minimum of 7 years of experience in ETL development.
  • Solid knowledge of data warehousing concepts and dimensional modeling.
  • Bachelor's degree in Computer Science, Information Systems, or a related field (preferred).

Job Tags

Work at office, 3 days per week

Similar Jobs

T Mobile US

Mobile Associate, Store in Store - Retail Sales Job at T Mobile US

 ...Mobile Associate, Store-In-Store At T-Mobile, we invest in YOU! Our Total Rewards Package ensures that employees get the same big love we give our customers. All team members receive a competitive base salary and compensation package - this is Total Rewards. Employees... 

GS Senior Care

CNA / Certified Nursing Assistant Job at GS Senior Care

Good Samaritan Health Center is seeking a compassionate and dedicated Certified Nursing Assistant (CNA) to join our team in providing exceptional care to our underserved communities. This role is crucial in fostering an environment that prioritizes holistic health and wellness...

Nationwide Video

Audio Visual Warehouse Technician - Evening Shift Job at Nationwide Video

Job Description Job Description Overview: This position works in a warehouse performing shipping and receiving responsibilities for A/V rental equipment. This position reports to the local Office Manager. Essential Functions: Reasonable accommodation may ...

PepsiCo Beverages North America

Warehouse Person (Loader / Order Selector) - Evenings/Seasonal Job at PepsiCo Beverages North America

 ...CLICK HERE to view our Warehouse Person (Loader) Realistic Job Preview Video $21.00 / hour This labor-intensive position is responsible...  ...to loading outgoing trucks and unloading incoming trucks. Works from Electronic order system or order sheets to build loads using... 

4M Building Solutions

General Cleaner Janitorial Job at 4M Building Solutions

 ...General Cleaner: Full and Part Time Positions Hourly Pay Rate: $16.00 1st Shift: 7:00am to 4:00pm Monday-Friday 2nd...  ...responsibilities including: Get trained in 4M's state-of-the-art cleaning and disinfecting practices using green-sealed certified...