Back to search
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.
