Overview
$Negotiable
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 6+ month(s)
Skills
SQL
Snowflake Development
Snowflake architecture
Job Details
Role : Snowflake Developer
Location : Remote(Should be able to cover PST timezone)
Contract: 06+ Months
Requirement Analysis & Collaboration - Collaborate with Intel Product Owners, Solution Analysts, and Scrum Masters to understand business requirements, clarify technical needs, and define data solution expectations.
- Participate in agile ceremonies including sprint planning, backlog refinement, and daily stand-ups.
- Provide technical inputs during requirement discussions to ensure feasibility and alignment with Snowflake best practices.
- Develop detailed technical design and specification documents, including data flows, table structures, transformation logic, and integration requirements.
- Translate functional requirements into optimized Snowflake schemas (staging, integration, and presentation layers).
- Ensure adherence to architectural standards and security best practices.
- Design, develop, and optimize complex stored procedures, UDFs, and SQL scripts within Snowflake.
- Build and maintain Snowflake pipelines, including tasks, streams, and Snowpipe.
- Implement end-to-end ETL/ELT processes using Snowflake and supporting tools (dbt, Python, Airflow, Informatica, etc. - optional depending on your stack).
- Perform SQL performance tuning, query optimization, and data pipeline efficiency improvements.
- Write unit test cases and participate in integration/system testing.
- Work with DevOps teams to support CI/CD pipeline configurations.
- Troubleshoot issues, resolve defects, and ensure high-quality delivery within sprint timelines.
- Maintain up-to-date documentation for all developed solutions.
- Provide production support, investigate incidents, and implement long-term fixes.
- 3 7 years of experience as a Snowflake Developer / Data Engineer.
- Strong expertise in Snowflake architecture, virtual warehouses, roles, RBAC, data sharing, and micro-partitioning.
- Hands-on experience creating complex stored procedures, SQL scripts, UDFs, and ETL/ELT transformations.
- Strong proficiency in SQL and performance tuning.
- Experience working in Agile/Scrum teams.
- Ability to create detailed technical specifications and design documents.
- Experience integrating Snowflake with data pipelines or orchestration tools.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.