Lead Data Engineer
Role details
Job location
Tech stack
Job description
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., 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.
Passionately Purposeful about Scotland's environment - and your career.
Protecting our environment, promoting our work, and supporting our people, working at SEPA means being part of an organisation that's grounded in respect for your expertise - and your wellbeing. So you can be your best, and make the biggest impact.
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.
Applicants with a visual impairment can request job descriptions and application forms in Braille, large print or on tape.
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.
Requirements
Do you have experience in SQL?, This is a highly important role within our Governance, Performance & Engagement portfolio, which means you'll 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).
Benefits & conditions
We're cultivating a workplace that supports not only your passion and your professional lives, but your personal life. So, you'll 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.
