Lead Data Engineer in Holytown

Lead Data Engineer in Holytown

Holytown Full-Time 36000 - 60000 £ / year (est.) No working from home possible
Scottish Environment Protection Agency

At a Glance

  • Tasks: Lead the delivery and maintenance of SEPA's data platform and products.
  • Company: Join SEPA, a passionate organisation dedicated to protecting Scotland's environment.
  • Benefits: Enjoy hybrid working, up to 35 days leave, and wellbeing support.
  • Other info: Flexible working arrangements and commitment to diversity and inclusion.
  • Why this job: Make a real impact on environmental projects while advancing your career.
  • Qualifications: Degree in relevant field and strong leadership skills required.

The predicted salary is between 36000 - 60000 £ per year.

We are recruiting for a full time Lead Data Engineer on a permanent basis. Your passion has never had a greater purpose. Here at SEPA, we are connected by a passion that drives us to be purposeful in every action we take – to protect our environment. Through our expertise, we lead projects that make a difference for Scotland, and our workplaces are grounded in respect for that expertise.

When you join us as Lead Data Engineer, you will discover enriching benefits, meaningful support, and opportunities to learn every day. That is what it means to be Passionately Purposeful – for our environment, and for your career.

As a Lead Data Engineer, you will lead on the delivery and maintenance of SEPA's data platform and data products, ensuring that analytical and operational solutions are reliable, secure and meet stakeholder needs. You will:

  • Collaborate with data customers, subject matter experts and data architects to deliver data sources, integrated datasets, and data & analytics services.
  • Drive the development, testing and maintenance of data pipelines, warehouses, lakes, semantic models and reports.
  • Implement security and access controls for data at rest and in motion.
  • Define and apply engineering standards, quality assurance and agile practices in all delivery.
  • Provide guidance to the team and promote adherence to best practices.

This is a highly important role within our Governance, Performance & Engagement portfolio, which means you will need:

  • Degree in a relevant discipline or equivalent experience.
  • Proven strong communication, teamwork and leadership skills, with a track record of mentoring colleagues, defining data engineering standards and delivering successful data engineering projects.
  • Comprehensive knowledge of common data architectures and modelling (warehousing, data lake, medallion, data mesh, 3NF, dimensional / Kimball).
  • Significant experience with the Azure stack (Fabric, Databricks, Power BI, Synapse, Delta Lake, PySpark / SparkSQL, SQL DW, Purview, Log Analytics, EntraID).
  • Proven experience with agile delivery and DevOps practices (IaC, testing, monitoring, version control).

We are cultivating a workplace that supports not only your passion and your professional lives, but your personal life. You will find benefits that make a difference at work and at home, such as:

  • Hybrid and Flexible working opportunities.
  • Up to 35 days annual leave and 7 additional public holidays each year (pro rata).
  • Paid time off to support your Wellbeing and enable you to Volunteer in your community.
  • Local Government Pension Scheme (LGPS).
  • Progressive Family Friendly policies.
  • Training & development to enable colleagues to improve their skills, competencies and knowledge to perform at their best.
  • Plus, many more lifestyle benefits such as 24/7 access to an online employee discount platform, credit union facilities and access to a Cycle to Work Scheme.

SEPA is committed to promoting equality, diversity, and good relations in everything it does – as a community leader, as a provider and commissioner of services, and as an employer. We recruit solely based on merit. Our shortlisting process is conducted on an anonymous basis. Please ensure that you include all relevant information when you apply.

We support flexible working arrangements to help you maintain a healthy balance between career and homelife. This includes working part time, reduced hours, job sharing, working remotely. As a flexible first employer we are open to having conversations about flexible working arrangements that work for you and SEPA from day 1 of your employment with us.

We are proud to be a 'Disability Confident' employer and will work to identify and implement reasonable adjustments and equipment to support you in the role that you do. For the security and wellbeing of our colleagues, successful candidates will undergo Baseline Personnel Security Standard (BPSS) pre-employment checks including a level one Disclosure Scotland check.

If you have questions or need any assistance with the recruitment process please contact SEPA's Recruitment Team.

Lead Data Engineer in Holytown employer: Scottish Environment Protection Agency

At SEPA, we are not just an employer; we are a community dedicated to making a meaningful impact on Scotland's environment. As a Lead Data Engineer, you will benefit from a supportive work culture that prioritises your professional growth and personal wellbeing, offering flexible working arrangements, generous leave policies, and comprehensive training opportunities. Join us in a role where your expertise is respected, and your contributions truly matter.

Scottish Environment Protection Agency

Contact Details:

Scottish Environment Protection Agency Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Lead Data Engineer in Holytown

Network Like a Pro

Get out there and connect with people in the industry! Attend meetups, webinars, or even local events related to data engineering. You never know who might have a lead on your dream job at SEPA!

Show Off Your Skills

When you get the chance to chat with potential employers, don’t hold back! Share your experiences with Azure, data pipelines, and agile practices. Let them see how your expertise can make a difference for their team.

Prepare for the Interview

Do your homework on SEPA and its projects. Be ready to discuss how your skills align with their mission to protect the environment. Tailor your answers to show that you’re not just a fit for the role, but also for their culture.

Apply Through Our Website

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 genuinely interested in joining our Passionately Purposeful team.

We think you need these skills to ace Lead Data Engineer in Holytown

Data Engineering
Data Architecture
Data Modelling
Azure Stack
Databricks
Power BI
SQL DW

Some tips for your application 🫡

Show Your Passion:When writing your application, let your passion for data engineering and environmental protection shine through. We want to see how your values align with our mission at SEPA!

Tailor Your CV:Make sure to customise your CV to highlight relevant experience and skills that match the Lead Data Engineer role. We love seeing how your background fits into our needs!

Be Clear and Concise:Keep your application clear and to the point. Use straightforward language to describe your achievements and experiences, so we can easily see what you bring to the table.

Apply Through Our Website:Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for this exciting opportunity.

How to prepare for a job interview at Scottish Environment Protection Agency

Know Your Data Inside Out

As a Lead Data Engineer, you'll need to demonstrate your comprehensive knowledge of data architectures and modelling. Brush up on common frameworks like data lakes and dimensional models, and be ready to discuss how you've applied these in past projects.

Showcase Your Leadership Skills

This role requires strong communication and teamwork abilities. Prepare examples of how you've mentored colleagues or led successful data engineering projects. Highlight your experience in defining standards and promoting best practices within a team.

Familiarise Yourself with the Azure Stack

Since significant experience with the Azure stack is essential, make sure you can talk confidently about tools like Databricks, Power BI, and Synapse. Be ready to share specific instances where you've used these technologies to solve problems or improve processes.

Emphasise Agile and DevOps Practices

The interviewers will be keen to hear about your experience with agile delivery and DevOps. Prepare to discuss how you've implemented Infrastructure as Code (IaC), testing, and version control in your previous roles, and how these practices have improved project outcomes.