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)
Attached documents
The following content displays a map of the job's location.
