Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join a dynamic team as a Revenue Reporting Analyst, solving problems and analysing data.
- Company: Scottish Water is a top-performing organisation dedicated to serving Scotland.
- Benefits: Enjoy flexible working, 38 days holiday, and paid time off for volunteering.
- Why this job: Be part of a motivated team making a real impact on revenue and customer service.
- Qualifications: Part-qualified in finance or 2+ years experience in financial analysis required.
- Other info: Starting salary of £33,560 with performance-driven pay progression.
The predicted salary is between 27500 - 38500 £ per year.
Together we are Trusted to Serve Scotland. Love solving problems and driving real change? Are you an enthusiastic self-starter who wants to work for a fantastic team in a top performing organisation? If so, you are exactly what we are looking for and here at Scottish Water we have just the role for you.
About The Role
Working as a Revenue Reporting Analyst, you will be joining a small, dynamic team who are the ‘go to’ experts for Revenue and Charging data. You will join a motivated team who are committed to continuously improving the service we provide to our internal and external customers. You will have a highly diverse and challenging role, which plays an instrumental part in producing the analysis required to help protect the integrity of Wholesale and Household charges. Specifically, you will support the monthly Financial Reporting process, carry out data analysis to understand variances, and identify anomalies and trends so that we can forecast our cashflow and revenue. You will also deliver analysis on wholesale data as required by the business and work with other business teams to maintain data quality.
What Are We Looking For?
We’re looking for a Reporting Analyst who is curious with analytical, organisational and communication skills who can apply their skills to a wide range of challenges, such as:
- Conducting in-depth analysis and interpretation of wholesale data to reconcile the database of Supply Points and charge data;
- Reviewing financial models to understand the impact to revenue of various revenue generating initiatives;
- Preparing monthly variance analysis reports comparing actuals to budget and forecast, identifying key drivers of variances and providing commentary;
- Supporting the preparation of monthly revenue and cash flow forecasts, monitoring forecast accuracy and suggesting improvements to forecasting processes;
- Maintaining robust processes to ensure that all potential issues identified are analysed, logged, and tracked through to resolution, including liaison with other internal departments or market participants.
We are looking for an approachable, articulate and confident individual who is detail-focused with a continuous improvement mindset and has had experience in a finance role handling large amounts of data. To be successful in this role, you’ll need to be part-qualified (ICAS, ACCA, or CIMA) or have 2+ years’ experience in financial analysis/reporting. You should have experience using MS Excel as a data investigation tool and MS PowerBI for report development, including PowerQuery (M language) and DAX. You must be able to deal with complex or abstract issues, breaking them down and communicating them in ways different audiences can understand. A willingness to learn, be inquisitive, and take responsibility to meet targets and goals is essential. Being proactive, with a desire to get involved and take ownership of processes or projects outside of your comfort zone, will also serve you well.
This is a full-time position with a flexible base location, though some travel to our main offices will be beneficial to collaborate with other members of the team, particularly when learning the job. If this has got you interested or sounds like the type of opportunity you could excel in, we would love to hear from you!
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. The normal working hours for this role are Monday to Friday from 9-5. But 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 6. If you’re new to Scottish Water, you’ll join us on a starting salary of £33,560. Performance-driven pay progression would then allow you to move through the range to a maximum of £44,140.
If you’re interested in this role – or know someone else who might be - we’ll be accepting applications until the amended closing date of midnight on Friday 27th June.
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. These checks are conducted on our behalf by a third party. Don’t worry - we’ll ask your permission before starting these checks.
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 SWRecruitment@ScottishWater.co.uk
Revenue Reporting Analyst employer: Scottish Water
Contact Detail:
Scottish Water Recruiting Team
SWRecruitment@ScottishWater.co.uk
StudySmarter Expert Advice 🤫
We think this is how you could land Revenue Reporting Analyst
✨Tip Number 1
Familiarise yourself with the key tools mentioned in the job description, such as MS Excel and PowerBI. Consider taking a short online course or tutorial to brush up on your skills, especially in PowerQuery and DAX, as this will demonstrate your commitment and readiness for the role.
✨Tip Number 2
Network with current or former employees of Scottish Water, particularly those in finance or reporting roles. Engaging in conversations can provide you with valuable insights into the company culture and expectations, which can help you tailor your approach during interviews.
✨Tip Number 3
Prepare to discuss specific examples of how you've handled large datasets and performed financial analysis in previous roles. Being able to articulate your problem-solving process and the impact of your work will set you apart from other candidates.
✨Tip Number 4
Showcase your curiosity and willingness to learn by preparing thoughtful questions about the team’s current projects and challenges. This not only demonstrates your interest in the role but also highlights your proactive attitude, which is highly valued at Scottish Water.
We think you need these skills to ace Revenue Reporting Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience and skills that align with the role of a Revenue Reporting Analyst. Emphasise your analytical abilities, experience with financial data, and any qualifications like ICAS, ACCA, or CIMA.
Craft a Compelling Cover Letter: Write a cover letter that showcases your enthusiasm for the role and the company. Mention specific examples of how your previous experience has prepared you for the challenges outlined in the job description, such as conducting data analysis or preparing financial reports.
Highlight Technical Skills: Since the role requires proficiency in MS Excel and PowerBI, ensure you mention your experience with these tools. Provide examples of how you've used them in past roles to analyse data or create reports.
Showcase Problem-Solving Abilities: In your application, include instances where you've successfully solved complex problems or improved processes. This will demonstrate your proactive approach and ability to handle the diverse challenges mentioned in the job description.
How to prepare for a job interview at Scottish Water
✨Show Your Analytical Skills
As a Revenue Reporting Analyst, you'll need to demonstrate your analytical prowess. Be prepared to discuss specific examples of how you've conducted data analysis in the past, particularly in financial contexts. Highlight any tools you've used, like MS Excel or PowerBI, to showcase your technical skills.
✨Understand the Role's Impact
Make sure you understand how the role contributes to the overall success of the organisation. Be ready to explain how your work as an analyst can help improve revenue forecasting and data quality. This shows that you're not just interested in the job, but also in its significance within the company.
✨Prepare for Scenario Questions
Expect scenario-based questions that assess your problem-solving abilities. Think about potential challenges you might face in the role, such as identifying anomalies in data, and prepare to discuss how you would approach these situations. This will demonstrate your proactive mindset and readiness to tackle complex issues.
✨Communicate Clearly
Since the role requires explaining complex data to various audiences, practice articulating your thoughts clearly and concisely. During the interview, focus on breaking down complex concepts into simpler terms, showcasing your ability to communicate effectively with both technical and non-technical stakeholders.
