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