Senior Business and IT Consultant

Spektrum have a wide range of exciting opportunities in several global locations.  We are always looking to add great new talent to our team and look forward to hearing from you. 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. We never know what new opportunities might be just over the horizon. If this opportunity isn't for you, please feel free to send us your resume anyway and be the first to know if something suitable for your skills and experience comes up.

Spektrum have a wide range of exciting opportunities in several global locations.  We are always looking to add great new talent to our team and look forward to hearing from you. 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:          * Support of mail servers and mail relays for eu-LISA core business systems (SISII and VIS). * IT support, ranging from simple desktop and peripheral support to complex server and network issues. EDUCATION:        * Minimum 4 years of relevant education (master or equivalent) after the secondary school MINIMUM EXPERIENCE: * Minimum 9 years of relevant professional experience ADDITIONAL NEEDED QUALIFICATION, KNOWLEDGE AND SKILLS:          * Server management, Operating System (OS) knowledge (UNIX, Linux, Windows) * Virtual servers : VMware ESX would be an asset * Administration of Backup & Storage systems (knowledge of HP backup & storage systems would be an asset) * Network infrastructure services (print server, dns, ntp, etc.) * Active Directory (AD) / LDAP Management * Email and antispam systems * Network Access Server (NAS) and Distributed file systems * Public Key Infrastructure (PKI) systems * Replication & Disaster recovery * Document management systems * Centralized deployment of software and updates * HW/SW inventory management * Software compliance monitoring and enforcement * Monitoring systems (configuration, customisation, further development), NAGIOS infrastructure monitoring software knowledge would be an asset * Centralized IT security policy management * Excellent analysis and problem solving * Prioritizing incidents, requests and changes * Experience in managing highly available environments and multiple site support * Familiar with ITIL/ITIL V3 concepts * Script development skills (php, perl, csh, etc.) We never know what new opportunities might be just over the horizon. If this opportunity isn't for you, please feel free to send us your resume anyway and be the first to know if something suitable for your skills and experience comes up.