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