At a Glance
- Tasks: Transform complex data into insightful dashboards using Power BI, SQL, and Excel.
- Company: Join Xentrall HR Services, supporting councils and schools with payroll and recruitment.
- Benefits: Enjoy a competitive salary, flexible working, and generous annual leave plus employee perks.
- Why this job: Be part of a supportive team that values your contributions and fosters continuous improvement.
- Qualifications: Strong experience with Power BI, Power Automate, and excellent problem-solving skills required.
- Other info: Work from home options available; great for those passionate about data and insights.
The predicted salary is between 30000 - 50000 £ per year.
Do you love turning complex data into clear, useful dashboards—and have experience using Power BI, SQL, Excel, and APIs to make it happen?
Are you someone who enjoys improving how data flows, making sure it\’s accurate, consistent, and easy to work with—especially using tools like Power Automate and Power Query?
Can you work well with different teams and customers, helping them understand their data and make smarter decisions with it?
Look no further! We have a fantastic opportunity for an experienced data analyst to join our team here at Xentrall HR Services, Stockton-on-Tees Borough Council.
Xentrall HR Services delivers comprehensivePayroll and Recruitment supportto bothStockton and Darlington Borough Councils, as well as to a wide network ofschools and academies.
What You’ll Do:
- Lead the design, development, and maintenanceof a robust Power BI reporting infrastructure—with a passion for pushing the platform’s capabilities further.
- Integrate datafrom multiple sources includingSQL databases, Excel, and external APIsto create unified, insightful dashboards.
- Maintain and enhance the data warehouse, ensuring optimal performance, security, and data integrity.
- Develop and optimise data models and DAX queriesto ensure high performance and user-friendly reporting.
- Automate workflowsusingPower Automate and Power Query, streamlining data processes and improving efficiency.
What You’ll Bring:
- Strong experience with Power BI, Power Automate, Power Query, and DAX.
- A solid understanding of data warehousing, integration, and governance.
- Excellent problem-solving skills and a collaborative mindset.
- A commitment to continuous improvement and user empowerment.
For more detailed information about the role, please refer to the Job Description and Person Specification included in the Supporting Documents section.
Xentrall HR Services, in partnership with Stockton-on-Tees Borough Council prides itself on being a great place to work where staff are trusted, valued and supported to make a positive contribution at work.
We offer an excellent total reward package, including:
- A competitive salary of up to £36,124 (pay award pending)
- 27 days annual leave per year rising to 32 with 5 years service (plus bank holidays). Ability to purchase additional leave is also available.
- Generous Pension Scheme through the LGPS with ability to pay extra and plan for retirement.
- Access to a number of other employee benefits including learning & development opportunities, a car lease scheme, discounts at high street and online retailers, an employee assistance programme and physiotherapy services.
And that’s not all – you can also work flexibly where you can work part of your week at home.
For more information about working for Stockton-on-Tees Borough Council, please visit the Careers section on our website:
https://www.stockton.gov.uk/careers
If you would like an informal discussion about the post, please contact Lee Shiells, Manager – Systems, Improvement & Recruitment on Lee.Shiells@Xentrall.Org.uk or 01642 528875
Guidance for applicants
You must ensure that anything submitted in your application is factually accurate. Plagiarism can include presenting the ideas and experience of others, or generated by artificial intelligence, as your own. Whilst we accept candidates may use AI tools within job applications; submissions must be truthful and relevant to your own experience.
Please note that all communication regarding your application for this post will be sent to the email address that you have registered with North East Jobs, including your invite to interview if you are short-listed. Please check your email after the closing date for notification from ‘DONOTREPLY@NORTHEASTJOBS.ORG.UK’. All communication will also appear in the ‘My Messages’ section of your North East Jobs account.
#J-18808-Ljbffr
Senior Officer – Improvement (Data & Insights) employer: Stockton-on-Tees Borough Council
Contact Detail:
Stockton-on-Tees Borough Council Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Officer – Improvement (Data & Insights)
✨Tip Number 1
Familiarise yourself with the specific tools mentioned in the job description, such as Power BI, SQL, and Power Automate. Consider creating a small project or dashboard that showcases your skills using these tools to demonstrate your expertise.
✨Tip Number 2
Network with current employees or professionals in similar roles to gain insights into the company culture and expectations. This can help you tailor your approach and show that you understand the environment at Xentrall HR Services.
✨Tip Number 3
Prepare to discuss real-world examples of how you've improved data processes in previous roles. Highlight specific challenges you faced and how you overcame them, especially using automation tools like Power Automate and Power Query.
✨Tip Number 4
Research the latest trends in data analytics and visualisation. Being knowledgeable about current best practices will not only impress during interviews but also show your commitment to continuous improvement, which is a key quality they are looking for.
We think you need these skills to ace Senior Officer – Improvement (Data & Insights)
Some tips for your application 🫡
Highlight Relevant Skills: Make sure to emphasise your experience with Power BI, SQL, Excel, and APIs in your application. Provide specific examples of how you've used these tools to create dashboards or improve data flow.
Showcase Problem-Solving Abilities: Include instances where you've tackled complex data challenges. Describe the problem, your approach, and the outcome to demonstrate your analytical skills and collaborative mindset.
Tailor Your Application: Customise your CV and cover letter to reflect the job description. Mention your commitment to continuous improvement and user empowerment, as these are key attributes for this role.
Proofread and Ensure Accuracy: Before submitting your application, double-check for any factual inaccuracies or typos. Remember, honesty is crucial, so ensure that all information reflects your true experience and skills.
How to prepare for a job interview at Stockton-on-Tees Borough Council
✨Showcase Your Technical Skills
Be prepared to discuss your experience with Power BI, SQL, Excel, and APIs in detail. Bring examples of dashboards you've created or data processes you've improved, as this will demonstrate your hands-on expertise.
✨Understand Data Flow and Governance
Familiarise yourself with the principles of data warehousing and governance. Be ready to explain how you ensure data accuracy and consistency, as this is crucial for the role.
✨Emphasise Collaboration
Highlight your ability to work with different teams and customers. Prepare examples of how you've helped others understand their data and make informed decisions, showcasing your collaborative mindset.
✨Demonstrate Continuous Improvement Mindset
Discuss your commitment to continuous improvement. Share instances where you've optimised workflows using tools like Power Automate and Power Query, illustrating your proactive approach to enhancing efficiency.