Description
Our Telecoms client is looking for an experienced Snowflake Engineer to join their team in Milton Keynes. This is a 3 months contract initially and it is outside IR35. Hybrid model - 2 days per week on site in Milton Keynes and the rest of the week remote.
Overview:
The role is responsible for designing business processes as per customer needs, strategizing cloud architecture and migration, and upholding client's winning values and contributing to the company's vision.
Requirements:
- 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 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.
- 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.
- Offer support by responding to system problems in a timely manner.
Experience:
- Proven experience as a Data Engineer with expertise in designing and implementing data solutions on Snowflake.
- In-depth knowledge of Snowflake's features (ELT using Snowpipe, implementing stored procedures, setting up resource monitors, RBAC controls, virtual warehouse, query performance tuning, Zero copy clone, time travel), functionalities; understand how to use these features.
- Understanding of data security, encryption, access controls (RBAC, authentication & authorization), compliance standards (GDPR, HIPAA).
- Proficiency in SQL; scripting languages (e.g., Python; Bash) experience optimizing queries for performance.
- Experience with cloud technologies (AWS; Azure; or GCP) integration tools.
- Experience in Data Migration from various sources to Snowflake cloud data warehouse.
- Experience working with code repositories; continuous integration & continuous deployment.
- Excellent problem-solving skills ability communicate complex technical concepts nontechnical stakeholders.
- Relevant certifications qualifications Snowflake related fields are a plus. Experience Telecom Fibre domain will be advantage.
Roles & Responsibilities:
Business Process Design: Designing one or more business processes as per customer needs
Requirement Management: Creating High-level Low-level design documents collaboration senior architects COTS solution
Product Analysis: Performing functionality analysis designing solutions around customizations identifying interfaces integration considerations
Cloud data platform setup: design data lake platforms products like Snowflake