Snowflake Data Engineer | Cloud DW & Pipelines

Robotics Technologies LLC; Chicago (IL); On-site; USD 120,000 - 160,000; Full time

Job summary

Robotics Technologies LLC in Chicago seeks an experienced Data Engineer to design and implement Snowflake-based data warehouses. You will build scalable ETL/ELT pipelines, optimize SQL queries, and ensure data quality and governance across cloud platforms.

The role requires 5–8 years in data engineering with Snowflake expertise, strong SQL, and experience with data integration tools. On-site position with collaboration across analytics teams.

Qualifications

• 5–8 years of experience in data engineering or data warehouse development.
• 3+ years of hands-on experience with Snowflake.
• Strong SQL, data transformation, and query optimization skills.
• Experience building enterprise-scale ETL/ELT workflows.
• Experience with cloud platforms and data integration tools.
• Experience handling large datasets and data migrations.

Responsibilities

• Design, develop, and maintain scalable 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.

Skills

SQL

Snowflake

SnowSQL

Python

Snowpark

Data Modeling

ETL/ELT

Query Optimization

Cloud Data Integration

Data Warehousing

Education

Bachelor's degree in Data Engineering, Computer Science, Information Systems, or Applied Mathematics

Tools

Informatica

Matillion

dbt

Fivetran

Job description

Robotics Technologies LLC in Chicago seeks an experienced Data Engineer to design and implement Snowflake-based data warehouses. You will build scalable ETL/ELT pipelines, optimize SQL queries, and ensure data quality and governance across cloud platforms.

The role requires 5–8 years in data engineering with Snowflake expertise, strong SQL, and experience with data integration tools. On-site position with collaboration across analytics teams.