Snowflake Data Engineer - Onsite Milwaukee

Cloud BC Labs; Milwaukee (WI); On-site; USD 120,000 - 170,000; Full time

Job summary

Cloud BC Labs Inc is seeking an experienced Snowflake Developer to design, build, and maintain scalable data warehouse solutions. You will work on Snowflake architecture, SQL optimization, and data integration across cloud platforms, ensuring data quality and governance.

Ideal candidates have strong Snowflake, SQL, and ETL/ELT experience, familiarity with Snowpipe and cloud services, and collaboration across data teams to deliver reliable data pipelines.

Qualifications

• Must have hands-on Snowflake experience with design, development and maintenance of data warehouses.
• Strong SQL skills including complex queries, joins, CTEs and window functions.
• Experience building and maintaining ETL/ELT pipelines and data integration.

Responsibilities

• Design, develop, and maintain Snowflake-based data warehouse solutions.
• Write and optimize complex SQL queries, stored procedures, and views.
• Build and maintain ETL/ELT pipelines for data ingestion and transformation.
• Implement data loading using Snowpipe, COPY INTO and stages.
• Model data, integrate data and tune warehouse performance.
• Work with large datasets and optimize costs and performance.
• Enforce data security, RBAC, and governance.
• Integrate Snowflake with AWS, Azure, or GCP.
• Troubleshoot pipelines and ensure data quality and reliability.
• Collaborate with data engineers, architects, analysts, and stakeholders.
• Maintain technical documentation and follow best practices.

Skills

Snowflake Data Cloud

Advanced SQL

ETL/ELT Development

Data Modeling

Snowflake Architecture

Snowpipe Streams Tasks

Python Scripting

Cloud Platforms

Git CI/CD

Data Warehousing

Education

Bachelor's degree

Tools

Informatica

dbt

Matillion

Fivetran

Azure Data Factory

Job description

Cloud BC Labs Inc is seeking an experienced Snowflake Developer to design, build, and maintain scalable data warehouse solutions. You will work on Snowflake architecture, SQL optimization, and data integration across cloud platforms, ensuring data quality and governance.

Ideal candidates have strong Snowflake, SQL, and ETL/ELT experience, familiarity with Snowpipe and cloud services, and collaboration across data teams to deliver reliable data pipelines.