Job Description

Job Title: Snowflake SME (Subject Matter Expert) - Technical Consultant

Location: Milton Keynes/Hybrid - Onsite 2-3 days per week

Start Date: Immediate start

Salary/Rate: Up to £650/day INSIDE IR35

Job Type: 6 month contract initially + extensions

Company Introduction

Coltech is partnered with one of the largest and fastest-growing clients in the connectedness industry who are looking for an experienced Snowflake Subject Matter Expert - Technical Consultant to join their team for an initial 6 month contract.

Roles & Responsibilities

Design, Development, and Responsible for implementing Snowflake / MYSQL for the customer. Hands-on experience in ETL Snowflake data pipeline setup. Good understanding of Cloud-based Architectures such as AWS, GCP, Azure.

* Collaborate with clients and stakeholders to gather and understand technical and business requirements.

* Assess various technologies and tools to recommend the most suitable solutions for different projects.

* Assess Data warehouse implementation procedures to ensure they comply with internal and external regulations.

* Prepare accurate Data warehouse design and architecture reports for management.

* Oversee the migration of data from legacy systems to new solutions.

* Monitor the system performance by performing regular tests, troubleshooting and integrating new features.

* Recommend solutions to improve new and existing Data warehouse solutions.

* Ensure solutions are scalable and adaptable for future modifications, considering the organization's goals.

* Understand and document data flows in and between different systems/applications

* Act as Data domain expert for Snowflake in a collaborative environment to provide demonstrated understanding of data management best practices and patterns.

* Implement cloud-based Enterprise data warehouse solutions with multiple data platforms along with Snowflake environment to build data movement strategy.

* Collaborate with project managers and developers to guide development processes in line with solution requirements.

* Lead in Developing Project requirements for end-to-end Data integration process using ETL for Structured, semi-structured and Unstructured Data.

* Make necessary on-going updates to modelling principles, processes, solutions, and best practices to ensure that the Snowflake is aligned with business needs of the environment.

* Guidance to developers in preparing functional/technical specs to define reporting requirement and ETL process.

* Educate staff members through training and individual support.

* Offer support by responding to system problems in a timely manner.

Required Skills/Experience:

* Bachelor’s degree in computer science or a related field

* Telecom experience is must

* Proven experience as a Snowflake Subject Matter Expert, with a proven track record of experience in designing, implementing, and maintaining Snowflake data warehousing solutions

* In-depth knowledge of Snowflake architecture, including Snowflake data warehousing, data sharing, and data integration

* Experience with ETL and data integration tools, such as Talend, Informatica, or Matillion

* Strong SQL skills, with the ability to write complex queries and optimize query performance

* Strong problem-solving and analytical skills, with the ability to troubleshoot and resolve complex technical issues

* Experience with data governance and data security principles

* Snowflake certification is a plus

Apply now for immediate consideration