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