HMRC - Data Warehouse Manager

HM Revenue and Customs

Apply before 11:55 pm on Monday 27th May 2024

 

Details

Reference number

352550

Salary

£42,618 - £45,831
A Civil Service Pension with an average employer contribution of 27%

Job grade

Senior Executive Officer

Contract type

Permanent

Business area

HMRC - CPO - People, Analytics and Insight

Type of role

Digital

Working pattern

Flexible working, Full-time, Job share, Part-time

Number of jobs available

1

Contents

Liverpool, Manchester, Newcastle-upon-Tyne, Nottingham

Job summary

Discover a career in your hands at HMRC. Whether you're seeking purpose, growth, or a workplace that gives you a true sense of belonging, hear from some of our employees as they share their story about what it’s really like to work at HMRC.

Visit our YouTube channel to watch the full series and come and discover your potential.

The People Analytics and Insight (PAI) Directorate is part of HMRC’s Chief People Officer (CPO) Group, or HR. The Vision of the Directorate is to be "HMRC’s trusted experts on our colleagues at work, providing insight to unlock the potential of our people and create a thriving and inclusive workplace."

The Data Warehouse Manager role will drive the implementation of an HR data repository and oversee its ongoing development to maximise the benefits to the organisation.

You will be working in an environment that requires flexibility, so the ability to handle time-sensitive priorities is essential to being successful.

Job description

As the data warehouse manager, you will take ownership of the delivery and maintenance of the HR data warehouse and undertake the following duties and responsibilities:

  • Leadership and potentially line management responsibilities, provide oversight and mentoring advice to more inexperienced members of the team.
  • Drive and oversee the delivery of plans to ensure that the objectives are clearly defined and achieved within the agreed time, cost and quality constraints.
  • Stakeholder management: building relationships and communicating effectively with a wide range of stakeholders in HMRC, balancing their priorities against limited resources and budget.
  • Act as the lead point of contact with our IT partners in CDIO.
  • Lead work on database management: monitoring performance; take responsibility for audit trails, access controls and backups; identifying improvements and opportunities to include new, or reuse and optimise existing data flows to reduce load on the warehouse and maximise benefits; undertake data profiling and source system analysis.

Person specification

This role requires an individual who can take the initiative and work with little or no supervision

  • You are comfortable leading a team.
  • You pay attention to details.
  • You are patient, level-headed and calm under pressure.
  • You have a collaborative approach. You are keen to work with others to achieve progress against shared objectives.
  • You can think on your feet and take initiative. Can make decisions when needed and are accountable for your actions and your performance.
  • You can build effective working relationships with a wide range of stakeholders, including senior analytical managers.
  • You have a positive approach to problem solving.

Essential Criteria:

  • Database management and data modelling: produce relevant data models across multiple subject areas. 
  • Communication. You can communicate effectively with technical and non-technical stakeholders, hosting discussions with potentially difficult dynamics.
  • Problem resolution. You can respond to problems in databases, data processes, data products and services as they occur. You can initiate actions, monitor services and identify trends to resolve problems. You can determine the appropriate remedy and assist with its implementation, and with preventative measures.
  • Technical understanding. You can understand the core technical concepts related to the role and apply them with guidance.

Desirable Criteria:

  • Data integration design: implement the appropriate technologies to deliver resilient, scalable and future-proofed data solutions.
  • Testing. You can review requirements and specifications and define test conditions. You can identify issues and risks associated with work. You can analyse and report test activities and results.
  • 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.

Behaviours

We'll assess you against these behaviours during the selection process:

  • Communicating and Influencing
  • Delivering at Pace
  • Making Effective Decisions
Alongside your salary of £42,618, HM Revenue and Customs contributes £11,506 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.

HMRC operates both Flexible and Hybrid Working policies, allowing you to balance your work and personal commitments. We welcome applications from those who need to work a more flexible arrangement and will agree to requests where possible, considering our operational and customer service needs.

We offer a generous leave allowance, starting at 25 days and increasing by a day for every year of qualifying service up to a maximum of 30 days.

  • Pension - We make contributions to our colleagues’ Alpha pension equal to at least 27% of their salary.
  • Family friendly policies.
  • Personal support.
  • Coaching and development.

To find out more about HMRC benefits and find out what it’s really like to work for HMRC hear from our insiders or visit Thinking of joining the Civil Service.

Selection process details

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

How to Apply

As part of the application process, you will be asked to provide the following:

  • A CV including your job history and previous experiences.
  • A 750-word personal statement.
  • a 250 word statement explaining how you meet the desirable criteria. Further details around what this will entail are listed on the application form.

Your CV should cover your job history and will be scored against the roles and responsibilities outlined in the advert.

Your Personal Statement should be used to describe how your skills and experience would be suitable for the advertised role, making reference to the essential criteria and person specification outlined in the advert.

You will also be asked to provide a 250 word statement addressing the desirable criteria, which will not be sifted on, but may be used in the event of a tie-break.

Further details around what this will entail are listed on the application form.

Please take extra care to tick the correct boxes in the eligibility sections of your application form. We understand mistakes sometimes happen but if you contact us later than two working days (Monday-Friday) before the vacancy closes, we will not be able to reopen your application for you. If you do make a mistake, please contact us via: ubsrecruitmentexcellence@hmrc.gov.uk – Use the subject line to insert appropriate wording for example – ‘Please re-open my application – [insert vacancy ref] & vacancy closing date [insert date]’

