Senior Business Intelligence Specialist

Background:

eu-LISA is the European Union Agency for the Operational Management of Large-Scale IT Systems in the Area of Freedom, Security and Justice (eu-LISA) manages large-scale IT systems to support the implementation of asylum, border management and migration policies in the European Union (EU). The Agency is also a front-runner for the digitalisation efforts of the EU's Justice and Home Affairs domain, building a new information architecture and contributing to the development of a new security ecosystem. Since the Agency's beginnings in 2012, eu-LISA has become the digital engine of the Schengen Area. With its activities and tasks, the Agency adds value to the EU Member States by supporting their efforts towards justice, security and freedom.

Task description:

Design and development of online analytical data processing (OLAP) solutions

Creation and maintenance of a data warehouse

Gather business requirements

Development of data mining solutions

Knowledge of Extract, Transform and Load (ETL) processes

Data modelling

Design and development of reporting applications

Physical Database (DB) design

DB performance analysis

Elaboration of test programs

Writing of technical documentation

Assistance with deployment and configuration of the system

Participation in meetings with the project teams

Education:

Minimum 4 years of relevant education (master or equivalent) after the secondary school

Minimum Experience:

Minimum 9 years of IT professional experience.

Minimum 3 years of experience with Relational Database Management Systems (RDBMS)

Minimum 3 years of experience in Data Warehousing

Additional needed qualification, knowledge and skills:

Experience with Business Intelligence (BI) reporting tools

Experience with ETL tools

Experience with online analytical processing and data mining

In-depth knowledge of data warehouse architecture

In-depth knowledge of relational database systems principles applied to data warehouse

In depth knowledge of Structured Query Languages (SQL)

In depth knowledge of business intelligence reporting tools

Good knowledge of ETL tools

Good knowledge of modelling tools

Good knowledge of online analytical data processing (OLAP) and data mining tools

Ability to cope with fast changing technologies used in application developments

Ability to participate in multi-lingual meetings, ease of communication.

Capability of integration in an international/multicultural environment, rapid self-starting capability and experience in working in team.