Snowflake Data Engineer

Job Title: Snowflake Data Engineer
Location: London (2 days on-site per week)
Salary/Rate: 550 - 600 per day inside IR35
Start Date: March
Job Type: Initial 3-6 month contract

Company Introduction
We have an exciting opportunity now available with one of our sector-leading consultancy clients! They are currently looking for a skilled Snowflake Data Engineer to help on their cloud migration project.

Job Responsibilities/Objectives
You will be responsible for designing and building scalable data pipelines, Data Vault models/Dimension Model, and Snowflake/dbt workloads for cloud migration projects.

? Implement Data Vault 2.0 (Hubs, Links, Satellites) /Dimension Model on Snowflake.
? Build ELT pipelines using Snowflake, dbt, Python/PySpark.
? Develop ingestion from APIs, databases, streams.
? Optimize Snowflake warehouses, cost, and performance.
? Collaborate with architects, analysts, and Dev Ops.
? Maintain documentation, lineage, governance standards.

Required Skills/Experience
The ideal candidate will have the following:

? Strong SQL;
Snowflake ELT; dbt experience.
? Python/PySpark, ETL/ELT design.
? Data Vault 2.0 or dimensional modeling.
? AWS services (S3, Glue, Lambda, Redshift) or GCP equivalents.
? Experience with CI/CD for data pipelines.

Good to have skills
Although not essential, the following skills are desired by the client:

? Kafka/Kinesis, Airflow, Code Pipeline.
? BI tools (Power BI/Tableau).
? Docker/Open Shift; metadata driven pipelines.

? 3-8+ years Data Engineering experience.
? Cloud data engineering and Snowflake/dbt hands on exposure.

If you are interested in this opportunity, please apply now with your updated CV in Microsoft Word/PDF format.

Disclaimer
Notwithstanding any guidelines given to level of experience sought, we will consider candidates from outside this range if they can demonstrate the necessary competencies.
Square One is acting as both an employment agency and an employment business, and is an equal opportunities recruitment business. Square One embraces diversity and will treat everyone equally. Please see our website for our full diversity statement.