Office location: either Birmingham (B54UA) or London (E14 4HD)
The Role
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.
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 following essential 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.
We are forward-thinking, creative, innovative and ambitious. We actively encourage autonomy, collaboration and innovation and we have a unique culture fostered by trust, flexibility and respect.
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. We know our people do their best work when given freedom over where, when, and how they work. Which is why we trust them to do exactly that.
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 range of goods and services such as retail outlets, theatre tickets, holidays, insurance and gym membership
* Flexible working arrangements
* Fees paid for membership of relevant professional bodies
* Up to 3 volunteering days per year
* Generous shared parental leave and pay
* Season ticket loan for travel between home and office
* Regular professional development including funded certifications
* Health and well-being initiatives
Please follow the link for further details and to make your application. If you have any questions then you may contact recruitment@ofwat.gov.uk .
Use our search to find your ideal career opportunity
NHS Cornwall and Isles of Scilly Integrated Care Board
#J-18808-Ljbffr