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

The TJX Companies , Inc.

OVERNIGHT Merchandise Associate Job at The TJX Companies , Inc.

 ...TJ MaxxAt TJX Companies, every day brings new opportunities for growth, exploration, and...  .... Adheres to all operational, merchandise, and loss prevention standards. May be cross...  ...experience preferredBenefitsBenefits include: Associate discount; EAP; smoking cessation;... 

National Health Partners

Physician Pediatric-Nephrology - Competitive Salary Job at National Health Partners

 ...Nephrologist. The role includes inpatient and outpatient nephrology services, covering acute and chronic kidney replacement therapy, dialysis, and transplant follow-ups. Outpatient services are supported by a kidney dietitian, pediatric psychologist, and social worker.... 

Presto Distribution Center Inc

Warehouse Associate / Order Picker Job at Presto Distribution Center Inc

 ...Description Job Description Description: Position Summary The Warehouse Associate is responsible for accurately selecting, staging, and...  ..., bending, and lifting throughout the shift Ability to lift up to 30 pounds regularly Ability to safely operate and mount/... 

Oklahoma City Community College

Student gameLab Assistant eSports Job at Oklahoma City Community College

 ...Student gameLab Assistant eSports The Student gameLab Assistant eSports will assist the eSports Coach in supporting the gameLab by keeping the space organized, assisting students and more. Position Type - Student Employee Job Category - Student Minimum Education... 

RB Global Inc.

Title Clerk Job at RB Global Inc.

 ...Job Description The Title Clerk is responsible for searching and processing vehicle titles accurately and efficiently and in accordance with company and state agency requirements. Responsibilities Responsible for processing vehicle titles accurately and efficiently...