At a Glance
- Tasks: Lead the design and delivery of large-scale data solutions for critical business decisions.
- Company: Join a tech-for-good company in Edinburgh committed to diversity and inclusion.
- Benefits: Enjoy a salary up to £90,000, flexible working, and a 15% non-contributory pension.
- Why this job: Be part of a supportive team that values career progression and impactful work.
- Qualifications: Strong SQL, ELT experience, and familiarity with AWS and data engineering principles required.
- Other info: Interviews happening next week; apply now to join a people-first organisation!
The predicted salary is between 68000 - 72000 £ per year.
Salary: £85,000–£90,000 + Up to 10% Bonus + 15% Non-Contributory Pension
Location: Hybrid working (3 days P/W On-Site) | Edinburgh
Level: Lead
We’re looking for a Lead Data Engineer to play a key role in expanding our client's data-driven capabilities and driving the evolution of our enterprise data ecosystem. This is a strategic, hands-on position where you’ll lead the design and delivery of large-scale data solutions that power critical business decisions.
You’ll work with a high-performing Data & Analytics team on mission-critical systems across Data Warehousing, Data Lakes, BI platforms, and advanced analytics. The role offers the opportunity to influence architecture, improve existing processes, and collaborate closely with business and technical teams.
- Leading the design, build, and optimisation of robust data pipelines and platforms
- Enhancing and scaling existing Data Warehouse, Data Lake, and BI systems
- Driving end-to-end delivery across ingestion, modelling, transformation, and governance
- Collaborating with architects, technical leads, and business stakeholders across functions
- Driving a culture of data excellence and continuous improvement
About You:
You’re a highly motivated and analytical data professional who thrives on solving complex problems and delivering scalable solutions that create real business impact. You’re proactive, hands-on, and comfortable working across both technical and business domains.
Key technical skills:
- Strong SQL and ELT/data pipeline development experience
- Expertise in Data Warehouse & Data Lake design (including Star Schema, Snowflake Schema, Data Vault)
- Hands-on experience with enterprise databases: Oracle, Snowflake, Teradata, or SQL Server
- Solid understanding of AWS (S3, Lambda, IAM, etc.)
- Proficiency in Python (especially working with Boto3 and AWS APIs)
- Familiarity with data replication tools (e.g., AWS DMS)
- Understanding of MLOps and modern data science platforms is a plus
- Experience working in Agile environments
What we offer:
- Up to £90,000 + discretionary annual bonus
- 28 days holiday (with options to buy/sell days)
- 15% non-contributory pension scheme
- Private medical insurance and extensive wellbeing support
- Flexible working with modern, collaborative office environments
- Family-friendly policies, employee benefit schemes, and more
About the client:
SR2 have an exclusive, brand new Lead Data Engineering opportunity in Edinburgh with a "tech for good" business. These folks are expanding their Data team further, growing the team to deliver solutions for an impactful product. We love working with this client for many reasons, but a big alignment of our values is their commitment to diversity & inclusion.
Looking to join an Edinburgh based company with a supportive and empathetic environment? Look no further! This is an opportunity to join a larger sized and stable organisation, who are extremely people first and provide significant career progression and development for their employees.
Interviews will be happening across next week. If you’re interested, please apply to this advert or reach out to Adam Townsend: 01173 164195 adam@sr2rec.co.uk
Lead Data Engineer employer: SR2 | Socially Responsible Recruitment | Certified B Corporation™
Contact Detail:
SR2 | Socially Responsible Recruitment | Certified B Corporation™ Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Lead Data Engineer
✨Tip Number 1
Familiarise yourself with the specific technologies mentioned in the job description, such as SQL, AWS, and Python. Being able to discuss your hands-on experience with these tools during the interview will demonstrate your technical expertise and readiness for the role.
✨Tip Number 2
Prepare examples of past projects where you led the design and delivery of data solutions. Highlight your ability to collaborate with both technical and business teams, as this is crucial for the Lead Data Engineer position.
✨Tip Number 3
Research the company’s commitment to diversity and inclusion. Be ready to discuss how you can contribute to fostering a culture of data excellence and continuous improvement within their team.
✨Tip Number 4
Since the role involves hybrid working, think about how you can effectively communicate and collaborate in both remote and on-site settings. Prepare to share your strategies for maintaining productivity and teamwork in a flexible work environment.
We think you need these skills to ace Lead Data Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in data engineering, particularly focusing on SQL, ELT/data pipeline development, and your familiarity with Data Warehousing and Data Lakes. Use specific examples to demonstrate your expertise.
Craft a Compelling Cover Letter: Write a cover letter that showcases your passion for data engineering and your alignment with the company's values, especially their commitment to diversity and inclusion. Mention how your skills can contribute to their mission of delivering impactful solutions.
Highlight Technical Skills: In your application, clearly outline your technical skills such as proficiency in Python, experience with AWS services, and knowledge of data replication tools. This will help you stand out as a candidate who meets the key requirements of the role.
Showcase Problem-Solving Abilities: Provide examples in your application that demonstrate your analytical skills and ability to solve complex problems. Discuss any previous projects where you successfully delivered scalable data solutions that had a significant business impact.
How to prepare for a job interview at SR2 | Socially Responsible Recruitment | Certified B Corporation™
✨Showcase Your Technical Skills
As a Lead Data Engineer, you'll need to demonstrate your expertise in SQL, ELT/data pipeline development, and data warehousing. Be prepared to discuss specific projects where you've successfully implemented these skills, and consider bringing examples of your work to the interview.
✨Understand the Business Impact
It's crucial to convey how your technical solutions have driven business decisions in the past. Prepare to share examples of how your data engineering efforts have led to measurable outcomes, showcasing your ability to bridge the gap between technical and business domains.
✨Emphasise Collaboration
This role involves working closely with architects, technical leads, and business stakeholders. Highlight your experience in collaborative environments and be ready to discuss how you’ve successfully worked with cross-functional teams to deliver data solutions.
✨Prepare for Scenario-Based Questions
Expect scenario-based questions that assess your problem-solving abilities and technical knowledge. Think through potential challenges you might face in the role and how you would approach them, particularly in areas like data governance and pipeline optimisation.