Senior Snowflake Developer

Instead, we need a true Snowflake practitioner. We are looking for a strong executor who thrives on building robust data pipelines, optimizing complex queries, and leveraging Snowflake’s native features to move and transform data efficiently. You will work closely with our Data Architects and Data Science teams to turn blueprints into high-performing, scalable reality.

The Impact You Will Make You will be the engine of our data team. By bringing deep, hands-on Snowflake expertise to the table, you will:

• Accelerate Delivery: Turn architectural designs into production-ready pipelines, dramatically reducing our time-to-insight.
• Optimize Performance and Cost: Ensure our Snowflake environment runs at peak efficiency by fine-tuning virtual warehouses, optimizing micro-partitions, and streamlining compute resources.
• Elevate Our Data Infrastructure: Transition us away from external processing bottlenecks by migrating complex transformations directly into Snowflake using its native capabilities.
• Free Up Strategic Bandwidth: By taking ownership of heavy-duty building and execution, you will allow our architects to focus on long-term strategy and system design.

What You Will Do

• Develop, deploy, and maintain scalable data pipelines utilizing Snowflake’s native ecosystem (Snowpipe, Streams, Tasks, and Snowpark).
• Write advanced, highly optimized SQL queries to support complex data transformations and reporting requirements.
• Manage and optimize Virtual Warehouses, applying best practices for scaling and cost control.
• Collaborate with Data Architects to implement data models and ensure pipelines align with the overall data framework.
• Troubleshoot data issues, identify performance bottlenecks, and implement structural improvements to existing data workflows.
• Perform data profiling and ensure strict adherence to data quality and governance standards.

• Dedicated Snowflake Experience: 7+ years in Data Engineering with at least 2+ years of heavy, hands-on experience working inside the Snowflake platform.
• Native Feature Mastery: You don’t just use Snowflake as a target database for external apps; you know how to leverage Snowpipe, Time Travel, Zero-Copy Cloning, and Streams/Tasks.
• Performance Tuning: Proven ability to monitor compute costs, diagnose slow queries, and apply optimization techniques (clustering, micro-partitioning, caching).
• Advanced SQL: Exceptional SQL scripting skills for deep data transformation and analysis.
• Execution Focus: You are comfortable working within established architectural frameworks and taking direction on high-level design, focusing your energy on building and optimizing the solution.
• Cloud Ecosystem Knowledge: Familiarity with integrating Snowflake within broader cloud environments (AWS, Azure, or GCP) and working with standard ETL/ELT orchestration tools (e.g., dbt, Airflow, Fivetran).

If your primary experience has been building front-end applications, backend APIs (C#, Java, Node.js), or traditional software engineering where Snowflake was simply an existing source you queried or wrote to, this role will not be a fit. We are seeking candidates whose core function has been dedicated data engineering and data pipeline construction.

This is a 6-month contract-to-hire.

You must be able to pass a criminal background check as well as a drug test.

Job Types: Full-time, Contract

Pay: $60.00 - $80.00 per hour

Expected hours: 40.0 per week

Benefits:

• 401(k)

Application Question(s):

• I confirm that I don’t require sponsorship now, or will EVER require sponsorship, to work in the US. Please answer Yes, if that is true.