Snowflake Developer

Role: Snowflake Developer

Type: Contract

Location: 100% Remote

The candidate should have a semiconductor background and be ready to support PST hours.

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
  .
• 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.