Together we are Trusted to Serve Scotland. It’s not every job where you make a difference for the people of Scotland. But it’s what’s behind every job here. Our work keeps Scotland’s water flowing, from reservoir to tap – and from sewer to treatment plant. Want to join us? We’re on the hunt for a Senior Data and Reporting Analyst to join our team. If you're someone who can handle complexity, think on your feet, and plan for the future with a strategic mindset, you might be the perfect fit. We’re looking for someone with, excellent organisational abilities, and experience in running projects. You'll be joining a small, dynamic team of analysts who are the go-to experts for data and reporting. What you’ll do In this role, you’ll be developing reporting capabilities across the department using Power BI, and you’ll play a key role in creating and managing plans that drive continuous improvement. You'll engage with issues identified through our annual audit and monthly data quality reports, and you’ll be instrumental in developing concepts that boost efficiency and performance—think self-serve reporting and analytics. You’ll also lead initiatives to improve our Key Performance Indicators, making sure we deliver the best value to our customers, and spearhead projects that enhance data quality and maximise revenue. As a senior member of our team, you’ll be working closely with the Team Leader to plan, prioritise, and delegate tasks. You’ll also contribute to the training and development of the team and take on any ad-hoc tasks as needed. What you’ll bring To be successful in this role, you'll need a degree in a numerical subject or proven experience in data analysis. While we don’t expect you to know everything from day one, we do want someone who can hit the ground running and is comfortable working with data. Experience in MS Power BI report development, DAX, SQL, and using MS Excel as a data investigation tool is crucial. You should also be skilled in extracting and analysing data to provide meaningful insights, with the ability to communicate complex processes and concepts to different audiences. If you’re proactive, eager to learn, and ready to take on responsibilities that may push you out of your comfort zone, we think you’ll thrive here. Some leadership/mentoring experience and a strong desire to get involved in processes and projects will definitely set you apart. While it’s not essential, experience in leading projects, stakeholder management, SQL scripts, and tools like MS Dynamics, PowerQuery, R, or Python would be a big plus. Looking out for you While the work we do is important, we know it’s not the only thing that matters. That’s why we make sure you have everything you need to find a good work-life balance. You’ll get plenty of time to recharge with 38 days of holiday every year (including public holidays). And you can even buy five more if you need a little extra time. You can also take paid time off to volunteer in your community. When it comes to major life events we have family-friendly policies around adoption, maternity, and parental leave. And for the everyday? We embrace flexible working. For your future, there’s our pension (the ‘know-what-you’ll-get-when-you-retire’ kind), as well as life assurance. As for some nice extras? You can expect an annual company bonus. Not to mention access to SW Splash – handy rewards that can save you money on holidays, bills, and shopping. The not-so-small print This role will be a Grade 7. If you’re new to Scottish Water, you’ll join us on a starting salary of £41,000. Performance-driven pay progression would then allow you to move through the range to a maximum of £51,970. If you’re interested in this role – or know someone else who might be - we’ll be accepting applications until midnight on Wednesday 25th of November 2024 Job offers at Scottish Water are conditional, and will be confirmed on completion of our pre-employment screening, e.g. referencing, criminal record checks, license checks, etc. Screening is conducted on our behalf by a third party, and must be completed before your start date. Don’t worry - we’ll only start these checks once you’ve accepted an offer. A few final things worth knowing… Research shows that some people avoid applying for jobs unless they can meet every single criteria. If you’re interested in this job, but don’t tick all the boxes, apply anyway We hardly ever hire people who can do every part of a job from Day One. Everyone has a learning curve. So don’t rule yourself out Let us know if there are any changes we can make to our recruitment process to help you perform at your best. Lots of our people have disabilities or neurodiverse conditions (including some of our recruiters). We're also aware that some people might be experiencing temporary challenges because of life events, like menopause. We’re very used to making adjustments, so please don’t be afraid to ask. As part of our commitment to developing a flourishing Scotland, it’s important that all our employees are Scottish taxpayers. If you join us, your home address will need to be in Scotland. If you don’t already live here, you'll need to commit to moving here within your first three months. Finally (finally), candidates who haven’t submitted an application in the last 12 months will have their records removed from our recruitment database. You won’t need to do anything. Your data will be automatically deleted. We’re here to help. Ask us anything at SWRecruitmentScottishWater.co.uk