Senior Data Engineer WITH VISA SPONSORSHIP

Employer: Social Security Scotland
Location: Dundee, Glasgow, United Kingdom
Job Type: Permanent, Full-time
Salary: £45,894 – £54,952 per year
Additional Pay: £5,000 Digital, Data, and Technology (DDaT) pay supplement after 3-month qualifying period
Application Deadline: 11:55 pm, Tuesday, 11th February 2025
Number of Positions: 2

Job Summary

Social Security Scotland is seeking a Senior Data Engineer to join its Chief Digital Office (CDO) team. This role is crucial in supporting the agency’s digital transformation by designing and implementing data pipelines and infrastructure to enable business intelligence and analytics.

As part of the Engineering & Cloud Services, Architecture, and Applications teams, the Senior Data Engineer will work on data flow automation, ETL processes, and data streaming to ensure smooth and efficient data management. This position plays a vital role in ensuring data accessibility, quality, and usability for decision-making.

Key Responsibilities

• Implement data pipelines to connect operational, analytical, and business intelligence (BI) systems
• Re-engineer manual data flows for automation and scalability
• Develop and maintain data streaming systems
• Write and optimize ETL (Extract, Transform, Load) scripts
• Build accessible, structured, and high-quality datasets
• Design, build, and test data products using multiple storage technologies
• Perform data transformations and normalizations to improve usability
• Write and maintain SQL and Python scripts to support data operations
• Collaborate with stakeholders across various teams to ensure effective data integration
• Stay updated on new technologies, frameworks, and best practices in data engineering

Essential Experience & Skills

Experience Required:

• Designing, testing, and building data pipelines to deliver high-quality datasets
• Leading investigations into data issues and making recommendations for improvements

Technical/Professional Skills:

• Programming and Build (Data Engineering) – Level: Working
• Technical Understanding (Data Engineering) – Level: Working
• Data Development Process – Level: Working
• Data Integration Design – Level: Working
• Data Modelling – Level: Working
• Problem Management – Level: Awareness

Behaviours Assessed:

• Leadership (Level 3)
• Working Together (Level 3)

Benefits

• Annual Leave: 25 days (increases to 30 days after 4 years) + 11.5 public and privilege holidays
• Civil Service Pension: Career-average pension scheme
• Flexible Work Options: Full-time, part-time, job-share, and term-time available
• Retail & Lifestyle Discounts: Various employee benefit schemes
• Employee Assistance Programme: 24/7 confidential guidance and support
• Volunteering Leave: Up to 6 paid days per year for volunteering
• Modern Workspaces: Offices in Dundee and Glasgow, well-connected to public transport

Application & Selection Process

• Application Deadline: 11th February 2025 (11:55 pm)
• Sift Process: Week commencing 11th February 2025
• Interviews: Week commencing 24th February 2025 (In-person at Dundee or Glasgow)
• Assessment Stages: Programming & Build (Data Engineering) and Technical Understanding

Additional Requirements

• Security Clearance: Baseline Personnel Security Standard (BPSS) check required
• Nationality: Open to UK nationals, Irish nationals, and select Commonwealth & EU citizens with the right to work in the UK

For more information and to apply, visit: Social Security Scotland Jobs