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