Snowflake Data Engineer

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).
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