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