DTS Database Developer

South Yorkshire Mayoral Combined Authority; Sheffield; Hybrid; GBP 39,000 - 42,000; Full time

Benefits offered by this job

Hybrid working

Local Government Pension Scheme

Flexible hours

Active travel facilities

Job summary

South Yorkshire Mayoral Combined Authority's data team seeks a DTS Database Developer to design, build and maintain enterprise database platforms that underpin transport systems and strategic decisions in the region.

Hybrid working in Sheffield, with emphasis on data security, performance, and collaboration to deliver scalable data pipelines and reliable reporting for evidence-based decisions across South Yorkshire.

Qualifications

• Strong experience in SQL database development, optimisation, and administration.
• Experience of managing databases in a clustered environment.
• Experience of supporting SQL in an Azure environment.
• Expertise in writing complex SQL statements and SSIS packages for data integration.
• Expertise in developing data pipelines, integrations, and managing complex datasets.
• A proactive approach to troubleshooting, performance tuning, and problem solving.
• Knowledge of data protection principles and secure data management practices.
• The ability to build positive relationships and support colleagues through training and guidance.

Responsibilities

• Design, develop, and optimise enterprise database solutions and integrations.
• Build robust ETL/ELT processes that deliver trusted and consistent data.
• Support data-driven decision-making through reporting and management information.
• Ensure database security, resilience, compliance, and performance. Contribute to SYMCA's ambitious Digital Strategy and transformation programme.

Skills

SQL database development

SQL performance tuning

Database administration

Clustered environment management

Data integration and ETL

Data protection principles

Training & mentoring

Problem solving

Tools

SSIS

Azure

SQL Server

Job description

DTS Database Developer

Application Deadline: 20 September 2026

Department: Digital & Technology Services

Employment Type: Fixed Term - Full Time

Location: Sheffield Head Office

Reporting To: Andy Reay

Compensation: £39,153 - £41,772 / year

Description

• Hours: 37 hours per week
• Contract: Fixed Term - 6 Months
• Salary: Grade 8 – £39,153 to £41,772
• Location: Sheffield (hybrid working)

Are you passionate about transforming data into insight, building robust database solutions, and driving digital innovation? Join SYMCA's Digital & Technology Services team and play a pivotal role in shaping the data infrastructure that supports transport services and strategic decision-making across South Yorkshire. Working within a forward-thinking organisation, you'll help deliver the digital capabilities that enable smarter services, stronger communities, and better outcomes for residents.

At SYMCA, you'll be part of an organisation that values Collaboration, Integrity, Ambition, and Accountability. You'll have the opportunity to work on meaningful projects that help shape the future of transport and public services across South Yorkshire while developing your skills in a supportive and innovative environment.

About the role

As a DTS Database Developer, you'll be responsible for developing, enhancing, and maintaining the database platforms that underpin critical business and transport systems across SYMCA. Working closely with colleagues, stakeholders, and external partners, you'll ensure data is accessible, reliable, secure, and ready to support evidence-based decisions. This is an exciting opportunity to help drive digital transformation by improving data quality, enabling self-service reporting, and delivering innovative solutions that support major organisational initiatives.

Key Highlights:

• Design, develop, and optimise enterprise database solutions and integrations.
• Build robust ETL/ELT processes that deliver trusted and consistent data.
• Support data-driven decision-making through reporting and management information.
• Ensure database security, resilience, compliance, and performance. Contribute to SYMCA's ambitious Digital Strategy and transformation programme.

About you

You're a skilled database professional who combines strong technical expertise with excellent problem-solving and communication skills. You enjoy working collaboratively, translating complex technical concepts into practical business solutions, and helping others make better use of data. With experience managing database environments and delivering reliable data solutions, you're motivated by continuous improvement and committed to maintaining the highest standards of data integrity, security, and compliance.

What You'll Bring:

• Strong experience in SQL database development, optimisation, and administration.
• Strong experience of managing databases in a clustered environment.
• Experience of supporting SQL in an Azure environment.
• Expertise in writing complex SQL statements and SSIS packages for data integration.
• Expertise in developing data pipelines, integrations, and managing complex datasets.
• A proactive approach to troubleshooting, performance tuning, and problem solving.
• Knowledge of data protection principles and secure data management practices.
• The ability to build positive relationships and support colleagues through training and guidance.

Benefits

All colleagues have access to a Local Government Pension Scheme and the chance to be part of an organisation where you can really make a difference. Located in Sheffield City Centre, we are well-placed for transport links and encourage employees to take advantage of the active travel facilities. Work/life balance is extremely important to us here at SYMCA with our recognised family/friendly policies, genuine work flexibility, recognition, and shared success.

• Holiday Entitlement – From 28 to 36 days annual leave entitlement (depending on length of service) plus bank holidays. Pro-rata for part time colleagues.
• Annual Leave Purchase Scheme – The ability to purchase up to a further 15 days per year in addition to your normal annual leave
• Hybrid working – Our offices are a space where we come together and collaborate. Most of our roles are offered on a hybrid basis with the exception of some support roles being onsite full time. Please note, unless specified within the job advert, we cannot accommodate remote working contracts.
• Flexible Hours Scheme – Most roles within SYMCA work under the Flexi-Scheme which allows office-based employees’ flexibility and discretion over their working hours. Under the scheme employees can accrue a defined amount of credit or debit of working hours, and to take time-off in the form of Flexi-Leave or banked Annual Leave.
• Rewarding You - Reducing everyday expenses through discounts, benefits, financial advice, wellbeing solutions and more with Reward Gateway and Cycle-to-Work schemes.
• Training on the job - Support with upskilling skills through on-the-job training and qualifications
• Professional Membership Fees – Where membership to Professional bodies is applicable to your role, SYMCA will reimburse your membership fees where applicable and following approval by Line Management.

Diversity

Our workforce is made up of a diverse community, where we all belong and feel part of something bigger. We are committed to equality of opportunity and welcome applications from individuals, regardless of age, gender, ethnicity, disability, sexual orientation, gender identity, socio-economic background, religion and/or belief.

All employees are eligible to request Flexible Working arrangements from day one of employment as such all requests will be considered subject to operation requirements.

Where candidates share disabilities within the application process, if they demonstrate that they meet all essential criteria from the Role Profile within their application, they will automatically be invited to interview.

If you require any reasonable adjustments throughout the process, please contact [e-mail] or include within your application form detailing the adjustment and how it will assist in managing any barriers.