12345678910arrow-rightarrow-right-square-20246Em020406010012080140-20246y(m)x(m)020406010012080140
Elements Of The System 2

ERP Data Administrator

Location: AB Dynamics, Bradford on Avon UK

We are looking for an experienced Data Administrator, with experience in an engineering/manufacturing environment, working with ERP systems. Graduates with the required excel skills with an engineering/software/business degree will be considered.

ABOUT AB DYNAMICS

AB Dynamics is one of the world’s leading specialists in automotive test systems, supplying a range of advanced solutions including driving robots, ADAS soft crash targets and driving simulators to all major vehicle manufacturers and Tier 1 suppliers globally. The company's unique technology is used for many applications including the development of autonomous vehicles

ABOUT THE ROLE

The Data Administrator role will primarily focus on the collation of high volumes of financial, employee, customer, supplier and engineering data from multiple sources and systems accurately and effectively.  As part of our ERP project team you will be responsible for delivering a range of data migration activities related to the global roll out of a new IFS ERP solution.

Responsibilities

  • Planning and coordination of a multi-disciplined solution across multiple companies, in particular:
  • Co-ordinate the collection of data from across all ERP related business functions
  • Act as the initial point of contact and coordinator for data related queries
  • Collate data from different excel spreadsheets and consolidate for data migration purposes
  • Analyse data for inconsistencies and anomalies and resolve with business stakeholders Work alongside ERP project team to test data once migrated in to ERP solution

Qualifications, Knowledge and Experience

Essential

Excel – excellent excel skills with a minimum working knowledge of the following:

  • SUM
  • LOOKUP (VLOOKUP, XLOOKUP) 
  •  IF Statements (IF(S), SUMIF(S), COUNTIF(S)) 
  • COUNT (COUNTBLANK, COUNTA) 
  • Data Filters 
  • Data Sorting 
  • Pivot Tables 
  • Conditional Formatting/Cell Formatting
  • Data validation
  • Workbook (Referring to data between multiple workbooks) 
  • Creating charts
  • Statistically led with an analytical mindset and strong attention to detail
  • 2+ years in a data related role, in lieu of a degree 

Desirable

  • Basic SQL knowledge
  • VBA knowledge
  • ERP/MRP systems knowledge (IFS preferable)

JOIN US

We’re an innovative, dynamic company in one of the most interesting areas of automotive engineering. There are plenty of opportunities to develop new skills and experience at AB Dynamics. In addition, we offer a friendly and supportive working environment along with highly competitive salaries, an additional discretionary company bonus and an attractive benefits package, including 25 days holiday (plus bank holidays), private healthcare and company pension contributions.

To apply for this vacancy, please email your CV and a cover letter to recruitment@abdynamics.com

Sign up to our newsletters