Senior Data Engineer

HM Revenue and Customs; London; Hybrid; GBP 44,000 - 51,000; Full time

Job summary

HM Revenue and Customs seeks a Data Engineer to enhance the data lakehouse capabilities. The role involves collaboration across teams to streamline data processes and produce accredited official statistics, contributing significantly to the governance of UK's rail statistics. Flexible working arrangements and a comprehensive benefits package are offered.

Benefits

Flexible working arrangements

29% pension contribution

Generous annual leave

Season ticket loans

Cycle-to-work schemes

Mental health and well-being support

Qualifications

• Experience with Azure Databricks and Umbraco CMS.
• Experience of creating and editing data loading processes.
• Experience of producing and editing Power BI reports.

Responsibilities

• Creating and editing configuration files within the data lakehouse.
• Working collaboratively with data suppliers to ensure timely data loading.
• Supporting the statistical production process by validating data.

Skills

Data Engineering

Data Analysis

Collaboration

Quality Assurance

Tools

Azure Databricks

Umbraco CMS

Power BI

Job description

London, Birmingham, Bristol, Manchester, York, Glasgow

Application Deadline

Application Deadline 2 days remaining

This role can be based at any of our office locations: London, Birmingham, Bristol, Manchester, York, Glasgow.

At ORR we have adopted hybrid working and are currently expected to work from a workplace location for a minimum of two days per week or 40%.

The Information and Analysis (I&A) team comprises of statisticians and business intelligence staff responsible for the data collection, analysis and publication of official statistics for the rail industry.

• Regional office salary range: £40,217 to £46,646
• London office salary range: £44,396 to £50,821

The Information and Analysis (I&A) team is responsible for data engineering and governance, publishing official statistics on rail and providing analytical support to policy teams across ORR to support monitoring of Network Rail, HS1, train operators, and other duty/licence holders.

Job purpose

Join us in unleashing the potential of our new data lakehouse within ORR and beyond

Working in a diverse and friendly team, your data engineering expertise will put you at the forefront of our exciting plans for teams across ORR get the most out of their data. Working in collaboration with data owners and data suppliers, you will support the re-design of our data collection processes and develop tools to support policy and operational colleagues make decisions that have a real impact on the running of Britain’s railways.

You will work with a team of data engineers, statisticians, analysts and a wide range of internal stakeholders to transform our outputs by creating and implementing efficient, automated data processes. You will work collaboratively with counterparts across our regulated industries and have the opportunity to represent ORR on cross-government data networks.

This job provides you with the opportunity to not only learn about the breadth and depth of work involved in a regulatory environment but also how we combine that with our role as publisher of official statistics on rail.

ORR offers you flexible working arrangements at any one of our six offices across Britain, including hybrid working, compressed hours and generous annual leave (starting at 25 days plus bank holidays). ORR contributes 29% to your pension and as well as other benefits including season ticket loans, cycle-to-work schemes, mental health and well-being support. You also benefit from being part of the Civil Service, offering a wealth of options for career progression and development.

Key responsibilities

Your key responsibilities, although not exhaustive, will include:

• Creating and editing configuration files within the data lakehouse to manage and improve existing data loading processes.
• Working collaboratively with data suppliers and ORR colleagues to ensure data is received and loaded to the data lakehouse in a timely fashion.
• Apply best practice data standards to the data lakehouse.
• Supporting the statistical production process by quality assuring and validating data.
• Creating reports from the data lakehouse to support ORR’s statistical outputs including accredited official statistics.
• Publishing official statistics on the data portal.
• Creating and editing regulatory dashboards using Power BI.
• Advising colleagues on the most efficient data storage and reporting methods.
• Line manage one Grade E postholder.

Behaviours

• Changing and improving
• Working together

Experience

• You have experience with Azure databricks and Umbraco CMS.
• You have experience of creating and editing data loading processes.
• You have experience of working with official statistics.
• You have experience of producing and editing Power BI reports.

This job description provides an overview of key duties and responsibilities and is not exhaustive. You may be expected to undertake other duties and responsibilities within the scope of your role and as appropriate for your grade. For an informal chat about this job please contact the line manager Nisha Nair at [e-mail]

How we will assess your application

Shortlisting

This post is being recruited using Civil Service Success Profiles . These are designed to identify the skills that we believe will help you to excel in this job. For this job, we will assess your application against the Behavioursand Experience listed above at sift stage.In your Supporting Statement, please provide an example for each of the bullet points listed in the Behaviours and Experience sections. Please use the STAR (Situation, Task, Action, Result) approach when writing your examples.

If we receive a large number of applications, we will conduct an initial pre-sift based on our lead behaviour, Changing and improving. Successful candidates at the pre-sifting stage will then progress to a full sift, covering all of the Behaviour and Experienceexamples provided in your application.

Interview

We will assess you against the Behaviours and Experiencecompetencies listed above at interview stage. Interviews are expected to be held in the week commencing 28 July.

London, Birmingham, Bristol, Manchester, York, Glasgow

Birmingham, Leeds, Liverpool, London – Canary Wharf (Core HQs) or Homeworking