Responsibilities
* Collaborate with business stakeholders to gather data requirements and understand reporting dependencies.
* Analyse, document, and enhance data sources, data structures, and data quality frameworks.
* Develop, optimise, and maintain complex SQL queries, views, and stored procedures to support BAU and project‑specific data needs.
* Design and maintain robust data models and datasets to enable accurate downstream reporting in Power BI and other analytics tools.
* Ensure data integrity, accuracy, and consistency across all SQL outputs and related data assets.
* Conduct comprehensive testing and validation of SQL logic, data pipelines, and performance improvements.
* Troubleshoot and resolve data discrepancies, performance issues, and source‑to‑target inconsistencies.
* Collaborate with reporting specialists to ensure SQL datasets meet usability, performance, and compliance requirements.
* Lead improvements to database structures and query optimisation to enhance system stability and reporting efficiency.
* Support automation and workflow enhancements through SQL‑driven solutions and integrations.
Qualifications
* Significant experience developing advanced SQL queries, stored procedures, and data models.
* Strong understanding of SQL database design principles, performance tuning, and data warehousing concepts.
* Experience in data analysis and data modelling.
* Working knowledge of Power BI (including data modelling and RLS) is desirable but not essential.
* Excellent analytical thinking, problem‑solving abilities, and attention to detail.
* Strong communication and stakeholder management skills.
* Ability to work independently and collaboratively in a fast‑paced environment.
* Experience with Power Automate or other workflow/automation tools is a plus.
Additional Skills and Experiences
* Bachelor’s degree in Computer Science, Information Systems, or a related field.
Benefits
* Competitive salary of up to £44,000 per annum depending on experience.
* Annual leave – 26 days holiday per year, increasing to 30 with length of service (+ bank holidays).
* Performance‑related pay plan directly linked to company performance measures and targets.
* Generous pension scheme through AON.
* Access to a range of benefits for health, wellbeing, and finances – from annual health MOTs and physiotherapy and counselling, to Cycle‑to‑Work schemes, shopping vouchers and life assurance.
Find out more about our benefits and perks.
Base location – Hybrid – Clear Water Court Reading
36 hours a week.
Who are we?
We’re the UK’s largest water and wastewater company, with more than 16 million customers relying on us every day to supply water for their taps and toilets. We want to build a better future for all, helping our customers, communities, people, and the planet to thrive.
Working at Thames Water
Thames Water is a unique, rewarding, and diverse place to work, where every day you can make a difference, yet no day is the same. As part of our family, you’ll enjoy meaningful career opportunities, flexible working arrangements and excellent benefits.
Real purpose, real support, real opportunities. Come and join the Thames Water family. Why choose us? Learn more.
We’re committed to being a great, diverse, and inclusive place to work. We welcome applications from everyone and want to ensure you feel supported throughout the recruitment process. If you need any adjustments, whether that’s extra time, accessible formats, or anything else just let us know, we’re here to help and support.
When a crisis happens, we all rally around to support our customers. As part of Team Thames, you’ll have the opportunity to sign up to support our customers on the frontline as an ambassador. Full training will be given for what is undoubtedly an incredibly rewarding experience. It’s also a great opportunity to learn more about our business and meet colleagues.
Disclaimer: due to the high volume of applications we receive, we may close the advert earlier than the advertised date, so we encourage you to apply as soon as possible to avoid disappointment.
#J-18808-Ljbffr