At a Glance
- Tasks: Lead the design and build of Snowflake data pipelines for a major cloud transformation.
- Company: Leading data consultancy partnering with a large enterprise organisation.
- Benefits: Competitive daily rate, remote work, and potential for contract extension.
- Other info: Ideal for engineers who love hands-on problem-solving in a dynamic environment.
- Why this job: Own your workstream and make a real impact on data solutions.
- Qualifications: Strong Snowflake and dbt experience, with solid data modelling skills.
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. This is a genuinely hands-on leadership role, best suited to an engineer who enjoys designing and building production-grade data solutions.
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 Role: 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.
Key Responsibilities:
- 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 deliverables.
Essential Skills and Experience:
- Strong Snowflake engineering experience, including hands-on design and build of production workloads.
- 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.
- Comfortable operating as a technical lead while remaining hands-on with the build.
- Able to work independently and make confident decisions within a fast-moving programme.
- Strong communication skills, with the ability to engage effectively with both technical and non-technical stakeholders.
Desirable Experience:
- Experience with WhereScape RED and SQL Server, particularly the ability to pick apart and reverse-engineer an existing legacy ETL setup.
- Experience working within insurance or other regulated environments.
- 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.
Engagement Details:
- IR35 status: Outside IR35
- Working pattern: 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.
- Availability: Candidates who can start early July are strongly preferred.
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.
Senior Data Engineer in Nottingham employer: Primus Connect
Join a leading data consultancy that values innovation and autonomy, offering a dynamic work culture where your expertise as a Senior Data Engineer will directly impact the transformation of a major cloud data platform. With a focus on employee growth, you will have the opportunity to lead hands-on projects, collaborate with diverse teams, and develop cutting-edge solutions in a predominantly remote environment, ensuring a healthy work-life balance. This role not only provides competitive compensation but also the chance to be part of a meaningful migration project that enhances your skills and career trajectory.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Data Engineer in Nottingham
✨Tip Number 1
Network like a pro! Reach out to your connections in the data engineering field, especially those who might know about opportunities at companies you're interested in. A personal referral can make all the difference in getting noticed.
✨Tip Number 2
Prepare for interviews by brushing up on your technical skills and understanding the latest trends in data engineering. Be ready to discuss your hands-on experience with Snowflake and dbt, as well as how you've tackled challenges in past projects.
✨Tip Number 3
Showcase your problem-solving skills during interviews. Be prepared to walk through your thought process when designing and building data pipelines. Employers love to see how you approach real-world engineering problems!
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you're serious about joining our team and contributing to exciting projects.
We think you need these skills to ace Senior Data Engineer in Nottingham
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 and dbt experience, and don’t forget to showcase any hands-on projects you've led!
Craft a Compelling Cover Letter:Use your cover letter to tell us why you're the perfect fit for this role. Share specific examples of how you've tackled similar challenges in the past, especially around data migration and pipeline design.
Show Off Your Technical Skills:In your application, be sure to mention your strong SQL skills and any relevant experience with data modelling. We want to see how you’ve applied these skills in real-world scenarios, so don’t hold back!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for this exciting opportunity right away!
How to prepare for a job interview at Primus Connect
✨Know Your Snowflake Inside Out
Make sure you brush up on your Snowflake skills before the interview. Be ready to discuss your hands-on experience with designing and building production workloads, as well as any challenges you've faced and how you overcame them.
✨Understand the Legacy Environment
Familiarise yourself with WhereScape RED and SQL Server, even if it's not a strict requirement. Being able to articulate how you would analyse and reverse-engineer the existing setup will show your problem-solving skills and technical depth.
✨Showcase Your Data Modelling Skills
Prepare to discuss your approach to data modelling and design. Highlight specific examples where you've re-architected data structures for new platforms, focusing on how you ensure clean, maintainable transformation logic.
✨Communicate Effectively
Since this role involves working closely with both technical and non-technical stakeholders, practice explaining complex concepts in simple terms. Demonstrating strong communication skills can set you apart from other candidates.
