Description Job Description 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 Responsibilities Responsibilities • 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. Qualifications 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) How to apply Apply online, providing a CV and Supporting Statement (of no more than 750 words) which provides evidence of how you meet the skills, experience and behaviours listed in the Success Profile above. Should a large number of applications be received, an initial sift may be conducted using the CV and personal statement on Essential Experience. Candidates who pass the initial sift will have their applications fully assessed. We will test your behaviours, the first 2 technical skills and essential experience as part of the sift process, and if successful, you will be invited to an assessment and interview where we will test these again along with all 6 technical skills listed. Full details of the selection process will be made available to shortlisted candidates once the sift has been completed. Candidates selected for interview will be requested to provide a 10-minute presentation on the technical skills required, details of which, will be shared in advance of the interview. In the event of a large number of applications, the hiring manager may raise the pass mark for sift. If you meet the minimum pass mark but are not invited to the first round of interviews, you may be invited to a subsequent round. Any queries on this please contact recruitmentsocialsecurity.gov.scot. We aim to provide feedback on request, however; if we receive a large number of applications, it may not be possible for us to provide feedback on your application if you are not invited to attend an interview/assessment. We will provide feedback on request to all candidates that attend an interview/assessment. Information Session We are holding candidate information sessions for this role to provide you with information about the application and interview process as well as further information on the role and team. We will be talking about: • The Senior Data Engineer role and team • About Social Security Scotland • Our recruitment process • Q&A with the hiring manager The session will be held on Thursday 30th January at 1-2pm Please join us using the link below to find out more about the role and working for Social Security Scotland. Join the meeting now Expected Timeline (subject to change) Sift – w/c 3rd February 2025 Interview – w/c 17th February 2025 Location – In Person in either Dundee or Glasgow Reserve List In the event that there are more successful candidates than posts available, a reserve list will be kept for up to 12 months. About Us Social Security Scotland is an Executive Agency of the Scottish Government. Our benefits help people from all walks of life in Scotland. We offer rewarding careers and employ people across Scotland in a wide range of professions and roles. We are committed to recruiting a diverse workforce that is representative of the clients we serve. Find out more about us here. We offer a supportive and inclusive working environment along with a wide range of employee benefits. Find out more about what we offer. As part of the UK Civil Service, we uphold the Civil Service Nationality Rules. 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. Working Pattern Our standard hours are 35 hours per week and we offer a range of flexible working options, depending on the needs of the role. We embrace a hybrid working style where all colleagues will spend time in either our Glasgow or Dundee offices. There is an expectation of a minimum 2 days per week in your assigned location, which will be either Glasgow or Dundee. If you have specific questions about the role you are applying for, please contact us. Equality Statement Social Security Scotland are committed to equality and inclusion, and we aim to recruit a diverse workforce that reflects the population of our nation. Social Security Scotland are a Disability Confident Employer. We will consider and implement any reasonable adjustments you may require throughout the recruitment process and during the course of your employment, should you be successful in securing a post. If you feel you may require assistance with any part of our recruitment process, please contact us at recruitmentsocialsecurity.gov.scot Find out more about our commitment to diversity and how we offer support and recruitment adjustments for anyone who needs them. Further Information Find out more about our organisation, what we offer staff members and how to apply on our Careers Website. Read our Candidate Guide for further information on our recruitment and application processes. The successful candidate will be expected to remain in post for a minimum of 3 years unless successful in gaining promotion to a higher Band or Grade. Social Security Scotland’s recruitment processes are underpinned by the recruitment principles of the Civil Service Commissioner, which outline that selection for appointment be made on merit on the basis of fair and open competition - Recruitment - Civil Service Commission (independent.gov.uk) If you feel at any time your application has not been treated in accordance with the values in the Civil Service Code and/or if you feel the recruitment has been conducted in such a way that conflicts with the Civil Service Commissioner’s Recruitment Principles, you can make a complaint, by contacting Social Security Scotland at recruitmentsocialsecurity.gov.scot in the first instance. If you are not satisfied with the response you receive you can contact the Civil Service Commissioner. If you experience any difficulties accessing our website or completing the online application form, please contact the Resourcing Team via recruitmentsocialsecurity.gov.scot Apply before - Monday 3rd February 2025 at 23:55 Contact name - Resourcing Team Contact email - recruitmentsocialsecurity.gov.scot