Senior Data Engineer: Snowflake, ETL & Data Modeling

Robotic Technologies Automation; Chicago (IL); On-site; USD 120,000 - 180,000; Full time

Job summary

Robotic Technologies Automation is seeking a senior Data Engineer to design and optimize scalable data pipelines in Snowflake. You will model data using star and snowflake schemas, write complex SQL, and implement robust ETL/ELT processes across cloud environments.

You will collaborate with analysts, architects, and data teams to understand requirements, ensure data governance, and troubleshoot production issues. Strong SQL, data modeling, and cloud experience are essential.

Qualifications

• 7+ years of experience in data engineering.
• Proficient with Snowflake data warehousing.
• Strong SQL and data modeling skills.
• Experience with ETL/ELT and data warehousing concepts.
• Experience with AWS or Azure cloud platforms.

Responsibilities

• Design, develop, and maintain scalable data pipelines using Snowflake.
• Model data using dimensional modeling, star and snowflake schemas.
• Develop complex SQL queries, stored procedures, and optimized data transformations.
• Build and maintain ETL/ELT pipelines using Informatica, Azure Data Factory, dbt, or similar.
• Integrate data from multiple source systems into Snowflake.
• Optimize Snowflake queries, warehouses, storage, and performance.
• Develop data models for analytics, reporting, and BI.
• Ensure data quality, accuracy, security, and governance.
• Collaborate with analysts, architects, and data teams on requirements.
• Troubleshoot data pipelines and production issues.
• Participate in code reviews, documentation, and design discussions.

Skills

Snowflake

SQL

Data Modeling

ETL/ELT

AWS/Azure Cloud

Python

Git/CI-CD

Agile methodologies

Tools

Informatica

Azure Data Factory

dbt

Job description

Robotic Technologies Automation is seeking a senior Data Engineer to design and optimize scalable data pipelines in Snowflake. You will model data using star and snowflake schemas, write complex SQL, and implement robust ETL/ELT processes across cloud environments.

You will collaborate with analysts, architects, and data teams to understand requirements, ensure data governance, and troubleshoot production issues. Strong SQL, data modeling, and cloud experience are essential.