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.