About the job

Job summary

• Are you interested in joining a team where your expertise will be crucial to help deliver high quality services to help regulate and support the charity sector in England and Wales?
• Can you contribute to manage and optimise our data pipelines and processes, and be a part of our journey as an organisation to be more data-driven and proactive?
• Do you like learning and continuously improving your Data Engineering skills and knowledge?

As a member of the multi-skilled DDaT (Digital Data and Technology) function it is essential that the post-holder works closely and collaboratively within the Data Engineering Team, the DDAT Directorate and the wider Commission. Ensuring excellent customer service to enable the Commission to use its data assets to achieve strategic aims, this job description and its responsibilities are aligned to the Digital, Data and Technology profession capability framework. 

As a Data Engineer, you will the support the design, development, maintenance and optimisation of data flows and infrastructure, working closely with colleagues to ensure data is readily available and accessible to stakeholders, enabling the Commission to continue delivering high-quality services to internal and external customers.

Job description

Key responsibilities:

•  Communicating between the technical and non-technical. You can show an awareness of the need to translate technical concepts into non-technical language. You can understand what communication is required with internal and external stakeholders.
• Data analysis and synthesis. You can undertake data profiling and source system analysis. You can present clear insights to colleagues to support the end use of the data.
• Data development process. You can design, build, and test data products based on feeds from multiple systems, using a range of different storage technologies, access methods or both. You can create repeatable and reusable products.
• Data innovation. You can show an awareness of opportunities for innovation with new tools and uses of data.
• Data integration design. You can deliver data solutions in accordance with agreed organisational standards that ensure services are resilient, scalable and future proof.
• Data modelling. You can explain the concepts and principles of data modelling. You can produce, maintain, and update relevant data models for an organisation’s specific needs. You can reverse-engineer data models from a live system.
• Metadata management. You can work with metadata repositories to complete complex tasks such as data and systems integration impact analysis. You can maintain a repository to ensure information remains accurate and up to date.
• Problem resolution (data). You can explain the types of problems in databases, data processes, data products and services.
• Programming and build (data engineering). You can design, code, test, correct and document simple programs or scripts under the direction of others.
• Technical understanding. You can understand the core technical concepts related to the role and apply them with guidance.
• Testing. You can correctly execute test scripts under supervision. You can understand the role of testing and how it works.

Person specification

Ability:

• Ability to work with a variety of internal and external stakeholders
• Collaborative
• Strong attention to detail & problem-solving skills
• Write ETL (extract, transform, load) scripts and code to ensure the ETL process performs optimally
• Build accessible datasets for analysis
• Understanding data requirements & design documents
• Documenting work and processes
• Implement data flows to connect operational systems, data for analytics and business intelligence (BI) systems. 

Experience:

• Microsoft SQL Server and/or Azure SQL
• ETL & Data Orchestration tooling, like Azure Data Factory
• Monitoring & Diagnostic tools, like Azure Monitor
• Source control
• Azure DevOps

Technical:

• Detailed knowledge in the development of dataflows and pipelines for data integration
• Good understanding of ETL/ELT
• Working knowledge of SQL

Benefits

Alongside your salary of £35,086, Charity Commission contributes £9,473 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

This vacancy is using Success Profiles (opens in a new window), and will assess your Behaviours and Experience.

To apply for this post, you must complete an online application with the following: 

• A blind CV setting out your Job History/Full Qualifications/Previous skill and experiences.
• A Personal Statement (maximum 750 words) demonstrating how you meet the essential criteria for the role outlined on the Job Description.

At interview you will be assessed on your technical knowledge and experience and the behaviours outlined in the advert.

Interview Arrangements

Interviews will be taking place Face to Face in our Liverpool and Newport Office.

The sift is due to take place on 27/03/2024.

Interviews will be held Liverpool 10/04/2024, and Newport 11/04/2024. 

We will try to meet the dates set out in the advert. There may be occasions when these dates change. You will be provided with sufficient notice of the confirmed dates. 

At the interview, the panel can then probe further and ask applicants to provide further specific examples that show how they best demonstrate their skills.

We reserve the right to raise the score required at any stage of the process to manage numbers.

The Civil Service welcomes applications from people who have recently left prison or have an unspent conviction. Read more about prison leaver recruitment.

Behaviours:

The distinguishing Behaviours (the required skills, knowledge, and behaviours) for this role are set out in the Civil Service Behaviours Framework 2018 (Success Profiles - GOV.UK (www.gov.uk)) and should be referred to when making this application.

You are required, under the Behaviours approach, to describe how you have dealt with a specific situation.

You must give evidence of your knowledge, skills, and behaviours and how you have applied this, such as what you did or said and how you interacted with other people.

When you are giving your examples, do not spend too many words on description and background information. Avoid using general or unspecific statements. Instead say what the situation was, what you did, what your thought process was and what was the result.

Reasonable Adjustment:

If a person with disabilities is put at a substantial disadvantage compared to a non-disabled persons, we have a duty to make reasonable changes to our processes.

If you need a change to be made so that you can make your application, you should:

• Contact Government Recruitment Service via Charitycommissionrecruitment.grs@cabinetoffice.gov.uk as soon as possible before the closing date to discuss your needs.
• Complete the “Assistance required” section in the “Additional requirements” page of your application form to tell us what changes or help you might need further on in the recruitment process. For instance, you may need wheelchair access at an interview, or if you’re deaf, a Language Service Professional.

Reserve Lists

If we have more successful candidates than available vacancies, we will hold a 12-month reserve list as standard.

During that time, we may use the list to fill the same, or similar roles with closely matching essential criteria, without further testing of merit. Any appointments from the Reserve list will be made in strict merit order.

Applying

We recognise everyone as an individual, accepting people for who they are and treating everyone fairly.

All applications for these vacancies must be made online. There are limited exceptions to this. Paper applications will only be considered if you have a disability that will prevent you from applying online. If this is the case, please email Charitycommissionrecruitment.grs@cabinetoffice.gov.uk

Once you have submitted your application it cannot be amended; only submit your application when you have completely finished and answered all the relevant questions.

Please note that late applications will not be accepted.

If you are experiencing accessibility problems with any attachments on this advert, please contact the email address in the 'Contact point for applicants' section.

New entrants are expected to join on the minimum of the pay band.

Concerns/Complaints

The Charity Commission’s recruitment processes are underpinned by the Civil Service Commissioner’s Recruitment Principles, which outlines that selection for appointment is made on merit based on fair and open competition.

If you feel your application has not been treated in accordance with the values in the Civil Service Code and/or if you feel the recruitment has been conducted in such a way that conflicts with the Civil Service Commissioner’s Recruitment Principles, and wish to make a complaint, then you should contact in the first instance hrselfservice@charitycommission.gov.uk.

 If you are not satisfied with the response that you receive, then you can contact the Civil Service Commission. For further information on bringing a complaint to the Civil Service Commission please visit their web page here.

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. The Civil Service also offers a Redeployment Interview Scheme to civil servants who are at risk of redundancy, and who meet the minimum requirements for the advertised vacancy.