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

Tristar Health

Nursery Nurse Job at Tristar Health

TriStar Health seeks a compassionate Nursery Nurse to deliver high-quality care to newborns and their families within our Healthcare & Medical Services department. In this role, you will monitor infant health, administer medications, support feeding, and provide family... 

Volunteers of America

Lead Monitor Graveyard Shift Job at Volunteers of America

Lead Monitor I The Lead Monitor I will arrange, coordinate, supervise, mentor, and oversee the Monitors' efforts to provide security of the program premises, and safety for program clients, visitors and employees. The Lead Monitor I shall provide Safety Training to ...

Headway

Licensed Marriage and Family Therapist Job at Headway

 ...insurance makes it accessible to those who need it most. Every mental health provider who goes in-network with Headway supports people whod...  ...forced to choose between paying out of pocket, or not getting care at all. We make that process seamless empowering you to accept... 

Jacob Bramel - State Farm Agent

Multi-Line Representative - State Farm Agent Team Member Job at Jacob Bramel - State Farm Agent

 ...discipline, teamwork, and strong performance. Before becoming an agent, I served in the military, which shaped my leadership style and...  .... Location Address: Bedford, NH 03110 At Jacob Bramel - State Farm Agent, were here to help people protect what matters most. We... 

AJS Hotels

Front Desk Agent Job at AJS Hotels

 ...Front Desk Attendant Employee Perks! Same Day Pay Access, FREE Parking...  ..., Shoes for Crews Discounts, Hotel Room Discounts at Various...  ...searching for our 1st and 2nd shift front desk attendants to provide...  ...Day Shift (Preferred) Night Shift (Preferred) ~ Full...