Data Engineer

South Norfolk and Broadland Councils are looking for a Data Engineer to join our Strategy and Innovation Team.In this role, you''ll be key to us being able to use our data to understand and improve our performance and integrate services. You''ll 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''ll 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''ll be doingLead 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, Axure 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 ..... full job details .....