Lead Snowflake Developer – Permanent

Salary: £85,000 to £95,000 per annum - Benefits – 6% Pension, Life Assurance, Healthcare options

Location: UK Wide base locations / Hybrid flexible working model – remote and on site

The Client:

Our client is a global leader in Systems Integration and IT Consultancy. They have built out a super advanced and respected industry wide Insights and Data Practice. Our clients provides consultancy services, advice, proof-of-values, industrialised solutions; we work on small and very large engagements, and we work across several different sectors, including public, CPG, retail, manufacturing and utilities.

The Role:

We are looking for a Senior Snowflake Developer/Lead within our client’s Emerging Tech Team. Do you want to be at the forefront of the AI revolution? We are looking to bring in an experienced Lead who can utilise their current experience of implementing Snowflake solutions to help our clients truly leverage the best out of Snowflake and build world class data platform capabilities.

Essential Skills and Experience:

·       Experience of working in global projects implementing one or more of AWS, GCP and Azure platform components on multi-tenant Snowflake DWH

·       Experience of developing enterprise grade ELT data pipelines within Snowflake.

·       Strong understanding of data manipulation/wrangling techniques

·       Demonstrable knowledge of applying Snowflake best practices (coding practices to DS, unit testing, version control, code review).

·       Experience of working with global teams and Agile delivery.

·       Specific Snowflake Data Warehouse/Platform:

• Definition and build of logical and physical data model to meet the need of the solution
• Experienced in all Snowflake Objects but master in (Databases, Schemas, Tables and Views) as well as Zero copy cloning and Time Travel.
• Experience of defining the right size warehouse to and strong experience of Multi-Cluster Warehouse, from sizing to managing changing workloads and performance / cost optimisation.
• Experienced with Stored Procedures, Functions, Internal and External stages as well as creating efficient Snowpipe data pipelines.
• Strong understanding of Snowflake Security model and inheritance rules
• Experienced with SQL in Snowflake and SnowSQL and ability to review and educate other team members on SQL Explain plans and identify performance bottlenecks
• Experience in designing structure to support reporting solutions optimised for use from tools like Qlik, Looker, Tableau etc
• Ideally SnowPro certified, working towards or a strong desire to become certified

83DATA is a boutique consultancy specialising in Data Engineering and Architecture | Data Science (ML, AI, DL) | Data Visualisation | RPA within the UK. We provide high quality interim and permanent senior IT professionals.