Snowflake Developer

Robotics Technologies LLC
Chicago, IL, United States
1 day ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
3 years minimum
Compensation
$166,400.0
Working hours
Regular working hours
Job source

Tech stack

Query Performance Amazon Web Services Microsoft Azure Big Data Cloud Computing Cloud Database Cloud Storage Information Systems Databases Data Architecture Data Validation Information Engineering
+22 more
Data Governance Data Integration Extract Transform Load (ETL) Data Transformation Data Migration Data Security Data Warehousing Database Design Dimensional Modeling Python (Programming Language) Query Optimization Role-Based Access Control SQL Stored Procedures SQL Databases Automated Data Processing (ADP) Scripting Freeform SQL Google Cloud Snowflake Information Technology Data Management Data Pipelines

Job description

This role focuses on building and optimizing modern cloud-based data warehouse solutions using Snowflake. The ideal candidate will have strong expertise in SQL, Snowflake architecture, data pipeline development, and cloud data integration, with the ability to handle large-scale enterprise data environments., * 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.

Requirements

  • Strong hands-on experience with Snowflake data warehouse architecture.
  • Advanced proficiency in SQL and SnowSQL.
  • Experience with Snowflake Streams, Tasks, and Stored Procedures.
  • Knowledge of Snowflake virtual warehouses and query performance optimization.
  • Experience developing ETL/ELT pipelines.
  • Familiarity with Python, Snowpark, and scripting.
  • Experience with AWS, Azure, or Google Cloud Platform.
  • Knowledge of data modeling, dimensional modeling, and database design.
  • Experience with tools such as Informatica, Matillion, dbt, or Fivetran.
  • Understanding of data security, role-based access control, and data governance., * 5-8 years of experience in data engineering or data warehouse development.
  • 3+ years of hands-on experience working 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 migration projects.
  • Strong analytical, troubleshooting, and problem-solving abilities., * Bachelor’s degree in Data Engineering, Computer Science, Information Systems, or Applied Mathematics.
  • Graduate-level coursework in Data Architecture, Cloud Computing, or Database Systems is an advantage.
  • SnowPro Core or SnowPro Advanced certifications are preferred.
  • Certifications in AWS, Azure, dbt, or cloud data engineering are beneficial.
  • Relevant hands-on experience delivering Snowflake data warehouse projects is highly valued.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Loading talks and stories from around this role…