Contents Location About the job Benefits Things you need to know Apply and further information Location Dundee, Glasgow About the job Job summary Join us at Social Security Scotland as a Senior Data Engineer and be at the forefront of our ambitious digital transformation. This role offers an exciting opportunity to work with a talented team and turn data into a driving force for positive change, helping us create a system that supports the people of Scotland for decades to come. As a Senior Data Engineer within the Chief Digital Office (CDO) at Social Security Scotland, you will play a crucial role in developing robust data infrastructure and systems that underpin our diverse digital initiatives. Collaborating with a growing team of digital experts across Engineering & Cloud Services, Architecture, Applications and more, you will design and implement data flows that facilitate analytics and business intelligence. Your expertise will ensure the delivery of high-quality data products that meet the needs of our stakeholders and enable effective decision-making. We are committed to fostering a positive and inclusive culture that empowers all team members to thrive, making this an exciting opportunity to contribute to meaningful societal change. A Senior Data Engineer delivers the designs set by more senior members of the data engineering community. At this role level, you will: Implement data flows to connect operational systems, data for analytics and business intelligence (BI) systems Re-engineer manual data flows to enable scaling and repeatable use Support the build of data streaming systems Write ETL (extract, transform, load) scripts and code to ensure the ETL process performs optimally Build accessible data for analysis DDaT Pay Supplement This post attracts a £5000 Digital, Data and Technology (DDaT) pay supplement after a 3 months DDaT competency qualifying period. The payment will be backdated to your start date in the role. Pay supplements are temporary payments designed to address recruitment and retention issues caused by market pressures and are subject to regular review. This post is part of the Scottish Government DDaT profession. As a member of the profession you will join the professional development system, currently BCS Role Mode plus. Job description Design, build and test data products based on feeds from multiple systems, using a range of different storage technologies, access methods or both. Create repeatable/reusable and scalable products. Create and maintain appropriate data models. Can carry out simple analysis of errors for databases, data processes, data products and services. Design and code programs or scripts in SQL and Python which meet user stories and requirements. Code, amend and refactor moderately complex programs / scripts in accordance with the design. Perform data transformation and normalisation tasks to make the data usable for analysis and reporting purposes. Keep up to date with relevant technologies, concepts, and frameworks. Contribute and support conversations in meetings, e-mails, documentation, and workshops with relevant stakeholders. Engage with your Digital Data and Technology specialist community, for example attending community knowledge exchanges, and providing technical peer support of various kinds whether expert consultancy advice, code review, or pair programming. Person specification Success Profiles We use an assessment framework called Success Profiles which lists the elements we test and provides detailed descriptions of each. Find out more about how we assess the Success Profile elements. Essential Experience Experience of designing, testing and building data pipelines to produce quality datasets for systems or customers. Experience of leading investigative work into problems and opportunities in existing processes and created recommendations. Technical/Professional Skills This role is aligned to Data Engineer within the Digital, Data and Technology Profession. Please review the following to understand the skill expectations Data engineer - Government Digital and Data Profession Capability Framework We will assess you against the following technical skills during the selection process: 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) Please note that only the first 2 technical skills listed will be tested at application stage: Programming and Build; and Technical Understanding. Behaviours Leadership (Level 3) Working Together (Level 3) You can find out more about Success Profiles Behaviours, here: Success Profiles - Civil Service Behaviours (publishing.service.gov.uk) Benefits Annual Leave - You will receive 25 days annual leave on joining us. This will increase to 30 days after four full years of service. You will also have 11.5 public and privilege days of leave every year. We also offer Flexi-time. Any extra hours you've worked can be taken as leave when suitable. A Civil Service Pension - This job comes with a Civil Service pension. New joiners to the Civil Service will join a career average pension scheme as standard. Read more here - www.civilservicepensionscheme.org.uk. Healthy work life balance - We can offer the possibility of full-time, part-time, term-time, and job shares. We also encourage flexible working. Discounts - You can enjoy a vast range of retail, travel and lifestyle discounts through our benefit scheme. Personal support for you - Our Employee Assistance Programme gives you confidential, independent information and guidance 24/7. Volunteering special leave - Up to six days paid special leave a year for volunteering. We support our staff to help causes important to them. Great locations - Our bright and modern offices in the heart of Dundee and Glasgow have been designed with staff in mind. Both locations are ideal for public transport. Things you need to know Selection process details Expected Timeline (subject to change) Sift w/c 11th February 2025 Interview w/c 24th February 2025 Location In Person in either Dundee or Glasgow Feedback will only be provided if you attend an interview or assessment. Security Successful candidates must undergo a criminal record check. People working with government assets must complete baseline personnel security standard (opens in new window) checks. Nationality requirements This job is broadly open to the following groups: UK nationals nationals of the Republic of Ireland nationals of Commonwealth countries who have the right to work in the UK nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities with settled or pre-settled status under the European Union Settlement Scheme (EUSS) (opens in a new window) nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities who have made a valid application for settled or pre-settled status under the European Union Settlement Scheme (EUSS) individuals with limited leave to remain or indefinite leave to remain who were eligible to apply for EUSS on or before 31 December 2020 Turkish nationals, and certain family members of Turkish nationals, who have accrued the right to work in the Civil Service Further information on nationality requirements (opens in a new window) Working for the Civil Service The Civil Service Code (opens in a new window) sets out the standards of behaviour expected of civil servants. We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's recruitment principles (opens in a new window). The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria. Diversity and Inclusion The Civil Service is committed to attract, retain and invest in talent wherever it is found. To learn more please see the Civil Service People Plan (opens in a new window) and the Civil Service Diversity and Inclusion Strategy (opens in a new window). Apply and further information This vacancy is part of the Great Place to Work for Veterans (opens in a new window) initiative. The Civil Service welcomes applications from people who have recently left prison or have an unspent conviction. Read more about prison leaver recruitment (opens in new window). Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records. Contact point for applicants Job contact : Name : Resourcing Team Email : recruitmentsocialsecurity.gov.scot Telephone : 08001577194 Recruitment team Email : recruitmentsocialsecurity.gov.scot Further information https://www.socialsecurity.gov.scot/jobs/how-to-make-a-great-application Apply at advertiser's site Share this page Print Email Facebook Twitter LinkedIn GMail