Data Engineer at Registers of Scotland

, , United Kingdom -

Full Time

Start Date

Immediate

Expiry Date

25 Jun, 26

Salary

54482.88

Posted On

27 Mar, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Python, SQL, Relational Databases, ETLs, Data Integration Systems, Data Transformation, Version Control Systems, CI/CD, Software Development Lifecycle, Data Modelling, Database Design, Monitoring Tools, TDD, Data Integration Design Patterns, Agile

Industry

Government Administration

Description

Grade: HEO Total remuneration: from 1st April- £47,590.16-£54,482.88 Pay Supplement: The base salary for this role is £41,026-£46,968. This job qualifies for a Digital, Data and Technology Annual Pay supplement, 16% is included in the total remuneration above. Pension: 28.97% of total remuneration from 1st April (RoS contribution) Annual leave: 38 days annual holiday, increasing to 42 days with length of service. Duration: Permanent Working Pattern: 35 hours per week. We are a flexible employer and will consider a variety of working patterns on a case-by-case basis. For example, compressed hours, term-time working or part-time working. Location: Hybrid working model. Contractual base either at Meadowbank House, Edinburgh (EH8 7AU), or St Vincent Plaza, Glasgow (G2 5LD). You will be expected to attend one of these locations as required by the role. Department: Data Directorate: Digital, Data and Technology Role Reports to: Head of Data Engineering Closing date: Friday 17 April 09:00 Number of vacancies: One Registers of Scotland (RoS) Join an award-winning organisation recognised for its technology and innovation. Registers of Scotland is a world-leading pioneer in land and property registration. Our full-stack teams design, architect, and build all our registration products in-house. We work to create digital solutions for the people of Scotland. You will get an opportunity to nurture your creativity and develop with us through access to the latest data, software engineering and product delivery techniques. This job is for you if you want… Work with purpose: working for the people of Scotland to set the bar for land and property registration worldwide. Flexible and hybrid working: depending on the role and team requirements, work when and where it’s best for you and your stakeholders. Benefits: enjoy pay progression, pension contributions of up to 28.97%, up to a year’s parental leave, and 38 days annual holiday, increasing to 42 days with length of service. Investment in professional development: we invest in all our people so that they have the right skills to be productive and confident in their job. Diversity and Inclusion: We are an ‘Investor in People’ and a ‘Disability Confident’ employer. We are inclusive, stronger together, and committed to putting our people first. Positive work culture: RoS is an agile, digital organisation using leading-edge technology. Colleagues understand their role in achieving our strategy and have the autonomy to deliver. To learn more about RoS and what we offer visit our careers pages or watch this short video. Hear from our colleagues about their experience of working within our Digital, Data and Technology teams on our website. The Role An experienced Data Engineer is required to join the Data Engineering team, part of the wider Data & Analytics function at Registers of Scotland. The team is responsible for developing and maintaining the RoS data warehouse, building robust data pipelines, data transformation processes and bespoke data products to support the needs of our internal and external stakeholders and customers. On a typical day you will… Work independently and as part of a small Agile delivery team to deliver secure, robust, scalable and adaptable software solutions Contribute to the development of data integration, processing, and transformation solutions which adhere to RoS’ technical standards and principles Actively participate in team/agile events, supporting the team to improve their processes Collaborate closely with team members and stakeholders to ensure solutions meet user requirements Deliver solutions through the full lifecycle from inception to deployment Maintain and support existing systems and find, document and debug issues Understand the business context and value of the enduring solutions you are involved in developing Create and maintain supporting technical and business documentation Essential Criteria – Skills and Attributes for Success Technical: We will assess you against the following technical skills during the application and assessment process: Working knowledge of the Python programming language Skilled in using SQL and modern relational databases Experience of ETLs, data integration systems and data transformation Experience with using version control systems to drive feature control and CI/CD in an enterprise development community Experience of the software development lifecycle Experience of delivering working software Experience of supporting and maintaining existing systems Understanding of data modelling and database design Understanding of monitoring tools and processes Understanding of TDD to drive development Awareness of data integration design patterns Behaviours At application stage, you will be scored against the bolded Behaviours and against all Behaviours for the assessment: Changing and improving Actively identifies areas for improvement, using technology where possible to maximise efficiency Making effective decisions Uses evidence and knowledge to support accurate, expert decisions and advice. Carefully considers alternative options, and the implications and risks of decisions Working together Establishes relationships with a range of stakeholders to support delivery of business outcomes Developing self and others Identifies capability gaps and ensures development objectives are set to address these and to enable deliver of current and future work Stage one - Application Process To apply, click on 'Apply now' and complete the online application form. You will need to submit: A CV outlining your career history and how you meet the technical criteria (max 4 pages). Two responses providing an example of how you meet the bolded behaviour aspects of the role- Changing and improving and Working together (maximum 300 words per answer in the spaces provided). As part of the application process, you will receive an online assessment invitation via Hackerrank and you will have 3 days to complete it. This will be sent after the advert closing date. Please note: If we receive a high volume of applications, we may complete an initial sift on the technical criteria. We reserve the right to invite candidates to participate in a telephone interview prior to being further assessed. Applications that are not accompanied by CVs or responses exceeding 300 words per behaviour will not be considered. We would strongly recommend that your responses are written in the STAR format (Situation, Task, Action & Result) and preparing your answers using software such as MS Word or Google Docs, and then copying the content into the application form. We strongly advise you review our policy on responsible use of AI in the application process. RoS may check answers with an AI detection tool and will contact you for a pre-screening call to verify your responses. Applications and appointments are subject to a strict merit-based assessment process, in line with the Civil Service Recruitment Principles. Stage two – Assessment If successful at application stage, you will be invited to an in-person interview at our Edinburgh office (Meadowbank House, 153 London Road, Edinburgh EH8 7AU) which will include the following: Behaviour based interview Technical interview with questions focussed on the essential technical criteria Recruitment timeline Closing date- Friday 17 April at 09:00 Hackerrank test issued- Friday 17 April Application sift- week commencing Monday 20 April Invites to assessment: week commencing Monday 27 April Assessments begin- week commencing Monday 4 May * Please note dates are subject to change. Information on Success Profiles For further information on success profiles, visit here- Success Profiles. Feedback Feedback will only be provided if you progress to interview stage. Reserve List In the event that further posts are required, a reserve list of successful candidates will be kept for up to 12 months. Nationality and immigration status (EXTERNAL JOBS ONLY!) In general, only nationals from the following countries (and associations of countries) are eligible for employment in the Civil Service: the United Kingdom, the Republic of Ireland, and the Commonwealth. EU nationals (with settled or pre-settled status), certain EEA nationals, Swiss and Turkish nationals are also eligible for employment. Detailed provisions on determining eligibility on the grounds of nationality and, where relevant, immigration status can be reviewed here. Security Successful candidates must undergo a Basic Level 1 Disclosure check. Individuals working with government assets must complete baseline personnel security standard checks. Equality, diversity and inclusion As a proud member of the Disability Confident Scheme, we welcome applications from disabled candidates. We’re not as diverse as we’d like yet, and we’re working on it. We especially welcome applications from underrepresented groups – people who are disabled, minoritized ethnic groups, and younger people (16-24 years of age). To learn more please see our EDI strategy. As part of the application process, we would like to invite you to please complete our diversity monitoring form. This information is not shared with recruitment panels. If you require any adjustments to our recruitment process, please let us know via talent@ros.gov.uk. Please see this page for more information on adjustments. Further information For further information relating to RoS, including: · Additional details on pay & benefits · The Civil Service Code · Complaints process · Use of AI in the application/recruitment process, Please view our additional information page online If you have any questions, please contact talent@ros.gov.uk

Responsibilities

The role involves developing and maintaining the data warehouse, building robust data pipelines, and creating data transformation processes and bespoke data products to support internal and external stakeholders. Responsibilities include delivering secure, robust, and scalable software solutions within an Agile team structure and collaborating with stakeholders to meet user requirements.