Data Engineer
Ofwat (Water Services Regulation Authority)
Apply before 11:55 pm on Sunday 10th November 2024
Details
Reference number
Salary
Job grade
Contract type
Business area
Type of role
Information Technology
Working pattern
Number of jobs available
Contents
Location
About the job
Job summary
We are seeking two Data Engineers to join our expanding Data Strategy team, as part of our plans to upgrade and modernise our data platform through our dedicated programme – Programme Ocean.
Our Data Strategy team is integral to Ofwat's vision and strategy for the water sector. In addition to leading on the development of a new data platform, the team seek to shape how data is used across Ofwat, providing teams with practical solutions that result in efficiencies, enhanced visibility and access to data, as well as effective decision making and insights. This role will also require close collaboration with our IT team.
This is a great opportunity to work with leading cloud technology and help shape the way data is used in the public sector. You will work with cutting edge and evolving technology as we look to maximise the data and bring value added insights to Ofwat.
The successful candidate will work in a small team of Data Engineers, alongside IT operations roles, to bridge the gap between data producers and data users, developing analytical pipelines and self-service tools to acquire and transform data, making it available in our new data platform.
You can find out more about this role, why you should join Ofwat, our strategy, values and our framework for success in the attached Information for Candidates Pack.
Job description
In this role you will be expected to:
- Design and build robust and scalable automated data flows to connect to our new data platform and ensure timely and quality data for analytics and business intelligence (BI) systems.
- Recognise opportunities to reuse and re-engineer data flows to enable scaling and repeatable use
- Design and implement ETL (extract, transform, load) pipelines and code to ensure optimum operation
- Work with data users to understand and translate their needs into technical requirements
- Utilise a range of Azure services to deploy your solutions in a reproducible, sustainable manner
- Develop and optimise code, tools and services that enable people to use data effectively
- Provide support to colleagues, proactively sharing skills and knowledge.
- Develop your skills through continued learning and development.
- Design and maintain technical documentation.
Person specification
To be successful in this role you will need the below essential experience, skills, knowledge and attributes:
Experience, skills and knowledge
- Lead criterion 1: Software Development Skills: Strong Proficiency in Python for data manipulation, scripting, and automation tasks.
- Lead criterion 2: Experience in data warehouse methods and techniques, including ETL processes, data modelling and design.
- Software development experience with data-processing platforms including experience with Microsoft Fabric/Azure Synapse Analytics/Databricks.
- Relational Databases/SQL: Deep understanding and hands-on experience with relational databases, including proficiency in SQL for data querying and management.
- Data Modelling: Experience in designing both analytical and operational data models to support business intelligence and reporting needs.
- Azure Data Factory or Synapse Analytics Pipelines: Experience of performance tuning data transformation process.
- Azure SQL Database: Experience with Azure SQL Database for managing and querying relational data in the cloud.
- Data Integration: Experience in integrating and working with a wide range of data sources, ensuring data consistency and reliability.
- CI/CD tooling: Practical knowledge of using and configuring deployment tools, such as Azure DevOps.
Attributes
- Promotes Collaboration
- Creates Clarity
- Champion and Leader of Change
Attributes as per Ofwat's Framework for Success for Senior Associate Band. You can read more about Attributes here.
Benefits
Why You Should Join Us:
We’re forward-thinking, creative, innovative, and ambitious. We constantly push the boundaries and embrace new ways of working.
With us, your work matters, your voice is heard, and your impact is felt. Ours is a culture of trust, flexibility, autonomy, collaboration, and innovation. We all want positive change for water customers, the environment, and the future of water.
But for us, change is more than what happens on the outside – we’ve always pushed boundaries internally, too. From becoming the first Civil Service organisation to achieve ‘Smarter Working’ status, to gaining our prestigious ‘Smarter Working Maturity’ award, we’ve consistently demonstrated our commitment to embracing innovative ways of working. Our people do their best work when given freedom over where, when, and how they work. Which is why we trust our teams to balance meaningful collaboration in the office with the flexibility of working from home.
You will also benefit from:
- Excellent employer pension contributions of 28.97% (around £10,700 to £15,800 per annum for this role).
- 27.5 days leave (25 days annual leave + 2.5 days privilege leave) increasing to max 32.5 days with each year of service, plus bank holidays
- Access to exclusive discounts on a variety of goods and services, including retail
outlets, theatre tickets, holidays, insurance, and a gym membership. - Flexible working arrangements that suit your lifestyle.
- Fees paid for membership of relevant professional bodies.
- Up to 3 volunteering days per year.
- Generous shared parental leave and pay.
- Enhanced sick pay.
- Regular development opportunities.
- Health and wellbeing initiatives.
- Season ticket loan for home-to-office travel.
- Cycle-to-work scheme.
Things you need to know
Selection process details
How to apply
Apply through the Civil Service Jobs website where you’ll be asked to create an account and complete an application form (CV and personal statement). If you’re unable to make an electronic application, please contact recruitment@ofwat.gov.uk and we will support you in completing your application.
Please ensure you have submitted your application in full ahead of the deadline listed below. Unfortunately, we won't be able to consider late applications.
Please see the candidate guidance on our website for more detail and tips on how to best make your application.
Selection timetable
- Closing date: 23:55 on 10 November 2024
- Sifting: week commencing 11 November 2024
- Interview date(s): WC 25 November 2024
Assessment process
Sift Stage
We operate a blind sifting model to eliminate bias. All candidate identifying information will be removed from applications.
At sift stage we will assess your application (CV and Personal Statement) against criterion 1, 2, 3, 4, 5 listed in the personal specification above (Experience, Skills & Knowledge).
In the event of receiving a large number of applications, a pre-sift may take place on the two lead criteria:
- Software Development Skills: Strong Proficiency in Python for data manipulation, scripting, and automation tasks.
- Experience in data warehouse methods and techniques, including ETL processes, data modelling and design.
In your personal statement, please tell us how your skills and experience meet the lead criteria, with examples if appropriate.
Please note that if a high volume of candidates meet the minimum pass mark at sift stage, we will only progress the highest scoring candidates to interview. Candidates not invited to interview, who have achieved the minimum pass mark, will be placed 'on hold' until the final stage of the assessment process is completed. Should the role/s remain unfilled, candidates placed 'on hold' may be invited to interview in merit order.
Interview Stage
Our transparent interview process involves candidates receiving a list of attribute-based questions in advance. This has been proven to help neurodiverse candidates and others to perform better at interview and is part of our inclusive culture.
We will assess your Experience, Skills and Knowledge as well as Attributes (set out in the person specification) at Interview Stage.
You can read more about Attributes in Ofwat’s Framework for Success.
As part of the interview process, we will require short presentation. Further details will be provided to shortlisted candidates upon invitation to interview.
Please note that the interviews will be conducted via video conferencing software such as Microsoft Teams.
If the assessment process identifies more appointable candidates than roles available, a reserve list will be created for 12 months from which further appointments in merit order can be made.
If you have any queries about any aspect of this role, selection process, or you require any reasonable adjustments please email recruitment@ofwat.gov.uk.
Please read the attached "Candidate Information Pack" for details on terms and conditions.
Feedback will only be provided if you attend an interview or assessment.
Security
Nationality requirements
Working for the Civil Service
We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's recruitment principles (opens in a new window).
Diversity and Inclusion
Apply and further information
Contact point for applicants
Job contact :
- Name : recruitment@ofwat.gov.uk
- Email : recruitment@ofwat.gov.uk
Recruitment team
- Email : recruitment@ofwat.gov.uk
Further information
