At a Glance
- Tasks: Lead the design and build of Snowflake data pipelines, transforming legacy systems into modern solutions.
- Company: A leading data consultancy driving major cloud data transformations.
- Benefits: Remote work flexibility, competitive contract rates, and potential for extension.
- Other info: Ideal for those who thrive on autonomy and delivering robust engineering solutions.
- Why this job: Own your workstream and make a real impact in a high-stakes data transformation project.
- Qualifications: Experience with dbt, SQL, and data modelling; strong problem-solving skills required.
The predicted salary is between 60000 - 80000 £ per year.
A leading data consultancy is partnering with a large enterprise organisation to deliver a major cloud data platform programme. As part of this transformation, we are looking to bring in an experienced Snowflake Technical Lead to take full ownership of a key delivery workstream. It is best suited to an engineer who enjoys designing and building production-grade data solutions, rather than someone who wants to operate purely in architecture review or governance discussions. You will be trusted with real autonomy over implementation decisions while remaining clearly accountable for delivery outcomes.
Project Context
This is a decommissioning and migration project. The organisation is retiring a legacy data setup and rebuilding its pipelines on Snowflake. The work spans the full picture, with a meaningful element of data modelling and design as pipelines are re-architected for the new platform. The legacy environment being dismantled is built on WhereScape RED and SQL Server. A core part of the project involves understanding that existing setup, unpicking how it works, and re-implementing the equivalent logic cleanly within Snowflake and dbt.
You will lead the technical delivery of a data pipeline workstream within Snowflake, operating as part of a wider transformation programme that is modernising the organisation's core data capabilities. You will own your workstream end-to-end — from analysing the legacy implementation, through data modelling and design, build, validation, deployment, and operational hardening, while working closely with delivery leads and stakeholders to keep momentum across the programme.
- Analyse the legacy environment, picking apart the existing WhereScape RED and SQL Server implementation to understand current data flows and logic ahead of migration.
- Design and build Snowflake data pipelines end-to-end, rebuilding legacy pipelines and taking source data through to consumable, well-modelled outputs.
- Carry out data modelling and design, re-architecting data structures for Snowflake rather than simply lifting and shifting the legacy approach.
- Implement transformation logic using dbt, applying sound modelling practices, modular design, and maintainable, well-documented code.
- Apply validation rules and data quality controls to ensure the accuracy, completeness, and reliability of data moving through the pipeline.
- Design logging, monitoring, and failure-handling approaches so that pipelines are observable, resilient, and straightforward to operate and troubleshoot.
- Support deployment and CI/CD across environments, helping to ensure changes are released in a controlled, repeatable, and low-risk manner.
- Work closely with delivery leads and stakeholders to communicate progress, surface risks early, and keep the workstream aligned with programme priorities.
- Make and own implementation decisions, exercising technical judgement while remaining accountable for the quality and timeliness of delivery.
Requirements:
- Solid dbt experience and advanced SQL skills, with a focus on clean, maintainable transformation logic.
- Solid data modelling and design experience, with the ability to re-architect data structures rather than simply replicate a legacy design.
- A proven track record of delivering production data pipelines into live environments.
- Experience with WhereScape RED and SQL Server, particularly the ability to pick apart and reverse-engineer an existing legacy ETL setup.
- Familiarity with cloud data platform programmes and large-scale migration or decommissioning delivery.
- Exposure to data governance, security, or compliance considerations within a regulated setting.
Predominantly remote with occasional on-site presence as required by the programme. Contract length: Initial contract with strong extension potential, dependent on programme progress and performance. This opportunity is ideal for a senior data engineer or technical lead who enjoys owning delivery, solving real engineering problems, and seeing a workstream through from design to a robust, operational outcome. If you take pride in building solutions and want the autonomy to do it well within a high-impact programme, this role is for you.
Senior Engineer, Data Engineering employer: Primus Connect
Join a leading data consultancy that values innovation and autonomy, offering you the chance to take full ownership of your workstream in a transformative cloud data platform programme. With a strong focus on employee growth, a collaborative work culture, and the flexibility of remote work, this role provides an excellent opportunity for experienced engineers to thrive while contributing to meaningful projects that modernise core data capabilities.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Engineer, Data Engineering
✨Tip Number 1
Network like a pro! Reach out to your connections in the data engineering field and let them know you're on the lookout for opportunities. You never know who might have a lead or can put in a good word for you.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your past projects, especially those involving Snowflake and dbt. This will give potential employers a clear view of what you can bring to the table.
✨Tip Number 3
Prepare for interviews by brushing up on your technical knowledge and problem-solving skills. Be ready to discuss how you've tackled challenges in previous roles, particularly around data migration and pipeline design.
✨Tip Number 4
Don't forget to apply through our website! We make it easy for you to find roles that match your skills and interests. Plus, it shows you're serious about joining our team!
We think you need these skills to ace Senior Engineer, Data Engineering
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experiences that match the Senior Data Engineer role. Highlight your Snowflake expertise, data modelling experience, and any relevant projects you've led. We want to see how you can bring value to our team!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about this role and how your background aligns with our needs. Share specific examples of your past successes in data engineering to grab our attention.
Showcase Your Technical Skills:Since this role requires solid dbt and SQL skills, don’t shy away from mentioning specific projects where you’ve used these technologies. We love seeing real-world applications of your skills, so be detailed about your contributions and outcomes.
Apply Through Our Website:We encourage you to apply directly through our website for a smoother application process. It helps us keep track of your application and ensures you’re considered for the role. Plus, it’s super easy to do!
How to prepare for a job interview at Primus Connect
✨Know Your Snowflake Inside Out
Make sure you brush up on your Snowflake knowledge before the interview. Be ready to discuss your experience with designing and building data pipelines in Snowflake, as well as any challenges you've faced and how you overcame them. This will show that you're not just familiar with the platform but can also leverage it effectively.
✨Understand the Legacy Environment
Since this role involves decommissioning a legacy setup, it's crucial to understand WhereScape RED and SQL Server. Prepare to talk about how you've previously analysed and reverse-engineered existing systems. Highlight specific examples where you've successfully migrated or re-architected data structures.
✨Showcase Your Data Modelling Skills
Be ready to discuss your approach to data modelling and design. Bring examples of how you've re-architected data structures for new platforms rather than just replicating old designs. This will demonstrate your ability to think critically and innovate in your solutions.
✨Communicate Like a Pro
Effective communication is key in this role, especially when working with delivery leads and stakeholders. Practice articulating your thought process clearly and concisely. Be prepared to discuss how you've kept projects aligned with priorities and communicated progress in past roles.
