Engineering - Engineer - Automation (Mid Level)

TechDigital Group; Marlborough (MA); On-site; USD 90,000 - 150,000; Full time

Job summary

An innovative firm is seeking a Senior ETL Lead with expertise in Snowflake and DBT to spearhead the transformation of existing databases into a modern Snowflake environment. This role involves designing efficient data storage solutions, optimizing SQL queries, and integrating Snowflake with downstream systems. The ideal candidate will possess strong analytical skills and a deep understanding of ETL processes. Join a forward-thinking team where your contributions will drive significant improvements in data management and efficiency.

Qualifications

• 5+ years of experience in ETL processes and data management.
• Strong proficiency in Snowflake and DBT for data transformation.

Responsibilities

• Lead the development of converting existing databases to Snowflake using DBT.
• Design scalable data storage solutions and optimize SQL queries.

Skills

SQL

ETL Process

Data Analysis

Snowflake

DBT

UNIX

Tools

DataStage

Job description

Role: Snowflake DBT

1. Looking for a talented senior ETL Lead with Snowflake/DBT Experience to lead the development efforts of converting existing DB to Snowflake using DBT and other internal processes.
2. Design and implement scalable and efficient data storage solutions using Snowflake.
3. Write, optimize, and troubleshoot SQL queries within the Snowflake environment.
4. Ability to analyze complex data patterns and optimize data storage and retrieval.
5. Familiar with Snowflake Features like Time Travel and Zero-Copy Cloning.
6. Integrate Snowflake with downstream systems.
7. Proficient in SQL and familiar with the ETL process.
8. Proficient in ETL tools such as DataStage.
9. Proficient in DBT and UNIX.