Lead Data Engineer

Lead Data Engineer

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 aLead Data Engineerto 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.

🔧 What you’ll be doing:

• 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 a Edinurgh 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: