Snowflake SME

Position : Snowflake SME - Technical Consultant

Location : Milton Keynes, UK

Workplace Type : Hybrid, required 2-3 days onsite

Employment Type : Fulltime Permanent

About Company:

Prodapt is the largest & fastest growing specialized firm serving in Connectedness vertical.

Present across 5 continents, delivering futuristic solutions & AI-driven services to global CSPs, and digital platform & software firms. Prodapt’s customers range from telecom operators, digital/multi-service providers (D/MSPs), technology and digital platform companies in the business of connectedness. Prodapt builds, integrates, and operates solutions enabling next-generation technologies and innovations.

Overview

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

Roles & Responsibilities

• 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 modeling 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.

Requirements

• Bachelor’s degree in computer science or a related field
• Telecom experience is must
• Proven experience as a Snowflake Subject Matter Expert, with at least 6 years 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
• Excellent communication and interpersonal skills, with the ability to work effectively in a team environment
• 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

Interview Process:

2-3 Technical Interview with Internal Team & Client.

Share CV with vanipenta.v@prodapt.com