Snowflake Data Engineer: Cloud DW, ETL & Optimization

Cloud Analytics Technologies, LLC; Chicago (IL); On-site; USD 110,000 - 180,000; Full time

Job summary

Cloud Analytics Technologies, LLC is seeking a skilled Data Engineer to design, develop, and optimize Snowflake-based data warehouse solutions. The role emphasizes building scalable data pipelines, writing complex SQL, and ensuring data quality across enterprise environments.

The candidate should possess strong Snowflake experience, SQL proficiency, and familiarity with cloud data tools to drive performance and governance.

Qualifications

• 5–8 years of experience in data engineering or data warehouse development.
• 3+ years hands-on experience with Snowflake.
• Strong expertise in 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 migrations.
• Strong analytical, troubleshooting, and problem-solving abilities.

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.

Job description

Cloud Analytics Technologies, LLC is seeking a skilled Data Engineer to design, develop, and optimize Snowflake-based data warehouse solutions. The role emphasizes building scalable data pipelines, writing complex SQL, and ensuring data quality across enterprise environments.

The candidate should possess strong Snowflake experience, SQL proficiency, and familiarity with cloud data tools to drive performance and governance.