HM Treasury

Senior Reporting and Data Analyst

Job description

Reference number

168827

Salary

£49,500 - £57,000
National: £49,500 - £54,000/ London £52,500 - £57,000. If the successful candidate is a current Civil Servant joining on level transfer, HM Treasury will honour their current substantive salary if higher.

Grade

Grade 7
Range E

Contract type

Permanent

Business area

HMT - Public Spending

Type of role

Architecture and Data
Digital
Information Technology

Working pattern

Flexible working, Full-time, Part-time

Number of posts

1

Location

The post will be based in London (1 Horse Guards Road) or Darlington (our interim office is Bishopsgate House until the temporary office in central Darlington is established in 2022). All staff follow government guidance about working from home during the pandemic. Once Covid-19 restrictions ease, most Treasury employees will be working a hybrid pattern, spending 2-3 days a week (pro rata) in an office, on average.

About the job

Summary

About HM Treasury:

The Treasury is the United Kingdom’s economics and finance ministry. It is responsible for formulating and implementing the government’s financial and economic policy. Its aim is to raise the rate of sustainable growth, and achieve rising prosperity and a better quality of life with economic and employment opportunities for all.

Job description

Public Spending Group

The Public Spending Group has a high-profile role in Government, setting the Government’s overall spending plans and ensuring they deliver value for money for the taxpayer. We are responsible for reporting to Parliament and the public on how taxpayers’ money is spent. We drive forward improved outcomes and efficiency in public services and enhance the value for money of decision-making through better evaluation, data and analysis.

We advise on overall government policy on public sector pay and pensions, the biggest single driver of public spending. We collaborate with and directly support departments to deliver the Government Finance Function strategy, building finance capability across government and developing the management information, tools and frameworks to better understand and ensure value for money.

The Finance Analytics Control and Technology (FACT) team forms part of HM Treasury’s Public Spending Group. The team provides a range of financial reporting, analytics, data management, training, business analysis and service improvement services. To enable these services the FACT team manages and supports the Online System for Central Accounting and Reporting (OSCAR).

OSCAR is an IBM Cognos based, cross-government system which contains a detailed, multi-year analysis of departmental spending and from which the Whole of Government Accounts (WGA), Supply Estimates and other key outputs are produced. OSCAR’s main objectives are to:
  • Be the single source for reliable, real time financial information for government
  • Increase our analytics and insight capability to support decision making
  • Enable the modernisation and standardisation of financial accounting and reporting
  • Reduce the time taken to produce statutory publications
  • Be capable of future exploitation and expansion (e.g. to new datasets).

Key Accountabilities for this role include:
1. Leading on the development, maintenance and population of TM1 mapping cubes which are required for successful execution of critical specialised reports.
2. Designing, developing and delivering ad-hoc and recurrent reporting to significantly improve the financial and management information obtained from OSCAR to better inform decision making. This includes the analysing and prototyping of potential new reports and/or datasets into the OSCAR II service in an agile manner using the Power BI tool.
3. Leading on the identification and documentation of Business Data Relationships and validation packages.
4. Acting as intermediary between HM Treasury and supplier on technical matters relating to OSCAR, to fill knowledge gaps and ensuring the best solutions are agreed.
5. Delivering required project outcomes through the effective use of project management skills and techniques. Including:
  • Identifying project risks and mitigating actions.
  • Delivering expected outcomes on time and to standard.
6. Ensuring the secure and careful use of all government and public data and information within their area of activity.
7. Building and maintaining positive relationships with a range of partners, including colleagues across HM Treasury, the Civil Service and public sector and with organisations from the private sector.
8. Support the Head of Reporting and Analytics in building the skills and impact of the branch across HMT’s spending functions, fiscal units and Whitehall finance departments. Deputising for the Head of Service Improvement as the need arises in running the branch.

Responsibilities

The below criteria will be assessed in your application form.

The lead criterion is:

1. Understanding of one or more business intelligence (BI) technologies, with an up-to-date knowledge of BI trends, issues and relevant good practice. Experience in IBM Cognos Analytics and Microsoft Power BI is essential, preferably within a financial reporting context. (Experience)

We will assess the below further criteria in your application form;

2. An ability to deal with technical audiences and non-technical, finance and non-finance; being visible to, engaging with and building trust with stakeholders at all levels. (Communicating and Influencing).
3. Have successfully delivered data model change and transformation to improve services provided. (Changing and Improving).
4. Strong ability to deliver outcomes to time and quality, while handling conflicting priorities of data users and the business. (Delivering at Pace)

Candidate Guidance on Completing your Application Form

