Senior Snowflake Data Engineer — Cloud DW & ETL Expert

Valiant Technologies LLC; Chicago (IL); In loco; USD 120.000 - 155.000; Tempo pieno

Descrizione del lavoro

Valiant Technologies LLC in Chicago, IL, is seeking a senior Data Engineer to design and optimize cloud-based data warehouse solutions using Snowflake. The role focuses on building scalable pipelines, optimizing queries, and ensuring data governance across enterprise environments.

The ideal candidate will demonstrate strong SQL, Snowflake expertise, experience with ETL/ELT workflows, and collaboration with analytics teams.

Competenze

• 5–8 years of experience in data engineering or data warehouse development.
• 3+ years of hands-on Snowflake experience.
• Strong SQL, data transformation, and query optimization.
• Experience building enterprise-scale ETL/ELT workflows.
• Practical knowledge of cloud platforms and data integration tools.
• Experience handling large datasets and complex data migration projects.
• Strong analytical, troubleshooting, and problem-solving abilities.
• Bachelor's degree in Data Engineering, CS, IS, or Applied Mathematics; graduate coursework and SnowPro certifications are advantageous.

Mansioni

• Design, develop, and maintain scalable Snowflake data warehouse solutions in Snowflake.
• Build and optimize complex SQL queries, views, and stored procedures.
• Develop ETL/ELT pipelines to integrate data from multiple source systems.
• Configure Snowflake Streams and Tasks for automated data processing.
• Monitor warehouse performance and optimize query execution.
• Implement data validation, quality checks, and reconciliation processes.
• Integrate Snowflake with cloud storage and external data platforms.
• Manage data access, security policies, and user permissions.
• Collaborate with data engineers, architects, and analytics teams.

Conoscenze

SQL & data transformations

Snowflake architecture

Snowflake Streams/Tasks

SnowSQL

Python & Snowpark

Cloud data integration

Data modeling (dimensional)

ETL/ELT design

Troubleshooting & optimization

Formazione

Bachelor's degree in Data Engineering, CS, IS, or Applied Mathematics

Graduate coursework in Data Architecture/Cloud Computing/DB Systems

Strumenti

Snowflake

Informatica

Matillion

dbt

Fivetran

Descrizione del lavoro

Valiant Technologies LLC in Chicago, IL, is seeking a senior Data Engineer to design and optimize cloud-based data warehouse solutions using Snowflake. The role focuses on building scalable pipelines, optimizing queries, and ensuring data governance across enterprise environments.

The ideal candidate will demonstrate strong SQL, Snowflake expertise, experience with ETL/ELT workflows, and collaboration with analytics teams.