Data Analyst, Jobs, Scotland, Aberdeenshire, 5092

Data Analyst - Aberdeenshire

Technology - IT- Business Analysis
Ref: 5092 Date Posted: Monday 20 Nov 2017
More

My client is an international consultancy provider delivering robust engineering, consultancy and software solutions to the energy industry on a global scale. In their 30 years of global operation, they have become a trusted service provider to the energy industry which is evidenced by their comprehensive client base and growing pool of worldwide Master Service Agreements.

Due to further expansion, they are now recruiting an experienced Data Analyst. You will be responsible for supporting Senior Analysts to ensure integrity of CMMS data development build, and to ensure that the data requirements are met by controlling data flow, manipulation, and conducting data integrity quality assurance checks.

This role represents a great opportunity to gain experience and exposure within the Oil and Gas industry and the prospect to advance within a progressive company with real career challenges.

Key Responsibilities:

  • Preparation of work packs/ templates using SQL (Access / MySQL / Oracle) and/or Excel formulas / VBA.
  • Building VBA macros / SQL queries to automate existing processes.
  • Preparation / Update of Microsoft Access databases required to ensure data integrity and validation
  • Development of final deliverable load files ensuring quality and integrity as per client specification
  • Ensuring that all key milestone deliverables meet the data specification required throughout the project and identify any potential obstacles
  • Assisting with CMMS build and data collation.

Required Knowledge, Skills & Experience:

  • 1-2 years’ experience working in SAP PM or Maximo
  • Knowledge of MS Access, advanced Excel formulas
  • Knowledge of SQL and relational database theory
  • Good communication skills
  • Ability to work as part of a team or individually
  • Ability to prioritise and organise own workload

Desirable Knowledge, Skills & Experience

  • A knowledge/experience of Computerised Maintenance Management Systems (CMMS) such as SAP and Maximo would be an advantage
  • VBA
  • Previous experience on maintenance build projects

Minimum Qualifications
BSc (hons) Degree in computer science, Math, statistics or Engineering