Data Analysis Lead - Flexible Working Available

London (Central), London (Greater)
16 Nov 2020
26 Nov 2020
Full Time
Contract Type


Birmingham, Leeds, London, Swansea

About the job

We recognise the challenges that people with (multiple) protected characteristics may experience on the job market and in their career progression. We are fully committed to being an inclusive employer and ensuring equal opportunities. We are keen to make our workforce as diverse as possible, and we hope to attract applications from underrepresented groups, including Black, Asian and Minority Ethnic (BAME) people, people with a disability, and people with gender diverse identities.

Do you have an interest in working with BI software such as Microsoft PowerBI?

Can you support on the management and configuration of our Salesforce CRM?

Are you looking for a chance to develop and expand your skillset?

If so, we would love to hear from you!

Job description

As the Data Analysis Lead, you’ll lead on the delivery and continual improvement of business as usual reporting for the Department for Transport Resourcing Group (DRG) and the different business units in the Department for Transport (DfT) family.

The DRG is continuously striving to improve the resourcing service by making processes more efficient and inclusive. As part of this, we need our decision to be supported by the best evidence and advice. In this role you will deliver deep analysis and insight into resourcing data, providing high quality analysis and research which is robust, proportionate and appropriate for the decision at hand.

You’ll take the lead in maintaining and improving our existing reporting and MI offering, as well as support on the management and ongoing configuration of our Salesforce CRM, which is being used a workflow orchestration tool. You’ll ensure reporting is robust and readily available for ad-hoc requests and to drive decision making in long-term activities such as business planning, forecasting and strategic workforce development.


You will be responsible for the conception, development and implementation of HR MI & system change initiatives within DRG supporting strategies across Group HR Operations.

You will be reporting to the Projects, Data & Governance Manager and DRG Resourcing team and have the chance to create positive working relationships across the Department for Transport. You will be a lead decision maker in our Data service and technical process, making recommendations for innovations and enhancements, whilst encouraging and offering development and support to your team.

You will:

• deliver business as usual reporting, working to innovate and continuously improve reporting to reflect resourcing strategy and highlight key performance areas suitable for varied audiences
• provide deep analysis and insight into all resourcing data, providing high quality analysis and research
• provide narrative and communicate the story that the data is evidencing, making recommendations when appropriate.
• build strong and trusted relationships with GRS MI Team to create accurate and timely reporting.
• maintain, manage and improve existing automation and reporting packages within DRG; including but not limited to contract generation, recruitment tracking, merit list and redeployment
• find new ways to automate data collection or reporting, freeing up time for HR MI roles to focus on analysis and innovation
• implement digital solutions to enable easier ways of working and reducing the burden of administrative elements to tracking and reporting
• develop an engagement and capability strategy for building confidence and skills in the MI PowerBI self-serve function and the CRM
• ensure robust availability of appropriate data for external obligations (i.e. Treat Official, Ministerial Correspondence, Freedom of Information Requests, Parliamentary Questions)
• develop strategies for incorporation of recruitment data into larger HR reporting space
• support the growth of the Power BI platform within HR and ensure data is fit for purpose and can be aligned to other systems data
• responsible for the development of new methods of interactive reporting to support team delivery.
• manage ad-hoc insight and analysis of data, develop and automate dashboards and drive forward data driven decision making with the availability of reliable, intuitive and inclusive reporting
• take responsibility for DRG’s MI & Change team activity and develop MI/CRS capability within DRG.
• gather requirements and suggest and develop ad-hoc outputs to support colleague’s activity, with both one-off and periodic insight which accounts for the broad availability of data
• take responsibility for the effective delivery of DRG’s service and priorities, living the Civil Service values, leading DRG with confidence, inspiring, engaging and empowering their team to deliver an excellent quality service

Please note that once normal working arrangements resume the successful candidate, if not based in Swansea, will be required to travel regularly to the Swansea office.

About you -

We are seeking an enthusiastic individual with strong inter-personal skills, innovative thinking and talent for analysing data and telling the story behind the data, getting people on board with new ideas.

Essential skills -
• experience working with Power BI.
• basic knowledge or experience of working with or on a CRM system
• google Analytics
• advanced knowledge of complex Excel formulas and macros
• visual Basic for Applications (VBA) coding
• a broad understanding of Microsoft Access & database building & query design with SQL

As part of a flexible, supportive team you will have the opportunity to work strategically with a wide range of stakeholders at all levels to make a real impact on Departmental Resourcing strategies.

DfT has a strong culture of learning and development. In addition to data analysis, this role has elements of project delivery, contract management, governance, stakeholder engagement and development of innovative data solutions and can be shaped towards the successful post-holder’s career goals. The previous post holder left on promotion.


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

  • Seeing the Big Picture
  • Changing and Improving
  • Making Effective Decisions
  • Communicating and Influencing
  • Managing a Quality Service

Technical skills

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


Being part of our brilliant Civil Service means you will have access to a wide range of fantastic benefits. We offer generous annual leave, attractive pension options, flexible working, inclusive working environments and much more to support a healthy work/life balance.

Find out more about what it's like working at the Department for Transport.

Things you need to know Security

Successful candidates must pass a disclosure and barring security check.

People working with government assets must complete basic personnel security standard checks.

Selection process details

This vacancy is using Success Profiles, and will assess your Behaviours, Strengths, Experience and Technical skills.

We are closely monitoring the situation regarding the coronavirus, and will be following central Government advice as it is issued. There is therefore a risk that recruitment to this post may be subject to change at short notice. In addition, where appropriate, you may be invited to attend a video interview.

Please continue to follow the application process as normal and ensure that you check your emails regularly as all updates from us will be sent to you this way.

The sift is due to take place week commencing 30th November 2020.

Interviews/assessments are likely to be held week commencing 7th December 2020.

This interview could be conducted via a video interview, details of which will be provided to you should you be selected for interview.

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

How to apply

When considering applying please look at how your experience relates to the role. Please tailor your CV to reflect the essential skills/ criteria described in the Role Profile.

You will also be required to write 250 words for each technical element listed on the bottom of the Role Profile.

The selection process will be designed specifically for the role. As a result, your assessment could include:

• an interview and one or more exercises

You’re encouraged to become familiar with the role profile, as you may be assessed against any of the criteria recorded within.

The Department for Transport alongside other Government Departments recruit using Success Profiles. This means for each role we consider what you will need to demonstrate in order to be successful. This gives us the best possible chance of finding the right person for the job, drives up performance and improves diversity and inclusivity.

For further information on Success Profiles visit our Careers website.

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

Further information

To learn more about applying for a role within the Department for Transport, visit the Application Process page of our Careers website.

Before submitting your application, we encourage you to visit our Things You Need to Know page for further information about applying for a role within the Department for Transport and the Civil Service.

Throughout this job advert there are links to the DfT Careers website, which provides you further information to support your application. Should you be unable to access the information on our website, please email [email protected] for assistance.

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

Nationality requirements

Open to UK, Commonwealth and European Economic Area (EEA) and certain non EEA nationals. Further information on whether you are able to apply is available here.

Working for the Civil Service

The Civil Service Code 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.

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.

Apply and further information

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 :   David Flynn Email :   [email protected]   Recruitment team : Email :   [email protected] Further information

If you feel your application has not been treated in accordance with the Recruitment Principles and you wish to make a complaint, in the first instance, you should contact Government Recruitment Services via email: [email protected] If you are not satisfied with the response you receive from the Department, you can contact the Civil Service Commission: Click here ( to visit Civil Service Commission

Similar jobs

Similar jobs