HMRC - Data Warehouse Manager

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., 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., We'll assess you against these behaviours during the selection process:


• Communicating and Influencing


• Delivering at Pace


• Making Effective Decisions, "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., 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.,
• 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
  
  You will be working in an environment that requires flexibility, so the ability to handle time-sensitive priorities is essential to being successful., 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., 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., 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., 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.

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.

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.

Things you need to know, 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.