Senior Snowflake Implementation Consultant - Contractor Position
Senior Snowflake Implementation Consultant - Contractor Position

Senior Snowflake Implementation Consultant - Contractor Position

Full-Time 54000 - 84000 ÂŁ / year (est.) No home office possible
A

At a Glance

  • Tasks: Lead the migration to Snowflake, optimising data processes and ensuring seamless integration.
  • Company: Join a forward-thinking company focused on innovative data solutions.
  • Benefits: Competitive pay, flexible hours, and the chance to work on exciting projects.
  • Why this job: Make a real impact in data engineering while working with cutting-edge technology.
  • Qualifications: Advanced Snowflake skills and experience in data engineering or analytics required.
  • Other info: Dynamic project with opportunities for professional growth and collaboration.

The predicted salary is between 54000 - 84000 ÂŁ per year.

We are seeking a Senior Data Engineer with extensive infrastructure implementation experience, especially with Snowflake and connected applications to lead technical delivery of our Snowflake migration project. To help us migrate from an in-house developed data warehouse to Snowflake as our core data infrastructure, supporting multiple client and 1P integrations as well as our own reporting visualisation solution, Seer.

Key Responsibilities

  • Design and implement a Snowflake environment in line with an agreed migration strategy.
  • Plan how to map nested JSON documents into Snowflake, documenting trade‑offs and recommendations.
  • Present architectural decisions and collaborate during planning stages.
  • Configure Snowflake warehouses, roles, and security policies using Terraform or similar tools.
  • Execute the migration of historical marketing data (TB scale) from AWS/Mongo to Snowflake, ensuring high data parity.
  • Build the “connective tissue” between the Seer frontend and Snowflake, extending the existing Seer Data API (FastAPI).
  • Optimize Snowflake query performance, including clustering and materialized views.
  • Implement a security model that maps Seer’s user management to Snowflake Row‑Level Security or Dynamic Data Masking.
  • Migrate ELT pipelines (dbt, Airflow, Fivetran) to ingest data from 3rd‑party marketing APIs into Snowflake.
  • Contribute to CI/CD, version control (Git), and best‑practice development standards.

Project Plan Overview

  • Months 1‑2: Discovery, foundation, Snowflake environment setup, naming conventions.
  • Months 3‑4: Migration & modelling, historical data movement, dbt models.
  • Month 5: BI integration, Seer front‑end, dashboards, stakeholder validation.
  • Month 6: Handoff, documentation, training, performance monitoring.

Qualifications

  • Advanced Snowflake qualifications.
  • Extensive experience in a data engineering or analytics engineering role, with marketing analytics exposure strongly preferred.
  • Bachelor’s or Master’s degree in Computer Science, Data Engineering, Statistics, or related.
  • Strong programming skills in Python and SQL; familiarity with Java, Scala, or other languages.
  • Proficiency in ETL tools and frameworks (Apache Airflow, dbt).
  • Experience with data visualisation tools (Tableau, Power BI).
  • Familiarity with cloud platforms (AWS, GCP, Azure) and data warehouse technologies.
  • Knowledge of database design principles and query optimisation.
  • Experience with Git and CI/CD pipelines.
  • Excellent problem‑solving and communication skills.

Budget and Application

This project will have a fixed budget and timeline, agreed with the consultant. We would welcome a cost estimate based on the details and assumptions set out in the document. For shortlisted applicants, there will be an opportunity to discuss the plan in more detail and revise the plan, time‑scales and budget.

Senior Snowflake Implementation Consultant - Contractor Position employer: Agent3 Group

Join a forward-thinking company that values innovation and collaboration, where as a Senior Snowflake Implementation Consultant, you will play a pivotal role in transforming our data infrastructure. We offer a dynamic work culture that encourages professional growth through hands-on experience with cutting-edge technologies, alongside competitive compensation and flexible working arrangements. Located in a vibrant area, our team thrives on creativity and teamwork, making it an ideal environment for those seeking meaningful and rewarding employment.
A

Contact Detail:

Agent3 Group Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Senior Snowflake Implementation Consultant - Contractor Position

✨Tip Number 1

Network like a pro! Reach out to your connections in the data engineering field, especially those who have experience with Snowflake. A friendly chat can lead to insider info about job openings or even referrals.

✨Tip Number 2

Show off your skills! Create a portfolio showcasing your past projects, especially any Snowflake implementations or data migrations. This will give potential employers a taste of what you can bring to the table.

✨Tip Number 3

Prepare for interviews by brushing up on common Snowflake scenarios and challenges. Be ready to discuss how you've tackled similar issues in the past, as this will demonstrate your expertise and problem-solving abilities.

✨Tip Number 4

Don't forget to apply through our website! We love seeing candidates who are genuinely interested in joining us. Plus, it makes the application process smoother for everyone involved.

We think you need these skills to ace Senior Snowflake Implementation Consultant - Contractor Position

Snowflake
Data Engineering
Infrastructure Implementation
JSON Mapping
Terraform
AWS
MongoDB
FastAPI
Query Optimisation
Row-Level Security
Dynamic Data Masking
ELT Pipelines
Apache Airflow
dbt
Data Visualisation

Some tips for your application 🫡

Tailor Your Application: Make sure to customise your CV and cover letter to highlight your experience with Snowflake and data engineering. We want to see how your skills align with the specific requirements of the role, so don’t hold back!

Showcase Your Projects: If you've worked on relevant projects, especially those involving Snowflake or similar technologies, be sure to mention them. We love seeing real-world examples of your work and how you tackled challenges.

Be Clear and Concise: When writing your application, keep it straightforward. Use clear language and avoid jargon unless it's necessary. We appreciate a well-structured application that gets straight to the point!

Apply Through Our Website: For the best chance of getting noticed, make sure to apply through our website. It helps us keep track of applications and ensures you’re considered for the role. We can’t wait to hear from you!

How to prepare for a job interview at Agent3 Group

✨Know Your Snowflake Inside Out

Make sure you brush up on your Snowflake knowledge before the interview. Understand its architecture, features, and best practices for implementation. Be ready to discuss how you've used Snowflake in past projects, especially in relation to data migration and performance optimisation.

✨Showcase Your Problem-Solving Skills

Prepare to share specific examples of challenges you've faced in previous roles, particularly around data engineering and analytics. Highlight how you approached these problems, the solutions you implemented, and the outcomes. This will demonstrate your critical thinking and technical expertise.

✨Familiarise Yourself with the Tools

Since the role involves tools like Terraform, dbt, and Airflow, make sure you're comfortable discussing your experience with these technologies. If you have any relevant projects or achievements, be ready to talk about them. This shows that you’re not just familiar with the tools but can also leverage them effectively.

✨Prepare for Collaborative Discussions

Given the collaborative nature of the role, think about how you can contribute to team discussions. Be prepared to present architectural decisions and engage in planning conversations. Practising how to communicate your ideas clearly will help you stand out as a strong team player.

Senior Snowflake Implementation Consultant - Contractor Position
Agent3 Group

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

A
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>