SQL Developer

Castle Water; Blairgowrie and Rattray; Híbrido; GBP 45.000 - 65.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Company pension

Life insurance

Sick pay

Hybrid working

Descripción de la vacante

Castle Water is seeking a SQL Developer to join our IT Data Services team. You will contribute to high-quality SQL Server development, database optimisation, automation, and data operations across the business, with opportunities to grow into Data Engineering practices and Azure data services.

You will work in a collaborative environment with a focus on continuous learning, technical excellence, and professional development, supporting enterprise data workflows and cross-team collaboration

Formación

• Must have strong T-SQL skills and a developer mindset.
• Degree or substantial relevant experience in Computer Science/IT/Engineering/Math.
• Experience in SQL Development, Data Analysis, BI or Data Engineering is advantageous.

Responsabilidades

• Develop complex, high-performance T-SQL queries, stored procedures, and database logic.
• Manage SQL Server objects including tables, indexes, constraints, views, and functions.
• Optimize database performance through indexing, query tuning, and maintenance.
• Support schema design, normalization, and relational modelling best practices.
• Assist application teams with SQL guidance and integration considerations.
• Ensure secure access to production and non-production environments and monitor data operations.

Conocimientos

T-SQL

SQL Server

Python basics

Data analysis

Relational databases

Azure data services

Educación

Degree in Computer Science / IT / Engineering / Mathematics

Herramientas

Azure

SQL Server Management Studio

ETL/ELT tooling

Descripción del empleo

Castle Water is seeking to appoint aSQL Developerto join our supportive IT Data Services team to contribute to our continued growth and success.

TheSQL Developerrole 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.

• 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

• 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.

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