APPLY NOW
APPLY NOW

SQL Developer

APPLY NOW

Castle Water is seeking to appoint a SQL Developer to join our supportive IT Data Services team to contribute to our continued growth and success.

The SQL Developer role is central to supporting and enhancing the organisation’s data platforms. You will work within the IT Data Services team, contributing to high‑quality SQL Server development, database optimisation, automation, and data operations across the business. While your core responsibilities are SQL‑focused, this role also offers the opportunity to develop Data Engineering skills over time.

This position is ideal for someone with strong T‑SQL skills, a developer mindset, and a desire to grow. You will be part of a collaborative, hardworking, and supportive team that values continuous learning, technical excellence, and professional development.

We can promise a busy, engaging environment where you will build skills and be exposed to enterprise data engineering practices, Azure data services, and complex data workflows across the organisation. In return for your commitment, we offer clear opportunities for progression and personal growth.

Perks you'll enjoy

  • Salary: £45,000 – £60,000 per annum
  • Working with an experienced team
  • Monday – Friday schedule with hybrid working
  • Company pension, life insurance and sick pay

What you'll be doing

  • Develop complex, high‑performance T‑SQL queries, stored procedures (including dynamic SQL) and database logic.
  • Manage SQL Server objects including tables, indexes, constraints, views, and functions.
  • Optimise database performance through indexing strategies, query tuning, execution plan analysis, and routine maintenance.
  • Support schema design, normalisation, data integrity enforcement, and best practices for relational modelling.
  • Assist application development teams with SQL guidance, table design, and integration considerations.
  • Ensure secure, compliant, and well‑governed access to production and non‑production environments.
  • Support daily operational data activities including monitoring, troubleshooting, and resolving performance or data‑related issues.
  • Assist with generation of data extracts, reporting datasets, file processing workflows, and vendor integrations.
  • Contribute to automation of routine tasks and improvements to data quality, reliability, and consistency.
  • Work closely with the Data Engineer Lead on pipeline improvements, capacity planning, and continuous optimisation.
  • Participate in cross‑team collaboration with Developers, Sys Admins, and Governance teams to support shared objectives.

What you'll bring to the role

  • Strong SQL Server development experience (T‑SQL, stored procedures, indexing, schema design).
  • Good understanding of execution plans, performance tuning, and relational database concepts.
  • Solid analytical and problem‑solving abilities with a developer‑oriented mindset.
  • Interest in learning Data Engineering practices (ETL/ELT, automation, cloud data tools).
  • Basic knowledge of Python for data manipulation or scripting.
  • Familiarity with Azure fundamentals (SQL, storage, data services).
  • Ability to communicate clearly with both technical and non‑technical stakeholders.
  • Strong work ethic and eagerness to learn and improve.
  • Degree in Computer Science, IT, Engineering, Mathematics, or relevant experience.
  • Prior experience in SQL Development, Data Analysis, BI, or Data Engineering roles is beneficial.
APPLY NOW

Why choose Castle Water

Castle Water is redefining the utilities sector as one of the fastest-growing and most successful companies in the UK. Guided by our core values of fairness, transparency, tenacity and being supportive, we deliver outstanding service to a diverse range of customers, including some of the UK’s largest companies and public sector organisations.

We believe in putting people first. Whether it’s creating positive interactions with our customers or fostering a supportive workplace culture, our commitment to fairness and transparency ensures we build lasting relationships with our customers.

With over 20,000 5-star Trustpilot reviews, our reputation is built on trust and excellence. We tackle every challenge with tenacity and a dedication to doing what’s fair and right.

Our head office in Blairgowrie, Perthshire, is located within easy reach of Perth and Dundee. As a company embedded in the local community, we actively participate in events that reflect our supportive values. We also have offices in Brentford, London, and Ayr, offering plenty of opportunities to join our growing team.

If you’re looking for company that’s dynamic, forward-thinking and values-driven, Castle Water is the place for you.

It’s been an incredibly rewarding experience

Hannah Bodie

Onboarding Manager