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.
Design & Architecture
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.Snowflake Development
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.Testing & Deployment
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.Documentation & Support
Maintain up-to-date documentation for all developed solutions.Provide production support, investigate incidents, and implement long-term fixes.Required Skills & Experience
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.