Where will we assess success profiles across your application form.
Behaviours – these will be assessed individually with a 250-word statement per behaviour. The application form will indicate which behaviour is being assessed each time you provide a statement, and we are ideally looking for an example using the below STAR method to demonstrate this behaviour
Experience – this will be assessed individually with a 250-word statement per experience criteria. You will give the answer in the personal statement section under “statement of suitability” using the below STAR method, and be given direct guidance at this stage on the experience we are looking for you to demonstrate

All elements of the success profiles will be linked to a defined criterion that demonstrates the behaviour, experience or technical skills. It is beneficial to ensure your answer focuses on the full criteria, and not just the related success profile, to give you the best chance or providing the evidence the panel wants to assess

In your statements, it is best to focus on one example in each section to allow you to provide enough detail in your answer and use all the words you have been allocated. Examples from a range of roles across your application will demonstrate that you have the skills, experience and behaviours we are looking for. We would also advise you to use examples that best meet the criteria, even if it is a few years old

How to Structure your Answer

Please use the STAR (Situation, Task, Action, Result) approach when writing your application answers.
Situation – Describe the situation you found yourself in and what happened.
Task – The Hiring Manager will want to understand what you tried to achieve from the situation that you found yourself in.
Action – What actions did you take and how did you do it. Make sure to use “I”, not “we” to explain how your actions lead to a result.
Result – Use facts and statistics to demonstrate the results that your actions produced. Explain whether it was a successful outcome, and if not, what you learned from the experience.

NOTES TO CANDIDATES

Please refer to the candidate FAQ document which is a link on the job advert – this will provide you with guidance on completing the application form. Please contact hrrecruitment@hmtreasury.gov.uk if you have any issue accessing this document
At HM Treasury, to maximise diversity and inclusion within our workforce, we operate a fair, open and anonymous recruitment process. This means that the sift panel will only be able to assess you on the written evidence supplied in your application answers. They will not have access to personal information.
You will be assessed on your skills, experience and behaviours through the online application form When completing your application form, please outline how you meet the requirements as detailed in the ‘candidate assessment of skills and experience ‘section of this job description. This will give you the best chance to provide the evidence that the panel wants to assess. More guidance can be found here – completing you application
If we receive a large number of applications, applications will be assessed initially against the lead criterion alone. You will then be assessed against the other criteria if you have met the minimum score on the first criterion.
Find out more about how the Civil Service assesses candidates and uses Success Profiles (opens in a new window) to test skills, experience and behaviours in applications and interviews.
Applications are not reviewed until the closing date has passed. You will be notified of the outcome of your application as soon as the recruitment panel has reviewed all the applications.

Recruitment Timeline
Closing Date 12th December 2021
Shortlisting application forms 13th December 2021
Interviews 20th December 2021

If you would like to speak to the hiring manager informally prior to the closing date for applications to find out more about the job, please contact Rajpreet Bhuller rajpreet.bhuller@hmtreasury.gov.uk

Behaviours

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

  • Communicating and Influencing
  • Changing and Improving
  • Delivering at Pace

Benefits

Flexible working arrangements:

HM Treasury views flexible working as essential in enabling us to recruit and retain talented people, ensuring that they are able to enjoy a long-lasting career with us. All employees have the right to apply for flexible working and there are a range of options available including; working from home, compressed hours and job sharing. Additionally, we operate flexitime systems, allowing employees to take up to an additional 2 days off each month, providing you work enough hours to meet business need.

We also offer a generous maternity/ paternity and adoption leave package.

At HM Treasury we have an incredibly broad remit; our work touches every citizen of the country. So, it’s important our employees come from the widest possible range of backgrounds, bringing us the widest possible range of perspectives and ways of thinking. We are committed to ensuring that all staff are able to realise their potential and achieve a healthy work-life balance.

Benefits:

  • 25 days’ annual leave (rising to 30 after 5 years), plus 8 public holidays and the Queen’s birthday (unless you have a legacy arrangement as an existing Civil Servant)
  • Flexible working patterns (part-time, job-share, condensed hours)
  • A Civil Service Pension which provides an attractive pension, benefits for dependants and average employer contributions of 27%
  • Onsite restaurant and coffee bar. The London office also offers a gym, showers and prayer room
  • Access to a cycle-to-work salary sacrifice scheme, season ticket advances and payroll giving
  • Access to a retail discounts and cashback site
  • A Rental Deposit Advance Scheme to help meet the total costs of deposits for privately rented homes
  • A range of active staff networks, based around interests (e.g. analysts, music society, sports and social club) and diversity (e.g. women in the Treasury, ethnic minority network, LGBT* network, faith and belief network)

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.