DWH/Data Warehouse Architect

DWH ARCHITECT/+5 MONTHS/HELSINKI

Senior DWH Architect/Senior DWH Analyst required for one of our clients in Helsinki.

The main tasks carried out by the Senior Architect are:

- 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
- Collaborating with Front End team
- Constructing, 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

SKILLS - MUST HAVES

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.

Specifically, the following skills are required:

- 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 and Data Profiling.
- Practical experience of Datamodelling (logical and physical)
- Experience of implementing solutions in Enterprise level Data Warehousing projects

The project is utilising an Agile methodology with tasks divided into a series of sprints.
Detailed milestones for the various deliverables will be defined during regular sprint planning meetings held before the execution of each sprint.

ADDITIONAL INFORMATION:

- Role: DWH Architect
- Start: 01-03-2015
- Duration: +5 months
- Location: Helsinki
- Languages: English

For immediate consideration please send me your latest Word- CV together with a short motivation.

Thanks,

Ida

Disclaimer: Montreal Associates (Systems) Ltd, in its capacity of Employment Agency for permanent recruitment and Employment Business for the supply of temporary workers, is firmly committed to the active promotion of equal opportunities and to ensuring an absence of any form of discrimination on any ground .