Data Warehouse Architect

A leading Financial Services Company based in Dublin City is looking for a skilled Data Warehouse Architect/Engineer to drive a DW/ETL migration project.

This is a contract position paying a top daily rate.

FUNCTIONS/OBJECTIVES:

- build a project plan by gathering all necessary requirements from relevant departments and by analysing existing DW/ETL structure
- design and implement (dimensional) DW database structure (IBM DB2)
- design and implement ETL system using Pentaho (migration from custom build Java toolset)
- migrate existing reports (and design new ones as required) from Crystal Reports to Pentaho
- provide training to non IT staff on Report building and design
- maintain comprehensive documentation for all relevant systems/processes

ESSENTIAL QUALIFICATIONS/EXPERIENCE:

- 5 years+ experience in developing, integrating, deploying and managing complex Data Warehousing ETL solutions
- 2/3 years+ industry experience working with Pentaho
- proven track record of working in Financial Services sector (preferably FX)

KNOWLEDGE AND SKILLS:

- proficient in database design and administration
- excellent technical analysis and Datamodelling skills
- excellent documentation skills
- working knowledge of FX transaction workflows

PERSONAL SKILLS:

- Strong communication skills (verbal and written)
- Desire to increase knowledge and to learn new and/or improve skills

If you are interested in applying for this position don't hesitate to contact me or email