At a Glance
- Tasks: Join us to modernise data management and visualisation at North Northamptonshire Council.
- Company: Be part of a forward-thinking council dedicated to transforming local services for the community.
- Benefits: Enjoy flexible working, generous leave, and a supportive environment with great perks.
- Why this job: Make a real impact by shaping data strategies and enhancing analytics for local government.
- Qualifications: 2+ years in data engineering, especially with Azure tools and ETL processes.
- Other info: We're committed to inclusivity and sustainability, aiming for carbon neutrality by 2030.
The predicted salary is between 36000 - 60000 Β£ per year.
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?
- 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
- Understanding of local government services
Your knowledge and 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
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.
Why choose us?
We offer a vibrant working environment with:
- 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.
- 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 are 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.
Data Engineer (MS Fabric) employer: Northamptonshire Sport
Contact Detail:
Northamptonshire Sport Recruiting Team
StudySmarter Expert Advice π€«
We think this is how you could land Data Engineer (MS Fabric)
β¨Tip Number 1
Familiarise yourself with the Microsoft Azure ecosystem, especially tools like Azure Data Factory and Databricks. Being able to discuss your hands-on experience with these tools during an interview will show that you're ready to hit the ground running.
β¨Tip Number 2
Brush up on your knowledge of data warehousing concepts and ETL processes. Be prepared to explain how you've implemented these in past roles, as this will demonstrate your practical understanding of the responsibilities outlined in the job description.
β¨Tip Number 3
Network with current or former employees of North Northamptonshire Council on platforms like LinkedIn. This can provide you with insider insights about the company culture and expectations, which can be invaluable during your interview.
β¨Tip Number 4
Prepare to discuss your approach to data security and access management. Given the emphasis on building a security model in the role, showcasing your understanding of best practices in data governance will set you apart from other candidates.
We think you need these skills to ace Data Engineer (MS Fabric)
Some tips for your application π«‘
Tailor Your CV: Make sure your CV highlights relevant experience in data engineering, particularly with Azure tools and ETL processes. Use keywords from the job description to demonstrate your fit for the role.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the organisation. Mention specific projects or experiences that align with the responsibilities outlined in the job description, such as data migration or building data pipelines.
Showcase Relevant Skills: Clearly list your technical skills related to the job, such as proficiency in Microsoft SQL, Azure Data Factory, and Power BI. Provide examples of how you've used these skills in previous roles to solve problems or improve processes.
Highlight Soft Skills: Don't forget to mention soft skills that are important for the role, such as teamwork, communication, and problem-solving. These are crucial for supporting teams and adopting new technologies, as mentioned in the job description.
How to prepare for a job interview at Northamptonshire Sport
β¨Showcase Your Technical Skills
Make sure to highlight your experience with Azure data engineering tools, especially Azure Data Factory and Databricks. Be prepared to discuss specific projects where you built ETL processes or managed data migrations, as this will demonstrate your hands-on expertise.
β¨Understand the Role's Requirements
Familiarise yourself with the key responsibilities outlined in the job description. Be ready to explain how your previous experiences align with their needs, particularly in designing data warehouses and managing data pipelines for analytics.
β¨Prepare for Scenario-Based Questions
Expect questions that assess your problem-solving skills in real-world scenarios. Think of examples where you had to troubleshoot data issues or optimise data access methods, and be ready to explain your thought process and the outcomes.
β¨Demonstrate Your Knowledge of Local Government Services
Since the role is within a council, having an understanding of local government services can set you apart. Research how data management impacts public services and be prepared to discuss how your work can contribute to better service delivery.