Hybrid SQL Database Developer – ETL & Azure Data

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

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.