Job Description

Contract Opportunity: Lead Snowflake Developer / Architect (Outside IR35)

Day Rate: 550 to 650 per day

Location: UK Wide - Hybrid Flexible Working Model (Remote and On-site)

Engagement: Contract, Outside IR35

Duration: 6 months initially, with potential for extension

The Client: Our client is a global leader in Systems Integration and IT Consultancy. Renowned for their advanced and respected industry-wide Insights and Data Practice, they provide consultancy services, advice, proof-of-values, and industrialised solutions across public, CPG, retail, manufacturing, and utilities sectors.

The Role: We are seeking a highly experienced Lead Snowflake Developer to join our client's Emerging Tech Team. This role is pivotal in leveraging cutting-edge AI technology and implementing Snowflake solutions to enhance our clients' data platform capabilities.

Essential Skills and Experience:

• Proven track record in global projects implementing AWS, GCP, and Azure platform components on multi-tenant Snowflake DWH.
• Expertise in developing enterprise-grade ELT data pipelines within Snowflake.
• Strong command of data manipulation/wrangling techniques.
• Adherence to Snowflake best practices including coding practices to DS, unit testing, version control, and code review.
• Experience working with global teams and Agile delivery methodologies.
• In-depth knowledge of Snowflake Data Warehouse/Platform, including:
  • Building logical and physical data models.
  • Mastery of Snowflake Objects (Databases, Schemas, Tables, and Views), Zero copy cloning, and Time Travel.
  • Sizing and managing Multi-Cluster Warehouses for performance/cost optimisation.
  • Developing Stored Procedures, Functions, Internal and External stages, and efficient Snowpipe data pipelines.
  • Comprehensive understanding of the Snowflake Security model and rules.
  • Proficiency in SQL in Snowflake, SnowSQL, and the ability to optimise performance through SQL Explain plans.
• Experience in designing structures to support reporting solutions optimised for tools like Qlik, Looker, Tableau.
• SnowPro certification is highly desirable or a strong intent to become certified.

Why This Role: This contract offers the chance to work with a prestigious consultancy, driving significant innovation in data solutions. The role is outside IR35, providing the flexibility of contract work with the stability of a potential long-term engagement.

Interested candidates are invited to apply directly. Please include your current CV, availability, and a brief explanation of your qualifications related to the essential skills listed.