Data Warehouse Architect

Uusimaa  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

TRASYS is a leading Information Technology services and consulting Company focusing on four activities:

Consulting Services, Solutions on Development & Integration, Managed Services and Technical Assistance.

With more than 650 IT professionals combining in-depth business expertise and state-of-the-art most advanced working methodology, TRASYS aims to provide innovation in environments marked by constant shifts. With the client's success in mind and our people as our number one asset, we enjoy through a highly versatile team the trust of over 300 customers spanning Europe in a wide range of sectors including International Organizations, Industry and Distribution, Financial Services, Utilities, Public Sector, Aeronautics and Defence.

As part of its business development strategy, TRASYS is currently looking for a DataWarehouse Architect

Work Location: Helsinki, Finland

Ref: TRH-DArc

The position:

  • Information needs analysis (deriving and interpreting actual requirements from the needs expressed by business)
  • Act as liaison and facilitator between IT and business units
  • Translate business information needs into technical requirements
  • Design of data integration solutions: Develop an in-depth understanding of the source systems and data models; data profiling; end-to-end design of the production process to extract, transform and load the data; be involved in requirements gathering; collaborate with Front End team; construct, unit testing and automating the extract, transformation and loading process
  • Support development of the logical data model
  • Physical data model design, development & implementation
  • Provision of clear & concise technical documentation
  • Document technical specifications based on user requirements
  • Document recommendations about the reference architecture for the data warehousing solutions, mapping it within the specific Oracle environment
  • Implement, test and performance tune ETL infrastructure and architecture according to agreed specifications
  • High quality contribution to the enterprise data model
  • Standard operating procedures for data warehouse tuning and monitoring
  • Provide clear and understandable documentation of the deliverables and DW Operations and Installation manuals

The Candidate:

The ideal candidate will be expected to possess the following:

  • Bachelor's in Computer Science, Information Systems, Engineering, or other related field
  • At least 5 years of experience is required in roles covering the key responsibilities described above
  • The majority of the core systems in the project are implemented using Oracle products (Databases & ETL), therefore practical and proven experience in the design of Oracle solutions is necessary
  • Practical experience of gathering information requirements and business process analysis
  • Hands on experience of designing, developing & implementing ETL processes using industry-standard ETL tools
  • Building/tuning procedures with PL/SQL
  • Practical knowledge and experience of Data Analysis, Data Profiling, Datamodelling (logical and physical)
  • Excellent understanding of business processes
  • Experience of implementing solutions in Enterprise level Data Warehousing projects
  • Excellent oral and written communication skills are required

Please send your CV in English

All inquiries and applications will be handled in strict confidence and will be acknowledged promptly.

Start date
n.a
From
Trasys
Published at
23.07.2014
Project ID:
746402
Contract type
Freelance
To apply to this project you must log in.
Register