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

dEpTWk9Hd2djbGNzWE5JS3FJY3E5SUJVK2c9PQ==
  • 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

Global 1 Logistics LLC

Independent Contractor Delivery Driver Use Your Own Vehicle Job at Global 1 Logistics LLC

 ...(car, SUV, or van) Smartphone with active data plan Valid drivers license and insurance Completed W-9 form Direct Deposit...  ...every day Professionalism: Treat every delivery like its your own customer Efficiency: Plan routes and work smart to stay on schedule... 

Housekeeper.com

Housekeeper Wanted - Needed: A Well Trained Home Cleaner Job at Housekeeper.com

 ...Description:I hope you are having a good day. I'm looking for a home cleaner working in Evansville, Indiana. My goal is to find a...  ...availability.Service Requirements:Our family needs bathroom cleaning, kitchen cleaning, general room cleaning. Ideally, you have a drivers... 

Farmington Health Services

Social Worker Assistant Job at Farmington Health Services

 ...will collaborate with and report to the Social Services Director. Part-time, flexible day...  ...Trinity Care Center offers 24/7 skilled nursing care and rehabilitation services Become...  ...facility today ranked 4th best nursing home in MN by Newsweek! Farmington Health... 

Surgery Partners, Inc

Registered Nurse Operating Room Circulator ($2500 Sign-On Bonus) Job at Surgery Partners, Inc

 ...to join our amazing team at Duly - Westmont ASC! Great benefits and competitive pay. $2,500 sign-on bonus. JOB TITLE: Registered Nurse- OR Salary Range: $36.00 - $52.00 per hour, based on skill and experience level. ESSENTIAL FUNCTIONS: The delivery of patient... 

Alliance Painting Inc

In House Painting Employee Job at Alliance Painting Inc

 ...attention to detail and pride in workmanship Dependable, honest, and hardworking Good communication skills (clear, respectful, solution-focused) Smart phone and ability to use it for work communication Clean driving record Fluent in English Personal...