US Jobs US Jobs     UK Jobs UK Jobs     EU Jobs EU Jobs

This job has been posted for more than 30 working days and has expired.

Technical Data and Compliance Analyst : Darlington

Technical Data and Compliance Analyst - Darlington

Salary - £30k + Pension + Life Assurance

The Client

Our client have over 30 years experience in software development and supplies a complete range of products backed by technical support and consulting services.

Their specialist teams combine chemistry, hazardous materials expertise, computer programming, quality assurance and project management skills that deliver the most efficient and user-friendly systems available.

The successful applicant will be based in there newly refurbished, spacious, modern offices.

The Role

Your role is to retrieve data out of (usually unstructured or poorly structured) data sources for further data processing or data storage by using ETL methods (Extract, Transform and Load).

Typical unstructured data sources and change instructions include web pages, word documents, PDFs, etc.

Data is captured from various regulations concerned with the carriage of dangerous goods and quality data is supplied to customers in various formats.

The data is also used in company products and services.

Extracting data from these unstructured sources is a considerable technical challenge, so you should be competent in using various computer tools (MS Access, Excel, Word, MS SQL Server and have some programming experience in manipulating data).

The following are some typical cases at the data transformation stage:

Selecting only certain columns to load

Translating coded values

Joining data from multiple sources (e.g., lookup, merge) and de-duplicating the data

Aggregating (for example, rollup - summarizing multiple rows of data)

Transposing or pivoting (turning multiple columns into multiple rows or vice versa)

Splitting a column into multiple columns (e.g., converting a comma-separated list, specified as a string in one column, into individual values in different columns)

Looking up and validating the relevant data from tables or referential

Applying any form