Data Analyst London, England
Job description
Details
Reference number
Salary
Job grade
Contract type
Business area
Type of role
Analytical
Information Technology
Other
Working pattern
Number of jobs available
Contents
Location
About the job
Benefits
Things you need to know
Apply and further information
Location
About the job
Job summary
This recruitment is continuing as usual, but candidates should be aware that following the Government’s announcement on the changes to some civil service departments, roles will be located in the new Department for Business and Trade. We will provide more information if you are selected for a role. This work remains of high importance to the civil service, and we thank you for your continued interest.
The newly created Department for Business and Trade brings together the business focused functions of the former Department for Business, Energy and Industrial Strategy (BEIS) and the Department for International Trade (DIT). Our joint expertise in trade and business provides us with a unique opportunity to unleash the power of UK businesses, reform regulation to reduce burdens and unlock post-Brexit freedoms.
Job Description
As Data Analyst you will use high quality datasets held inside and outside DBT (Department for Business and Trade) including data and management information, commercial and business data. The department has a relationship with international datasets from Org. for Economic Cooperation and Development, World Bank and UN Comtrade; statistical microdata and large datasets from the Office of National Statistics and Her Majesty’s Revenue and Customs. You will analyse and facilitate the analysis of these datasets, working independently on projects to help DBT get insight from them.
Join our Data Infrastructure team as a Data Analyst and help us transform DBT into an insight-driven organisation that tells compelling stories with its data. You will be based alongside the multidisciplinary team responsible for developing our ground-breaking data and insight platform, Data Workspace. The service gives our staff access to a catalogue of key trade data and a suite of powerful tools with which to analyse and explore it.
This role is available in three UK locations, including central London, Cardiff, and Darlington’s new economic hub. This role can only be worked from within the UK and not overseas. Most DBT employees will be working a hybrid pattern, spending 2-3 days a week (pro rata) in the office on average. Changes to these working arrangements are available in certain circumstances but must be agreed with the vacancy manager and in line with the requirements of the role. Travel to your primary office location will not be paid for by DBT, but costs for travel to an office which is not your main location will be covered.
Find out about life at DBT, our benefits and meet the team by watching our recruitment video, visiting our website or reading our blog!
Job description
Responsibilities
You will be an experienced Data analyst who can:
- Work in an Agile team and work independently to deliver data analysis projects. During projects, collaborate with colleagues across the business to understand the data insights that would add the most value in their area and work out the best way to meet those needs.
- Apply tools and techniques for data analysis and data visualisation, working across a broad range of areas such as business intelligence, data assurance and quality.
- Produce compelling analysis and visualisation of data (e.g., dashboards) to provide actionable insights to technical, policy and operational colleagues.
- Develop a deep understanding of the systems we use to organise and store data, identifying and assessing new data sources, and investigating and resolving problems as they occur. Use these to manage and maintain data, ensuring it aligns to DBT’s data standards, is protected, and used in line with established governance.
- Have enthusiasm for helping colleagues to get the maximum value from data. To enable this, you will take a proactive approach to developing your skills and sharing them with others. As part of this you will design and facilitate training for other across the department in the usage of our data analysis tools.
Person specification
Essential Skills and Experience
You will need to have demonstrable skills and experience of:
- Data visualisation: you should understand how to tell compelling and actionable stories that are relevant to business goals. This will include experience with a dashboarding/BI tool (for example Tableau, Power BI, AWS QuickSight, Google Data Studio, or others).
- Good communication skills, to communicate accurate information to technical and non-technical stakeholders.
- Using SQL (Structured query language) to bring data together from different sources and get them ready for analysis using cleaning and preparation techniques.
Desirable Skills and Experience
These are not necessary but would be ideal if you had:
- Experience using another computer programming language (e.g., Python or R) to bring data together from different sources and get them ready for analysis using cleaning and preparation techniques.
- Knowledge of project management techniques, particularly using Agile techniques, to manage projects independently.
Personal Attributes and Skills
The ideal candidate will have a passion for solving real-world problems using data and enjoy working in a multi-disciplinary team to deliver results. They will be an effective analyst and a great communicator.
Benefits
- Learning and development tailored to your role
- An environment with flexible working options
- A culture encouraging inclusion and diversity
- A Civil Service pension with an average employer contribution of 27%
Things you need to know
Selection process details
This vacancy is using Success Profiles, and will assess your Technical Skills and Behaviours.
Interviews for this vacancy will be conducted virtually. We will, however, consider in-person interviews by exception.
Please ensure that you check your emails regularly as all updates from us will be sent to you this way.
Sift will take place week commencing: Monday 5th June 2023
Interviews will take place week commencing: Monday 19th June 2023
Please notes these dates are indicative and may be subject to change.
As part of the application process you will be asked to upload a CV and complete a personal statement outlining your experience, skills and fit for the role.
At the sift stage for this role, we will assess your CV and personal statement against the essential skills and experience listed above. There is no limit on the personal statement, but we recommend writing around 750 words. You can use bullet points and subheadings if you prefer. As well as evidencing the criteria you should also touch upon why you're interested in DBT and in this role.
If we receive a high volume of applications, we will conduct a ‘short sift’ and read one element of your application. For this campaign a short sift would be conducted based on: Personal Statement only.
How you’ll be assessed
At the interview stage for this role, you will be asked to demonstrate relevant technical skills and behaviours from the Success Profiles framework. A role-specific list of these can be found below.
The salary we will offer is determined using interview performance. Scores at interview translate to proficiency levels and an associated salary. Once a successful candidate has a proficiency level and is part of the capability framework, they will be given opportunities to self-assess to progress through the pay scale within their grade during their time at DBT. For further explanation of proficiency levels and more information about DDaT click here. Candidates moving from another government department have the option to retain their current salary.
As part of the ‘Proven IT and mathematical skills’ capability, we will be assessing your SQL knowledge in the interview. This will not be specific to any one tool/database, and you will not be required to do any work outside of the interview related to this.
Technical skills
There will be a technical element within the interview where you will be asked questions about your specific professional skills and knowledge relating directly to the job role.
We will assess you against the following technical skills:
- Analytical and problem-solving skills.
- Communication skills
- Data management
- Data modelling, data cleansing, and data enrichment skills
- Data visualisation
- DDaT standards outside your discipline
- Logical and creative thinking skills
- Project management skills
- Proven IT and mathematical skills
- Quality assurance, validation, and data linkage abilities
- Statistical methods and data analysis skills
Detailed explanations of each technical skill can be found on the DDaT Framework.
Behaviours
We will assess you against the following behaviours:
- Communicating and Influencing
- Managing a Quality Service
- Seeing the Big Picture
- Changing and Improving
Further Information
Appointments may be made to candidates in merit order based on location preferences. Candidates who pass the bar at interview but are not the highest scoring will be held on a 12-month reserve list for future appointments. Candidates who are judged to be a near miss at interview may be offered a post at the grade below the one advertised.
If successful and transferring from another Government Department a criminal record check may be carried out.
The Department for International Trade embraces and values diversity in all forms. We welcome and pride ourselves on the positive impact diversity has on the work we do, and we promote equality of opportunity throughout the organisation.
Harmonised terms and conditions are attached. Please take time to read the document to determine how these may affect you.
Please note – the successful candidate will be expected to remain in post for a minimum of 18 months before being released for another role.
Any move to the Department for International Trade from another employer will mean you can no longer access childcare vouchers. This includes moves between government departments. You may however be eligible for other government schemes, including Tax Free Childcare. Determine your eligibility at https://www.childcarechoices.gov.uk
New entrants are expected to join on the minimum of the pay band.
Reasonable adjustment
If a person with disabilities is put at a substantial disadvantage compared to a non-disabled person, 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 the DDaT Recruitment team before the closing date to discuss your needs.
Our recruitment process is underpinned by appointment on the basis of fair and open competition and appointment on merit, as outlined in the Civil Service Commission's Recruitment Principles.
The Civil Service Code sets out the standards of behaviour expected of civil servants. If you feel your application has not been treated in accordance with these principles and you wish to make a complaint, you should in the first instance contact DBT by email: [email protected].
If you are not satisfied with the response you receive, you can contact the Civil Service Commission, which regulates all Civil Service recruitment. Click here to download a PDF about the Civil Service Commission/Complaints.
If you are experiencing accessibility problems with any attachments on this advert, please contact the email address in the 'Contact point for applicants' section.
For further information and to apply please click the link to direct you to the advertisers website.
Security Clearance Details
This role requires you to undergo Security Clearance. The requirement for SC clearance is to have been present in the UK for at least 3 of the last 5 years. You will be asked to provide evidence of your UK footprint where you have been physically present in the UK. Failure to meet the residency requirements will result in your security clearance application being rejected.
If you require SC clearance you will need to provide evidence of the below requirements.
Checks will be made against:
- Departmental or company records (personnel files, staff reports, sick leave reports and security records).
- UK criminal records covering both spent and unspent criminal records.
- Your credit and financial history with a credit reference agency.
- Security Services record.
- Location details.
Feedback will only be provided if you attend an interview or assessment.
Security
See our vetting charter (opens in a new window).
Nationality requirements
This job is broadly open to the following groups:
- UK nationals
- nationals of Commonwealth countries who have the right to work in the UK
- nationals of the Republic of Ireland
- nationals from the EU, EEA or Switzerland with settled or pre-settled status or who apply for either status by the deadline of the European Union Settlement Scheme (EUSS) (opens in a new window)
- relevant EU, EEA, Swiss or Turkish nationals working in the Civil Service
- relevant EU, EEA, Swiss or Turkish nationals who have built up the right to work in the Civil Service
- certain family members of the relevant EU, EEA, Swiss or Turkish nationals
Working for the Civil Service
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).
Apply and further information
Contact point for applicants
Job contact :
Recruitment team
Further information
