Senior Data Engineer

at  Scottish Government

JOB SUMMARY

Have you considered working for Scotland’s devolved tax authority where the work we do and the taxes we collect positively contribute to Scotland’s public services? Do you, like Revenue Scotland, have a passion to make the best use of digital technologies? If so, we would love to hear from you.
Based within Revenue Scotland’s DDaT team, the postholder will head the new data engineering function, working collaboratively across the organisation and with suppliers to deliver improvements to the data platforms supporting Scotland’s devolved tax system. In addition to Land and Buildings Transaction Tax (LBTT), and Scottish Landfill Tax (SLfT), a further two taxes are under active development; Scottish Aggregates Tax (SAT) and Scottish Building Safety Levy (SBSL).
Revenue Scotland is a great place to develop new skills and you will be supported in your role with learning and development to enable you to perform at your best.
We are a diverse, high performing organisation and have a reputation for delivering excellence and a commitment to continually improving the way we work while supporting the health, wellbeing, and development of our employees. Revenue Scotland is a great place to develop new skills and you will be supported in your role with learning and development to enable you to perform at your best.
Take a look at our Video to find out more about working for Revenue Scotland. If you would like to learn more about Revenue Scotland, please visit our website.
Our hybrid working principles require you to attend your assigned office at least 2/3 days each month. Our hybrid approach supports a blend of home and workplace working. This should be agreed with the line manager to achieve the right balance between collaboration, in-person engagement and flexibility. Your assigned office will be Victoria Quay, Edinburgh, with the opportunity to work from our Glasgow hub office.

JOB DESCRIPTION

Digital Data and Technology (DDaT) Pay Supplement:
This post attracts an annual £5,000 pay supplement after a 3 months DDaT 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.
DDaT Professional Role(s)
DDaT Job Family:
Data
DDaT Job Role:
Data Engineer
DDaT Job Role Level:
Senior Data Engineer

A senior data engineer designs and leads the implementation of data flows to connect operational systems, data for analytics and business intelligence (BI) systems. At this role level, you will:

• recognise opportunities to reuse existing data flows.
• lead the build of data streaming systems.
• optimise the code to ensure processes perform optimally.
• lead work on database management.

Key DDaT Capability Descriptor
https://ddat-capability-framework.service.gov.uk/role/data-engineer
This role sits within the data team at Revenue Scotland, and you will be responsible for designing and building the data infrastructure required to support the production of statistics and management information and enabling Revenue Scotland to make greater use of our data.
We have recently published our Corporate Plan for 2024-27, a key element of which is the digital and data strategy. Across these three years we have a vision to integrate our digital systems to provide a single end-to-end digital tax journey for taxpayers and their agents, as well as our tax operations and compliance teams. A key part of our approach involves transforming the way in which we use data in the organisation.
You will be instrumental in improving the way in which data from our operational systems is stored and transformed, to make it useable by the data team and wider business users.
This will involve working with our suppliers and the wider data and digital teams in Revenue Scotland to specify and create a new data platform and data warehouse for the organisation and building the connections with our operational data stores to facilitate the production of management information and exploitation of our data.

Main Duties:

• Take the lead in the design and implementation of a new data warehouse to support operational and MI reporting.
• Liaise with our existing suppliers to understand their data models and how data from multiple sources can be integrated into a common repository.
• Build secure data pipelines to connect the operational datastores to the warehouse.
• Be responsible for data quality across the service and develop strategies to improve this.
• Actively contribute to the wider activities across the DDaT function and support users of data within Revenue Scotland
• Work with the heads of data and governance teams to define data governance requirements.

Below are details of the competencies required for this role and you will be tested against these competencies if you are invited to attend the interview/assessment:
Competencies:
Self-awareness
Improving Performance
Analysis and Use of Evidence
Communications and Engagement
Band B Skills for Success Competency framework

PERSON SPECIFICATION

No formal qualifications are required for this role.
To apply for this post, you will need to provide the information requested below via the online application process.
A CV (no longer than two pages) setting out your career history, with key responsibilities and achievements - this is accessed through the candidate profile.

A Personal Statement (no longer than 750 words) explaining why you consider your personal skills, qualities, and experience suitable for this role, with reference to the essential criteria below:

• A good understanding and experience of building data pipelines, especially transforming data from an operational data store into a form that will easily support official statistics production and business intelligence reporting.
• An appreciation of the importance of data quality and strategies to tackle data quality issues.
• Ability to work in a multidisciplinary team along with other analytical and DDaT specialists.
• Excellent communication skills with the ability to be persuasive in promoting your work, especially to non-technical customers.

When considering how your experience relates to the role, please tailor your CV and personal statement to reflect the role and the essential skills/criteria as described in the job description/person specification.
When reviewing your application, we will be assessing your career history and achievements against the essential criteria for the role. We are looking for examples of things you have previously achieved or your knowledge in a particular field which are relevant to the role.
Guidance and further information:
Benefits
As a member of the Digital, Data and Technology Profession we are proud to offer great benefits including flexible working, generous pension and holiday allowances. Click here to learn more
For more information about working at Revenue Scotland please visit our careers page: Careers at Revenue Scotland , Revenue Scotland
Provisional Dates for Sift and Interview/Assessment:
Sift – TBC
Interview/Assessment – TBC
If successful at sift you will be required to participate in a DDaT assessment. This will be followed by a competency-based interview. Further information regarding the exercise will be provided to candidates who are invited to interview.
Benefits

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

• Learning and development tailored to your role
• An environment with flexible working options
• A culture encouraging inclusion and diversity
• A Civil Service pension with an average employer contribution of 27%

Things you need to know

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)

A senior data engineer designs and leads the implementation of data flows to connect operational systems, data for analytics and business intelligence (BI) systems. At this role level, you will:

• recognise opportunities to reuse existing data flows.
• lead the build of data streaming systems.
• optimise the code to ensure processes perform optimally.
• lead work on database management

Main Duties:

• Take the lead in the design and implementation of a new data warehouse to support operational and MI reporting.
• Liaise with our existing suppliers to understand their data models and how data from multiple sources can be integrated into a common repository.
• Build secure data pipelines to connect the operational datastores to the warehouse.
• Be responsible for data quality across the service and develop strategies to improve this.
• Actively contribute to the wider activities across the DDaT function and support users of data within Revenue Scotland
• Work with the heads of data and governance teams to define data governance requirements

A Personal Statement (no longer than 750 words) explaining why you consider your personal skills, qualities, and experience suitable for this role, with reference to the essential criteria below:

• A good understanding and experience of building data pipelines, especially transforming data from an operational data store into a form that will easily support official statistics production and business intelligence reporting.
• An appreciation of the importance of data quality and strategies to tackle data quality issues.
• Ability to work in a multidisciplinary team along with other analytical and DDaT specialists.
• Excellent communication skills with the ability to be persuasive in promoting your work, especially to non-technical customers