Data architect

Vertragsart:
Vor Ort
Start:
ASAP
Dauer:
6 months with extention
Von:
Next Ventures Ltd
Ort:
Aargau
Eingestellt:
13.06.2018
Land:
flag_no Schweiz
Projekt-ID:
1570804

Warning
Dieses Projekt ist archiviert und leider nicht (mehr) aktiv.
Sie finden vakante Projekte hier in unserer Projektbörse.

Description:

Background:
"Client"is building a new facility in Kaiseraugst for the market launch of solid products. In this new facility, "Client" implements a new state of the art MES system based on "Client' Suite. As part of the MES deployment, new reports will have to be created to support the operations in the shop-floor and retrieve/analyze data from the MES system.

General information:
- Start date:
- Latest start date:
- End date:
- Extension: An extension might be possible, but would need to be approved.
- Work location: Kaiseraugst
- Workload: 100%
- Remote/Home Office: Not possible.
- Travelling: No travelling.
- Team size: 4-5 people
- Department: FPPM (Manufacturing Intelligence)

Tasks & Responsibilities:
- Work closely with the project team to determine the data sources to be integrated
- Acquire knowledge about the data structure of the solutions to be integrated
- Implement data model according to available specifications
- Test the data model to verify the correctness
- Work closely with report developers to ensure the reports build on the data model are correct

Must Haves:
5-7 years of experience in an appropriately relevant area in Datamodelling/Data Integration
Proficiency in writing and analysing SQL and PL/SQL or SPL
Understanding of most common Data Ware House and Data Modeling concepts (eg Inmon, Kimball, Data Vault, normalization/denormalization etc.)
Understanding of SQL performance related topics
Ability to understand and create logical and physical data models
English speaking

Nice to Haves:
+++ Experience with Oracle and other databases (MS SQL Server -)
+++ Former Roche Experience
+++ German