Location
About the job
Job summary
Job description
We encourage applications from people from all backgrounds and aim to have a workforce that represents the wider society that we serve. We pride ourselves on being an employer of choice. We champion diversity, inclusion and wellbeing and aim to create a workplace where everyone feels valued and a sense of belonging. To find out more about how we do this visit: https://www.gov.uk/government/organisations/ministry-of-justice/about/equality-and-diversity.
His Majesty’s Courts and Tribunals Service
Directorate: HMCTS Finance, Governance and Performance (within Analysis and Performance)
Job Title: Senior Data Engineer
Salary:
£37,683 – £41,506 (National) which may include an additional allowance of up to £15,317
£43,647 – £48,067 (London) which may include an additional allowance of up to £13,753
Number of Jobs: 2
Detail of Reserve List: 12 Months
Pay Band: SEO
Post Type: Permanent
Working Pattern: Full Time
Base location: National (hubs in London, Manchester, Birmingham, Leeds. Other major HMCTS locations will be considered.
Overview
His Majesty’s Court and Tribunals Service is an agency of the Ministry of Justice and provides the supporting administration for the judiciary across England and Wales along with some Tribunals in Scotland. It delivers services to the public directly in court and tribunal buildings, remotely via business centres and some limited services via the internet.
HMCTS has embarked on a challenging modernisation programme with the vision to modernise and upgrade our justice system so that it works even better for everyone, from judges and legal professionals, to witnesses, litigants, and the vulnerable victims of crime. This will help consolidate the UK’s position at the forefront of an increasingly competitive international legal market as well as ensuring access to justice for all. This is an exciting time to join the organization and be part of a programme making a real difference.
For more information about our digital transformation, watch the Justice Matters video to see the benefits this £1bn investment is delivering to our customers: https://youtu.be/3_xDMTQ6DJQ
The Analysis & Performance team plays a pivotal role in supporting a whole range of senior leaders across the business through reporting, analysis and insights. Our work supports the organisation’s overall strategy and empowers senior leaders to make strategic, data driven business decisions. In December 2021 we published our Data Strategy, setting out HMCTS’s commitment to becoming a data driven organisation.
HMCTS Data Strategy (publishing.service.gov.uk)
As part of this strategy, HMCTS has invested in a cloud-based strategic data platform to transform the ways in which we work with data and enable us to add more value than ever to the organisation and the public. This platform is now technically complete, and we are looking for enthusiastic and motivated individuals to join our team and help us exploit our new technology.
This role will be based in our Data Management and Engineering team responsible for holding, curating, and protecting our data to drive value for our organisation both now and into the future.
Job Description
What will the successful candidate be doing?
• Contribute to the delivery of physical data models and views required for data exploiters to enable visualization of metrics and the provision of insightful analysis for data science projects.
• Develop data ingestion and transformation processes for new and existing data sources.
• Work with subject matter experts to develop and implement the business rules and definitions underpinning measures, metrics and KPIs.
• Collaborate effectively with the operational colleagues across the organisation, internal project teams and other stakeholders to gather, refine and deliver requirements to meet business needs.
• Act as technical lead for one or more HMCTS jurisdictions and overall data management framework.
• Embed improved ways of working with data across the wider team, including automation of manual tasks and data assurance.
Essential Criteria
Technical expertise
• Experience of ETL and data integration, including exporting data from various source data systems, transforming data against required business rules and data models, or data storage and analysis requirements, and loading data in various storage platforms.
• Experience of working with data and databases, ideally involving the development of new and existing data sources in a Data Warehouse environment.
• Good understanding of Data Warehouse techniques, including dimensional data modelling and relational database design and concepts (e.g. Kimball).
• Strong SQL experience and technical database expertise using relational databases such as Oracle Database & PL-SQL or Microsoft T-SQL.
Desirable criteria
• Experience of writing parameterised code in either a programming or scripting language such as PL-SQL or Python/Spark and experienced in delivering metadata driven development processes.
• Experience of building pipelines in cloud technologies such as Azure Data Factory/Databricks.
• Experience using Python and Apache Spark (Pyspark, Spark SQL).
Your Development
· You will have access to a wide range of tools to continually develop and enhance your Data skills, such as: access to Microsoft Azure training courses via our partnership with Microsoft, online training such as DataCamp or Pluralsight, webinars, taught courses, one-to-one coaching and access to a large peer-support network.
Behaviours
We will assess you against these behaviours (Civil Service Behaviours) during the selection
process:
• Changing and Improving
• Working Together
• Developing Self and Others
• Delivering at Pace
Application
We will assess on behaviours and technical skills as listed in the advert.
CV giving details of your employment history and the role you have played in projects.
Statement of suitability (1,000 words max) outlining how you meet the criteria for the role as described in the Key Responsibilities section above.
For each of the four Success Profile Behaviours please provide a 250-word statement of evidence on how your skills, knowledge and experience meet the behaviour to Level 3 standard.
If we receive high volumes of applications, we will sift only on the lead behaviour of “Changing & Improving”.
Interview
The interview will involve a discussion around the strengths, behaviours & technical skills required for this role. Candidates will also need to prepare a 5-minute verbal presentation (no handouts needed). This will be followed by short follow-up questions. The presentation topic will be sent to candidates before the interview.
At interview stage there will also be a technical test to assess candidates’ skills in using SQL.
Flexible working options
HMCTS offers a flexible working system in its offices and hybrid working between office and home is standard across the team.
Job Sharing and Reduced Hours
All applications for job sharing or reduced hours will be treated fairly and on a case-by-case basis in accordance with the MoJ’s flexible working policy and equality policy.
Excess Fares and Relocation Allowances
This job is not eligible for a relocation allowance, but excess fares may be considered in accordance with MoJ’s excess fares allowance policy.
Travel
Infrequent travel to attend unit and whole team meetings will be expected.
DDaT Professional Membership
Please Note: This post aligns to the Digital Data and Technology (DDaT) Data Engineering profession. This can result in an uplift to the postholders salary and to access this uplift the postholder will need to complete an assessment to demonstrate the required skills for DDaT membership.
Person specification
Behaviours
We’ll assess you against these behaviours during the selection process:
- Changing and Improving
- Working Together
- Developing Self and Others
- Delivering at Pace
Technical skills
We’ll assess you against these technical skills during the selection process:
- Assessment of skills in using SQL.
Benefits
- Access to learning and development
- A working environment that supports a range of flexible working options to enhance your work life balance
- A working culture which encourages inclusion and diversity
- A Civil Service pension with an average employer contribution of 27%
- Annual Leave
- Public Holidays
- Season Ticket Advance