Data Engineer (MS Fabric)

About the role

North Northamptonshire Council are working to modernise their data management and visualisation processes. We are working to deliver our data analytics strategy. This role will support the design and delivery of the data warehousing, data infrastructure and (where required) the migration of existing data sources (data pipeline and Extract Transform Load (ETL) processes), the primary objective is to create a secure and efficient route for dispersed data sets to be accessed, analysed and visualised through tools such as Power BI and Excel power query. The current technology stack is predominantly based on Microsoft SQL databases, and we are focussing our data strategy on the Microsoft Azure, Fabric and Power BI toolsets.

What will you be doing?

The Key Responsibilities of the role will be:
Understand and document the data landscape across NNC - both today and going forwards
Scope technical designs and support decision making around required toolsets and processes
Define and build required data warehouse solution/s to meet the requirements of the data analytics strategy
Lead any required data migrations from on-premises or 3rd party hosted databases/repositories
Build and support data-pipelines using ETL tools such as MS Azure Data Factory and Databricks
Design and manage a standard access method to both cloud and on-premise data sources for use in data visualisation and reporting (predominantly using Microsoft Power Bi)
Own and build the security model to ensure access is granted based on least privilege
Support NNC teams to adopt new processes and technology to meet their data analytics requirements
Support Applications databases within the estate to run effectively and provide improvements
About you

Your experience:
At least 2 years working in a relevant data focused role
A deep understanding of data engineering principles - ideally in an Azure environment
Proven experience as a Data Engineer/Specialist in data lake/warehouse and data migration projects
Experience building and maintaining ETL processes
Experience producing data models and understanding where to use different types of data model
Working knowledge of Microsoft SQL - including SSIS and SSRS
Supporting application databases
Understanding of local government services
Your knowledge and certifications:
Any MS Azure data certifications
2 years + working with Azure data engineering tools e.g:

Azure Data factory
Azure Synapse
Azure SQL
Azure DataBricks
Microsoft Fabric
Azure data lake

Exposure to other data engineering and storage tools:

Snowflake
AWS tools - Kinesis/Glue/Redshift
Google tools - BigQuery/Looker

Experience working with open datasets - ingesting data / building API based queries
Our benefits

Here at North Northamptonshire Council, we're transforming for the better, using all our creativity and imagination to create the best life for our local people.

You'll find that we have a wide range of careers that may be more surprising than you think!

Why choose us?

We offer a vibrant working environment with:
a competitive salary
a pension scheme, where we pay a significant contribution on top of your contribution. It provides life cover and ill-health protection.
lots of opportunities to develop your skills, knowledge and potential in a large unitary council
generous leave entitlement (28 days, rising to 33 days) and bank holidays, plus the option to buy up to an extra 10 days
hybrid and flexible working arrangements, where practicable for service needs to help you with a healthy work-life balance.
We provide a range of great benefits such as an Employee Assistance Programme, an Employee Benefits Scheme, wellbeing support, travel rates at HMRC rates, as well as supporting a range of active Employee Network Groups.

About us

Our Values and Behaviours

Our values define who we are and how we operate, by forming the foundation for how we interact with our customers, colleagues and provide our services. They are also at the forefront of our decision making and delivery and are:

Customer-focused
Respectful
Efficient
Supportive
Trustworthy

Our Key Commitments

Our key commitments help ensure that the priorities we make, now and in the future, maintain the necessary breadth of focus in those areas that we believe matter most.

We are proud to be a recognised Disability Confident Employer and is committed to providing an inclusive recruitment process and will offer an interview to disabled applicants who meet the essential criteria for the role.

North Northamptonshire Council re-signed the Armed Forces Covenant in June 2024 which highlights the Council's pledge to support the Armed Forces community. The council obtained the silver status award for the Defence Employer Recognition Scheme (ERS) and we are now currently working towards achieving Gold status.

We aim to be a carbon neutral Council by 2030.

Further information can be found at Jobs and careers | North Northamptonshire Council (northnorthants.gov.uk)
#J-18808-Ljbffr