Finance Data Analyst

We’re looking for an enthusiastic and confident Finance Data Analyst to join our finance team. In this role, you’ll actively support the business by providing an effective and professional knowledge covering management accounting, mathematical and statistical modelling, coding and large set data reporting and analysis.

This is a role for someone with confidence and initiative, as well as the maturity required to take responsibility, and a willingness to learn and progress.

The Finance team is a hardworking and lively environment which will equip you with skills to progress your career. You can expect to be part of a collegial and supportive team, with a strong emphasis on knowledge sharing, continuous learning, mutual respect and personal development.

Perks you'll enjoy

Salary ranging between £30,000 – £35,000
Company pension, life insurance and sick pay
Cycle-to-work scheme
Monday to Friday schedule, so your weekends are all yours

What you'll be doing

Transform and model raw financial and operational data into structured, insightful outputs for analysis and reporting.
Cleanse and validate datasets to ensure accuracy, consistency, and reliability.
Identify trends, patterns, and anomalies within financial data to provide actionable insights.
Deliver clear, insightful analysis and reporting through dashboards, presentations, and written reports tailored to business needs.
Collaborate across departments to understand reporting requirements and ensure the delivery of timely, relevant data.
Produce and maintain regular (daily, weekly, monthly) KPI reports to inform both financial and non-financial decision-making.
Support internal and external audit processes through data extraction, reconciliation, and documentation.
Assist in the continuous improvement of data processes, including identifying inefficiencies and recommending solutions.
Manage multiple tasks simultaneously, ensuring deadlines are met and stakeholders are kept informed.
Work cross-functionally to respond to data-related queries, providing support and training where necessary.

What you'll bring to the role

Educated to Degree/Masters/MBA level or equivalent (relevant subjects would include Finance, Maths, Statistics, Machine Learning, Econometrics)
Previous experience working in a finance or data environment is an advantage
Must be commercially aware with a track record of consistently achieving and exceeding targets
Strong problem-solving skills with the ability and resilience to deal with challenge and ambiguity
Excellent interpersonal and communication skills
Competent in all Microsoft office packages including Excel, office 365
Experience with the following systems would be advantageous: Workday, Autorek, Alteryx, Power BI and Caseware IDEA
Must be a strong team player, with the ability to work collaboratively across functions and departments
Must have strong communication skills with the ability to convey complex concepts or data in a meaningful way, as well as the ability to communicate effectively both internally and externally to all levels.
Ability to work under pressure and to meet tight deadlines
Highly numerate with strong analytical skills

Why choose Castle Water

Castle Water aims to deliver the best customer service in the sector. Creating positive interactions in the workplace and between our employees and our customers will help ensure our company continues to draw new and retain existing customers.

Castle Water has a track record of providing excellent customer service, and of developing innovative approaches to utility supply. We have more 5-star reviews on Trustpilot than all other water retailers. We pride ourselves on being transparent and treating customers fairly.

Our head office is based in Blairgowrie, Perthshire, within easy commuting distance of both Perth and Dundee. We are embedded in the local community and participate in many local events and activities.

It’s been an incredibly rewarding experience

Hannah Bodie

Onboarding Manager