Engineering Database Technicians process a wide range of data as it arrives directly from the client, preparing the data for the project teams to work on. They are effectively undertaking the first phase of the data cleansing process. The data arrives in various formats, including Excel spreadsheets, Access databases etc. and must be prepared and loaded into our clients in-house software.
Key results/Responsibilities:
* Implement generic processes for the import of all information sets provided by the Client
* Implement generic processes for the export of all information sets requested by the Clients for use in their enterprise / corporate systems
* Use SQL Server tools (SSIS, SSRS, etc)
* ‘Can do’ attitude and be able to come up with lateral solutions to problems
* Using your technical capabilities together with understanding of engineering / project requirements to feed into future strategies
* Ensuring quality, continuous improvement and development, standards and procedures are adhered to
* Control the receipt of all raw engineering data
* Prepare the data for import into the database
* Carry out all data manipulation tasks whilst establishing and preserving the requisite audit trail
* Become knowledgeable with data manipulation and reporting tools and to provide a data support role to all projects.
* Pro-actively improve and develop existing tools and techniques to improve the performance of the company
Skills to be Demonstr...