Data Engineer in Norwich

South Norfolk and Broadland Councils are looking for a Data Engineer to join our Strategy and Innovation Team. In this role, you will be key to us being able to use our data to understand and improve our performance and integrate services. You will figure out data structures and transform that data for other operational purposes and for analytical reporting, working with officers across the Council who use those systems day to day or who need to understand how the services run. You will work in a team advancing the Council's ability to make the best use of its available data, supporting analysis that strengthens our decision-making, as well as the foundations that underpin them such as cataloguing, data quality management and supporting broader data governance developments.

What you will be doing:

• Lead in the design, build and maintenance of scalable data architecture, including data lakes and data warehouses to ensure reliable data storage and accessibility.
• Integrate data from business systems and other sources to our data warehouse, using Microsoft Fabric, Azure SQL tools, respective Data Factory pipelines and on-premise gateways.
• Develop a robust data warehouse supporting an enterprise data model, including designing, implementing and maintaining medallion layer architecture and techniques such as managing slowly changing dimensions and leveraging change data capture.
• Extract or infer dataset schemas, communicating through structured language and data model diagrams, and convert datasets to alternative data standards, engaging relevant SMEs for input.
• Be able to translate business needs into the longer-term development of data engineering support, enabling these needs to be met.
• Provide advice and support to developing the One Team's data maturity, such as data governance developments and unstructured data management.

About You:

We are looking for a candidate with a relevant degree or professional/vocational qualification in computer science, data engineering, data science, or a related field, or equivalent practical experience. You will have proven experience working in a data engineering role using Microsoft Fabric tools, along with the ability to apply a strong understanding of database management, data governance, data security, data quality assurance, and version control in a real-world environment. The role requires hands-on experience of developing data warehouses, integrating new use cases, and working with Azure SQL or Microsoft Fabric tools, using Python and SQL. You will also bring experience in developing data models to support analytical applications and business requirements, including schema inference and the use of entity relationship and other data modelling diagramming tools. Strong skills in data integration, problem-solving, analytical thinking, and clear communication are essential to succeed in this role.

Why Join Us?

We offer flexible working hours for most office-based roles, allowing for a healthy work-life balance. As part of our team, you will enjoy a range of employee benefits, including free onsite parking, employee discounts, a competitive holiday allowance, wellbeing initiatives, and the opportunity to join the Local Government Pension Scheme. You will be joining a progressive and supportive organisation that is committed to making a positive impact on the communities we serve.

Equal Employment Opportunity:

South Norfolk and Broadland Councils are committed to promoting the welfare of children and vulnerable adults and all applicants must be willing to undergo appropriate checks for the position, including checks with past employers and the Disclosure and Barring Service.