Data Architect Oracle

Our customer uses a Datawarehouse (EDW) that consolidates, harmonize and distribute information from all enterprise systems. Applications providing data to EDW are AS400 legacy for back office retail, finance and supply chain (JDA, JDE, Stealth) as well as Oracle Retails and various SQL based systems (Point of Sales). Some of these sources are currently being replaced by an SAP integrated ERP.

Applications receiving data from EDW are Datamarts used for analytic purpose, transactional systems like CRM (Siebel), Replenishments (customs), Datalake (Cassandra/SOLR), Salesforce,.... EDW (as well as analytics datamarts) are based on Oracle Exadata + ODI as ETL. Activities: an increasing number of intiatives are solliciting the EDW as a data provider (salesforce, Datalake) or data receiver (SAP).

The internal EDW architect needs to be supported by 2 new additional resources, that would act on his behalf in all these project instances, but under his supervision.

Architects are expected to work in collaboration with: 
  • service owner / product owners / developer teams for each given project, with whom they'll elaborate a data architecture on all EDW layers (DSO, transformation, Publication) that garantee data consistency, security and usability in the context of business requirement expressed
  • Technical team of sender/receiver system as to advise and model the proper data quality checks that will allow control of data quality received by external system and ensure that discrepancies between source and target don't grow over time
  • Maintenance team, to elaborate with them a dataflow strategy that is optimized for a smooth and automated "run" mode
  • Infrastructure team, to garantee that infra resources are properly used and configured to deliver performance and data availability expeted Mission details
  • 1 role in Paris (to be close of salesforce + datalake teams) but with at least 2 to 3 days / week in Florence expected in the first 6 months in order to sit close to the current EDW architect and facilitate knowledge sharing & interactions. 
  • 1 role either in Paris, Milan, or Florence, with at least 2 to 3 days in Florence for 6 months if Florence is not main location (similar than above) 
Skills required
  • Data architecture and datawarehouse modelling
  • Oracle / SQL admin and modelling
  • Exadata and ODI 
  • English fluent mandatory


ID Posizione:

Tipo Contratto:
Assunzione a tempo indeterminato

Data Pubblicazione:

Data Inizio Attività:

Business Intelligence

Area Business:

Parigi - Francia