Find More Than 10K+
United Kingdom Jobs

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!

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.

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

• Extensive learning and development tailored to your role
• An environment with flexible, hybrid working options
• A culture encouraging inclusion and diversity
• A Civil Service pension with an average employer contribution of 27%
• Annual leave starting at 25 days per annum plus statutory bank holidays rising to 30 days with service

How to Apply

This vacancy is using Success Profiles, and will assess your Technical Skills and Behaviours.

Unless otherwise specified, all interviews are currently being held online. 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

Reserve list

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.

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.

Further Information

The Department for Business and 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. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria. Click through to apply and find out more.

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.