Snowflake Data Engineer

Snowflake Data Engineer
Location: Hybrid (Mostly remote with some occasional travel to Hemel Hempstead)
Contract: Outside IR35
Day rate: Up to £650 per day
Duration: 6 months
Start date: ASAP
Key skills: Snowflake, DBT, SQL, Python, AWS and if possibly Terraform
The Client who has a global presence within the hospitality industry 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
• Python development
• AWS cloud experience essential, relating to data tooling and development
• Working knowledge of Data Build Tool (DBT).
o Develop staging, intermediate and marts in DBT to achieve analytics requirements
o Optimize existing models to make it more reusable by following DBT best practices
o Spot opportunities for the models to be incremental over full refresh
o Organize sources and document sources in DBT
o 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