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 Business Intelligence (BI) products, employing Oracle Cloud technologies?

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 Business Intelligence Engineer, you will be producing BI products (for example, reports, dashboards, metrics, visualisations etc.) utilised by SG staff across the organisation.

In order to carry out the responsibilities of this role effectively, you must be experienced with Oracle Cloud solutions as you will be expected to deliver those products by employing Oracle BI Publisher and OTBI. Microsoft Power BI is also used within the organisation, having these skills would be advantageous.

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

• Develop, test, publish and maintain BI products according to business needs.
• Understand & contribute to the underlying data architecture, and carry out data development activities as required in order to produce BI products.
• Provide end user support on the BI products and assist users to develop BI self-service skills.
• Be the resident BI technical expert with the Corporate Hub’s technologies; mainly OTBI), BIP, and Oracle EPM, but also Microsoft Power BI and perhaps others in the future.
• Comply with established data quality, security & governance standards and policies.
• Actively contribute to the wider workings of the Corporate Data & Analytics function.
• Mentor any other BI Engineers in the future.
• Work closely with DDAT colleagues and suppliers across DG Corporate.

Person specification

1. Experienced in the design, development, testing and support of BI products (such as reports, dashboards or metrics) developed with Oracle Cloud technologies.
2. Experienced SQL developer with relational and non-relational data management skills.
3. Experienced in data engineering, such as designing and building maintainable data pipelines (e.g. ETL etc.) to feed diverse reporting needs, including ingestion of semi-structured data sources, predominantly within Oracle Cloud environments.
4. Ability to work effectively in a changing environment, demonstrating flexibility and contributing to overcoming challenges.

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.