Sr Data Snowflake Engineer

PamTen

United States

5 days ago

Apply on www2.jobdiva.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Working hours

Regular working hours

Job source

www2.jobdiva.com

Tech stack

Agile Methodology Airflow Amazon Web Services Microsoft Azure Unix Information Systems Directed Acyclic Graph (Directed Graphs) Extract Transform Load (ETL) Data Transformation Data Mining Data Systems Data Warehousing

+16 more

Database Queries Python (Programming Language) Performance Tuning Cloud Services Shell Script SQL Databases Data Processing Scripting Freeform SQL Google Cloud Snowflake Git Information Technology Dynamic Data Software Version Control Data Pipelines

Job description

Design, build, and maintain Snowflake data warehouses and ETL pipelines.
Develop and optimize SQL queries for data extraction, transformation, and reporting.
Create and manage DAGs (Directed Acyclic Graphs) using Airflow for data workflows.
Implement best practices for Snowflake performance tuning, cost optimization, and scalability.
Manage UNIX-based environments, perform shell scripting, and automate system processes.
Collaborate with data analysts, data scientists, and other stakeholders to deliver high-quality data solutions.
Troubleshoot and resolve performance issues in Snowflake, Airflow, and UNIX environments.

Requirements

Job Overview: We are looking for an experienced Snowflake Data Engineer with strong skills in SQL, Airflow, and UNIX to join our dynamic data engineering team. In this role, you will design, implement, and optimize Snowflake-based data solutions while leveraging SQL for data transformations, Airflow for orchestrating workflows, and UNIX for system management and automation., * Snowflake expertise : In-depth understanding of Snowflake architecture, security, and performance optimization.

SQL proficiency : Strong ability to write and optimize complex SQL queries for data manipulation and reporting.
Airflow experience : Hands-on experience with designing, building, and maintaining data pipelines using Apache Airflow.
UNIX skills : Experience in UNIX/Linux environments, with proficiency in shell scripting and system administration.
Experience with ETL processes and data warehousing concepts.
Ability to analyze and solve complex technical issues across different environments., * Experience with cloud services (AWS, Azure, GCP) for deploying and managing Snowflake environments.
Familiarity with Python or other scripting languages for data pipeline automation.
Knowledge of version control systems (e.g., Git).
Experience working in an Agile development environment., * Bachelor’s degree in Computer Science, Information Systems, or a related field.
5 years of experience in Snowflake development, SQL, Airflow, and UNIX.