Data Engineer

Job summary

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.

Job description

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

Person specification

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

Behaviours

We'll assess you against these behaviours during the selection process:

• Changing and Improving
• Developing Self and Others
• Making Effective Decisions
• Working Together

Benefits

Alongside your salary of £47,590, Registers of Scotland contributes £13,786 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.

• 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.

Things you need to know

Artificial intelligence

Artificial intelligence can be a useful tool to support your application, however, all examples and statements provided must be truthful, factually accurate and taken directly from your own experience. Where plagiarism has been identified (presenting the ideas and experiences of others, or generated by artificial intelligence, as your own) applications may be withdrawn and internal candidates may be subject to disciplinary action. Please see our candidate guidance (opens in a new window) for more information on appropriate and inappropriate use.

Selection process details

This vacancy is using Success Profiles (opens in a new window), and will assess your Behaviours.

Stage one - Application Process
To apply, click on 'Apply now' and complete the online application form.
You will need to submit:

1. A CV outlining your career history and how you meet the technical criteria (max 4 pages).
2. 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).
3. 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 will only be provided if you attend an interview or assessment.

Security

Successful candidates must undergo a criminal record check.Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check (opens in a new window).

See our vetting charter (opens in a new window).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 theCivil 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

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 : Talent Acquisition
• Email : talent@ros.gov.uk

Recruitment team

• Email : talent@ros.gov.uk

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

https://www.ros.gov.uk/