SMMT News Uncategorised

Assistant Database Analyst

05 March 2015 #SMMT News #Uncategorised

Purpose of the Post:

  • To carry out Microsoft SQL Server database processing, reporting and administration for automotive databases, including “Motorparc” (vehicles in use), “Anonymised” (new, used and vehicles in use) and MOT data.
  • To create and run reports for customers and stakeholders.
  • To carry out linking of SMMT data to other data sets, including DVLA model codes and insurance group rating (Thatcham / code44).
  • To build and maintain knowledge of the underlying data and processes.
  • To develop an understanding of the business requirements behind the databases and reports.
  • To develop new reporting services and help generate additional income.
  • To help improve SMMT data processes and efficiency through technical innovation.
  • To help identify and meet future requirements for automotive data by keeping in touch with other SMMT departments (especially Public Policy and vehicle Legislation) and external organisations and stakeholders.

Please note that the this role requires good technical skills, especially Microsoft SQL Server, but also involves a certain amount of general business administration, as well as helping out with day to day running of the department and company.

Qualifications/Skills/Attributes required:

  • Strong data analysis and processing skills.
  • Proven experience of Microsoft SQL Server.
  • Proficient in the use of Microsoft Office software including MS-Word, MS-Excel, and ideally MS-Access.
  • Strong team player with good customer facing and interpersonal skills.
  • Ability to multi-task and prioritise to meet deadlines.
  • High level of concentration and accuracy. Numerate and literate.
  • Initiative, ability to learn and enthusiasm, self-starter.
  • Aware of the need to maintain the confidentiality of personal data and commercially sensitive information and comply with contractual requirements.

Main duties include:

  • Carry out monthly, quarterly and annual take-on of external data sets.
  • Database administration and housekeeping.
  • To receive and process enquiries and orders for data from customers and other stakeholders and to carry these through to invoicing and order renewal.
  • Carry out weekly vehicle model coding / linking e.g. DVLA codes and insurance group rating (Thatcham / code44).
  • To liaise with the SMMT accounts department on customer invoicing and related financial matters.
  • To help ensure the security and integrity of the databases and compliance with SMMT policies and supplier contract(s).
  • To help develop and improve the database take-on and reporting processes.
  • To evaluate and integrate other information sets into SMMT systems as required.
  • To assist in the day to day running of the department and company.
  • To carry out other duties as directed by the line manager and/or head of department

Salary and benefits package:

The package includes private medical insurance, company pension scheme, flexi time, 25 days annual leave, childcare vouchers, interest free season ticket loan (after six months).

Deadline for Applications:

27 March 2015

Method of Application:

Prospective candidates should e-mail with a CV and covering letter quoting your salary expectations.

Early applications are encouraged as interviews will take place and the position offered before this date if a suitable candidate is found.

Filter News

Update Newsletter