SQL Developer

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: £40,000 - £55,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.

Desirable:

• Exposure to Azure Data Factory, Databricks, or broader Azure data ecosystem.
• Experience with CI/CD, Git, DevOps workflows, or automation tooling.
• Prior experience supporting reporting tools (Power BI/SSRS) or data warehouse environments.
• Understanding of data governance and security best practices.

Why choose Castle Water?

Castle Water is one of the fastest growing and most successful companies in the utilities sector. Our customers include some of the largest companies and public sector bodies in the UK.

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. Not only have we just achieved our 20,000th 5* Trust Pilot review, but we are also winners of the recent Customer Service Excellence Award for the Perthshire Chamber of Commerce Business Star Awards.

Castle Water has a track record of providing excellent customer service, and of developing innovative approaches to utility supply. We have more 5* reviews on Trustpilot than all other water retailers combined. 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. We also have offices in Ayr, Ayrshire, and in Brentford, London.

Pay: £40,000.00-£55,000.00 per year

Benefits:

• Cycle to work scheme
• Life insurance
• On-site parking
• Sick pay

Work Location: Hybrid remote in Blairgowrie PH10 7BH