Negotiable
Inside
Hybrid
City Of Bristol, England, United Kingdom
Summary: The role of Data Analyst at the Vehicle Certification Agency involves obtaining and analyzing data related to heavy-duty vehicle (HDV) registrations in the UK. The position requires coordination with manufacturers to calculate fleet average CO2 emissions and ensure data accuracy while maintaining compliance with relevant regulations. The role is hybrid, requiring three days of on-site work in Bristol, and is classified as inside IR35 for a three-month contract.
Key Responsibilities:
- Obtain data files from the Department for Transport (DfT) relating to HDV registrations in the UK.
- Coordinate the collection of data from HDV manufacturers to enable the calculation of HDV fleet average CO2.
- Ensure data files are reviewed, checked for deficiencies or obvious errors, corrected, and accurately entered in the relevant database.
- Engage with industry to verify and align understanding of their dataset.
- Use tools such as Power Query in Excel to calculate the correct fleet average emissions for each manufacturer.
- Build and maintain excellent working relationships with manufacturers to promote regulatory compliance, build knowledge, expertise, and ensure accuracy of metrics.
- Calculate provisional fleet average CO2 performance targets for all LDV manufacturers using registration data.
- Provide LDV manufacturers with data sets and their provisional fleet average CO2 performance targets.
- Coordinate the collection of data returned from LDV manufacturers via the error reporting process.
- Engage with manufacturers to collect vehicle Certificates of Conformity (CoCs) to verify and agree changes made.
- Calculate final fleet average CO2 performance targets for all manufacturers.
- Provide manufacturers with data sets and their final performance targets.
- Support the publication of emissions data such as reports and associated supporting documents on the VCA website for both LDV and HDV vehicles.
- Provide responses to communications and queries from stakeholders, manufacturers, and the public.
- Build and maintain excellent working relationships with key colleagues in the central department to share resources, knowledge, and expertise to promote regulatory compliance and continuous improvement.
- Maintain data standards, including adherence to the Data Protection Act 2018 and UK General Data Protection Regulation (GDPR).
- Undertake all other reasonable and related tasks associated with this role.
Key Skills:
- Excellent communication skills both verbally and in writing with both internal and external stakeholders alike using a high level of tact and diplomacy.
- Experience in using Microsoft Excel for data analysis, including pivot tables, advanced formulas, and data transformation tools such as Power Query.
- Experience problem solving, with confidence to challenge and investigate errors in data and published reports.
- Good analytical skills to be able to produce recommendations based on evidential conclusions.
- Ability to deliver at pace and experience managing competing priorities.
- Adherence to relevant policies, procedures, and legislation to complete work.
Salary (Rate): undetermined
City: City Of Bristol
Country: United Kingdom
Working Arrangements: hybrid
IR35 Status: inside IR35
Seniority Level: undetermined
Industry: Other
On behalf of The Department for Transport- Vehicle Certification Agency we are looking for a Data Analyst (Inside IR35) for a 3 Month contract. Hybrid working with 3 days per week in Bristol. VCA’s work is focused on improving vehicle safety and environmental protection by providing robust testing and certification to national and internationally recognised standards. VCA are a part of the Department of Transport as the designated UK Vehicle Type Approval Authority. As a Data Analyst your main responsibilities will be to:
- Obtain data files from the Department for Transport (DfT) relating to HDV registrations in the UK.
- Coordinate the collection of data from HDV manufacturers to enable the calculation of HDV fleet average CO2.
- Ensure data files are reviewed, checked for deficiencies or obvious errors, corrected, and accurately entered in the relevant database.
- Engage with industry to verify and align understanding of their dataset.
- Use tools such as Power Query in excel to calculate the correct fleet average emissions for each manufacturer.
- Build and maintain excellent working relationships with manufacturers, to promote regulatory compliance, build knowledge, expertise and ensure accuracy of metrics.
- Calculate provisional fleet average CO2 performance targets for all LDV manufacturers using registration data.
- Provide LDV manufactures with data sets and their provisional fleet average CO2 performance targets.
- Coordinate the collection of data returned from LDV manufacturers via the error reporting process.
- Engage with manufacturers to collect vehicle Certificates of Conformity (CoCs) to verify and agree changes made.
- Calculate final fleet average CO2 performance targets for all manufacturers.
- Provide manufacturers with data sets and their final performance targets.
- Support the publication of emissions data such as reports and associated supporting documents on the VCA website for both LDV and HDV vehicles.
- Provide responses to communications and queries from stakeholders, manufacturers, and the public.
- Build and maintain excellent working relationships with key colleagues in the central department, to share resources, knowledge, and expertise to promote regulatory compliance and continuous improvement.
- Maintain data standards, including adherence to the Data Protection Act 2018 and UK General Data Protection Regulation (GDPR) Undertake all other reasonable and related tasks associated with this role.
Essential:
- Excellent communication skills both verbally and in-writing with both internal and external stakeholders alike using a high level of tact and diplomacy.
- Experience in using Microsoft Excel for data analysis, including pivot tables, advanced formulas, and data transformation tools such as Power Query.
- Experience problem solving, with confidence to challenge and investigate errors in data and published reports.
- Good analytical skills to be able to produce recommendations based on evidential conclusions.
- You have the ability to deliver at pace and experience managing competing priorities.
- You adhere to relevant policies, procedures, and legislation to complete your work.
Please be aware that this role can only be worked within the UK and not Overseas.
Disability Confident As a member of the Disability Confident Scheme, DfT guarantees to interview all candidates who have a disability and who meet all the essential criteria for the vacancy. In cases where we have a high volume of candidates who have a disability who meet all the essential criteria, we will interview the best candidates from within that group. This scheme encourages candidates with a disability and/or neurodivergence to apply. In exceptional circumstances, we may also need to apply the desirable criteria in our shortlisting process which may include holding active security clearance.
In applying for this role, you acknowledge the following "this role falls in scope of the Off Payroll Working in the Public Sector legislation. Any rates of payment quoted will reflect the gross rate per day for the assignment and will be subject to appropriate taxes and statutory costs. As such the payment to the intermediary and your income resulting from this contract will be different".