SQL Developer

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., * 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.

Do you have experience in SQL?, 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., * 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.

Pulled from the full job description

• Sick pay
• Life insurance
• Company pension
• Cycle to work scheme
• On-site parking, * Cycle to work scheme
• Life insurance
• On-site parking
• Sick pay

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