Snowflake Data Engineer

Morson Talent; United Kingdom; Remote; GBP 60,000 - 80,000; Full time

Job summary

A leading recruitment agency is seeking a Snowflake Data Engineer to support a migration to Snowflake. The role involves developing and optimizing data models using SQL, Python, and DBT, with opportunities to work on cutting-edge data engineering projects. This position is primarily remote with occasional travel to Hemel Hempstead and offers a day rate of up to £550 for a 6-month contract.

Qualifications

• Experience in advanced SQL.
• SnowFlake certification is preferred.
• Strong Python development skills are essential.
• AWS cloud experience related to data tooling is a must.
• Proficient in Data Build Tool (DBT).

Responsibilities

• Develop staging, intermediate, and marts in DBT for analytics.
• Optimize existing models for reusability following DBT best practices.
• Identify opportunities for incremental models over full refresh.
• Organize and document sources in DBT.
• Develop DBT macros for frequently repeated tasks.

Skills

Advanced SQL knowledge

SnowFlake (ideally certified)

Python development

AWS cloud experience

DBT knowledge

Job description

Overview

Snowflake Data Engineer

Location: Remote (Mostly remote with some occasional travel to Hemel Hempstead)

Contract: Outside IR35

Day rate: Up to £550 per day

Duration: 6 months

Start date: ASAP

Key skills: Snowflake, DBT, SQL, Python, AWS and Kimball

The Client who are in the process of migrating to SnowFlake therefore require extra support. As a result, they require someone from a strong SQL & Python development background with excellent working knowledge of Data Build Tool (DBT).

You will be undertaking aspects of the development lifecycle and be experienced in data modeling, process design, development, and testing. And whilst this company is going through a large-scale migration, this will present you with an opportunity to be at the cutting edge of data engineering.

Your Skills and Experience

A successful Senior Data Engineer here will have experience in the following:

• Advanced SQL knowledge
• SnowFlake (ideally certified)
• Python development
• AWS cloud experience essential, relating to data tooling and development
• Working knowledge of Data Build Tool (DBT)

• Develop staging, intermediate and marts in DBT to achieve analytics requirements
• Optimize existing models to make it more reusable by following DBT best practices
• Spot opportunities for the models to be incremental over full refresh
• Organize sources and document sources in DBT
• Develop DBT macros for most frequently repeated tasks

• Knowledge of Continuous Integration and Continuous Deployment (CI/CD)
• Development experience in one or more object-oriented programming languages (e.g. Python)
• Ability to work with senior stakeholders across multiple verticals