To check that you are eligible to apply for this role, please review the eligibility information before submitting your application.

Sift

In the event of a large number of applications being received, an initial sift may be held on your Personal Statement. 

If your application progresses to a full sift, all sift criteria will then be considered, with the successful candidates being invited to interview.

We may also raise the score required at any stage of the process if we receive a high number of applications.

Interview

During the panel interview, you will be asked behaviour-based questions to explore in detail what you are capable of, and you will be asked strength-based questions to also explore what you enjoy and your motivations relevant to the job role.

This is an example of a strengths-based question:

“It is often said that the customer's needs should come first. To what extent do you agree or disagree with this statement?”

There is no expectation or requirement for you to prepare for the strengths-based questions in advance of the interview, though you may find it helpful to spend some time reflecting on what you enjoy doing and what you do well.

Interviews will take place via video link. Sift and interview dates to be confirmed.

A reserve list may be held for up to 6 months from which further appointments may be made for the same or similar roles – if this applies to you, we’ll let you know via your Civil Service Jobs account.

After interview, a single merit list will be created, and appointments will be made in strict merit order until the set demand is filled in each location. If successful, you will be informed which locations are available when we reach your position on the merit list.

Applications received from candidates with a criminal record are considered fairly in accordance with the DBS Code of Practice and the Recruitment of ex-offenders Policy.

Reasonable Adjustments

We want to make sure no one is put at a disadvantage during our recruitment process. To assist you with this, we will reduce or remove any barriers where possible and provide additional support where appropriate.

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

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 interview, or if you’re deaf, a Language Service Professional.

Diversity and Inclusion

At HMRC we are committed to creating a great place to work for all our colleagues and creating an inclusive and respectful environment that reflects the diversity of the society we serve.

Diverse perspectives and experiences are critical to our success, and we welcome applications from all people, from all backgrounds, with the experience and skills needed to perform this role.

We’re committed to creating a great place to work for all our colleagues here at HMRC and want everyone to feel valued and supported to achieve their potential.

Click here for more information on how we make this happen.

Additional Security Information

Please note: in addition to the standard pre-employment checks for appointment into the Civil Service, all candidates must also obtain National Security Vetting at Security Check (SC) clearance level for this vacancy. You will normally need to meet the minimum UK residency period as determined by the level of vetting being undertaken, which for SC is 5 years UK residency prior to your vetting application. If you have any questions about this residency requirement, please speak to the vacancy holder for this post.

Important information for existing HMRC contractual homeworkers:

Please note that this role is unsuitable for contractual homeworkers due to the nature and/or requirements of the role.

Terms and Conditions

Customer facing roles in HMRC require the ability to converse at ease with members of the public and provide advice in accurate spoken English and/or Welsh where required. Where this is an essential requirement, this will be tested as part of the selection process.

HMRC has a presence in every region of the UK. For more information on where you might be working, review this information on our locations.

The Civil Service values honesty and integrity and expects all candidates to abide by these principles. The evidence you provide in your application must relate to your own experiences.

Any instances of plagiarism or other forms of cheating will be investigated and, if proven, the relevant application(s) will be withdrawn from the process. 

Recording of interviews is prohibited unless explicit agreement is sought in line with the UK General Data Protection Regulations.

Questions relating to an individual application must be emailed as detailed later in this advert.

Applicants who are successful at interview will be, as part of pre-employment screening, subject to a check on the Internal Fraud Database (IFD). This check will provide information about employees who have been dismissed for fraud or dishonesty offences. This check also applies to employees who resign or otherwise leave before being dismissed for fraud or dishonesty had their employment continued. Any applicant’s details held on the IFD will be refused employment. 

A candidate is not eligible to apply for a role within the Civil Service if the application is made within a 5 year period following a dismissal for carrying out internal fraud against government.

New entrants will join on the minimum of the pay band.

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



Feedback will only be provided if you attend an interview or assessment.

Security

Successful candidates must undergo a criminal record check.
Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check (opens in a new window).

See our vetting charter (opens in a new window).
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.

Diversity and Inclusion

The Civil Service is committed to attract, retain and invest in talent wherever it is found. To learn more please see the Civil Service People Plan (opens in a new window) and the Civil Service Diversity and Inclusion Strategy (opens in a new window).
This vacancy is part of the Great Place to Work for Veterans (opens in a new window) initiative.
Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.

Contact point for applicants

Job contact :

  • Name : Godfrey Morgan
  • Email : godfrey.morgan@hmrc.gov.uk
  • Telephone : 07385395288

Recruitment team

  • Email : ubsrecruitmentexcellence@hmrc.gov.uk

Further information

Appointment to the Civil Service is governed by the Civil Service Commission’s Recruitment Principles. You have the right to complain if you feel there has been a breach of the Recruitment Principles.
In the first instance, you should raise the matter directly via ubsrecruitmentcomplaints@hmrc.gov.uk. If you are not satisfied with the response, you may bring your complaint to the Commission. For further information on bringing a complaint to the Civil Service Commission please visit their website.

Share this page