AddressThe 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.
- 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.
Competencies:
No specific qualifications required for this role.
Essential Criteria:
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.
Location: 5 Atlantic Quay, Glasgow, G2 8LU / St Andrews House, 2 Regent Street, Edinburgh, EH1 3DG / Victoria Quay, Edinburgh EH6 6QQ / Saughton House, Broomhouse Drive, Edinburgh EH11 3XD
This post is based in Glasgow/Edinburgh, with virtual and hybrid working being the current arrangement. The post will be offered on a location flexible basis, with occasional travel to Glasgow/Edinburgh.
Interview and Assessment: Dates to be confirmed
Minimum time in post:
You will be expected to remain in post for a minimum of three years unless successful at gaining promotion to a higher Band or Grade.
HOW TO APPLY & ADDITIONAL INFORMATION:
How to apply:
To apply for this post, you will need to provide the information requested below via the online application process.
Please submit a CV outlining your relevant skills and experience for the role (no more than 2 sides of A4) and a personal statement (of no more than 750 words) before the closing date.
When considering how your experience relates to the role, please tailor your CV and personal statement to reflect the role, the Essential Criteria and skills as described in the job description.
Please enter your personal statement in the text box provided.
Additional information:
For further information, please download and review the “Person Specification” and associated documentation which you will find below.
Person_Specification_Band_B Updated Oct23 (V3)
Digital, Data and Technology Jobs - Digital Jobs
The post is a full-time role, but staff with different working patterns are invited to apply, and we will assess proposed working patterns against the business requirements for this post.
For information regarding this post please contact Kenny.notman@gov.scot
Scottish Government's ambition is to be a world leading, diverse employer where people can be themselves at work. We want to help you demonstrate your full potential whatever type of assessment is used. If you require any adjustments to our recruitment process, please let us know via scottishgovernmentrecruitment@gov.scot
As part of any recruitment process, Scottish Government and associated public bodies collects and processes personal data relating to job applicants and applicants for public appointments.
Personal information you provide in the recruitment process will be made available to Scottish Government and our additional data processors.
