About the job

Job summary

Would you like to work for a large, operational and delivery focussed Directorate at the forefront of key Scottish Government (SG) priorities and play a pivotal role in the delivery and management of Data & Analytics services within an Oracle Cloud environment?

The Scottish Government’s Corporate Directorate provides a range of services to core SG directorates, public bodies, public inquiries and review bodies.  A new Corporate Hub is being created which will evolve into the future delivery management platform for corporate services provided by DG Corporate.

The newly created Hub sits within the Corporate Data and Analytics function and will form a Centre of Excellence for information products.  It will span multiple data domains and set standards for ensuring appropriate levels of data integrity and data quality.

As the Senior Data Engineer, you will be responsible for delivering the Data & Analytics services, such as data engineering and data- quality management.

As the wider corporate transformation programme evolves, it is expected that the duties of this role may flex to suit varied needs within the Data & Analytics domain.

This is an exciting opportunity to work as part of a motivated, collaborative and supportive team, where you will have the opportunity to practice and further develop your data engineering skills.

DDaT Pay Supplement

This post attracts a £5,000 per annum pro-rata DDaT Pay Supplement after a 3 month competency qualifying period. Pay supplements are temporary payments designed to address recruitment and retention issues caused by market pressures and are subject to regular review.

Job description

• Design, build, operationalise, secure and monitor data pipelines and data stores.
• Frequently develop reusable data pipelines to support regular BI needs, manipulating and linking diverse datasets from all across the digital estate.
• Carry out data quality management operations, such as data profiling and data cleansing etc.
• Carry out data modelling activities as required, especially in collaboration with other DDAT colleagues operating in the Data & Analytics domain within the Corporate Transformation & Workplace and Digital directorates.
• Be actively involved and support data governance activities enabled by the Corporate Hub.
• Be actively involved in the shaping and production of data management policies and standards as required.
• Actively contribute to the wider workings of the Corporate Data & Analytics function.
• Mentor any other Data Engineers in the future.
• Work closely with DDAT colleagues and suppliers across DG Corporate.

Person specification

1. Experience designing, building, testing and monitoring data pipelines and data stores; ideally within an Oracle Cloud environment.
2. Experience supporting colleagues to develop BI products, capturing their data needs, modelling data, and employing appropriate technologies; mainly Oracle Cloud, but also Microsoft Power BI.
3. Demonstrated experience carrying out data quality activities.
4. Strong people management skills with the ability to motivate and mentor team members.

Benefits

Alongside your salary of £44,557, Scottish Government contributes £12,030 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.

Things you need to know

Selection process details

Sift and Interview dates TBC
Please apply using the link provided

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.