Technology Expert (, L)
Serco Group Plc
Ispra, Italy
5 gg fa

Job Introduction

Serco is a specialist at delivering vital services on behalf of European, National and Local Governments.

Serco Europe employ’s a large workforce in Belgium, Luxembourg, France, Switzerland, Germany, Holland, Spain, Italy and the UK.

Our European operations have ca. 2,000 employees delivering critical services to public institutions throughout Europe.

For the EU Commission in Brussels we are looking for a Technology Expert with at least 9 years of relevant work experience.

Java Reporting

Design and implementation of reports constructed with JasperReports. This is to allow access to data collected by the JRC under the DCF Regulation and stored inside PostgreSQL relational databases.

The objective of these reports is to enable authorized Commission officials (from outside the JRC scientific network) to monitor fisheries data flows related to data submissions by Member States in real time.

These data are stored in JRC databases.

Analysis and Data Integration

Future data exchange formats and new fisheries data integration requirements : Analysis of impact and technical feasibility of aligning the JRC data uploading facilities with the exchange format adopted by Eurostat for fisheries data (SDMX format).

Tests with the different types of data (biological, effort and catches, economic) submitted by Member States to JRC in the framework of the Data Collection Regulation.

Estimation of time and effort for the migration. In addition, JRC is part of a conceptual schema of fisheries data flows together with other entities like DG MARE, and the Member States.

If DG MARE requires changes to the ways JRC receives data to make them compatible with new practices by DG MARE (its Data Integration Unit), these issues will be tackled under this task.

It will most probably require feasibility analysis, data modelling, DB design, ETL and prototyping work.

Fisheries Dependent Information Data

Develop or enhance a test software module to allow users to connect directly to JRC PostgreSQL databases from the Excel based Data Validation pilot tool already developed by JRC for use by

Member States to submit their data. Test and debug the web application developed by JRC for uploading effort management data through the JRC Data Collection website for data submitted by Member States.

Assistance with deployment of the application under the Liferay environment and performance tuning for queries to the effort databases in PostgreSQL.

Design appropriate interfaces to retrieve and make available to authorized external users datasets of effort data according to the different needs of users (stakeholders and scientists from different EU sea basins, authorities or Commission officials).

Geovisualisation of genetic and other data

Design (in Liferay) of interfaces to genetic databases (in PostgreSQL) held by JRC.

Communication between geovisualization interface and backend databases (developed using the OpenGeo stack) E.g. for the GIS navigation tool in FP7 project AquaTrace, a feature that allows interested parties to follow the project's sampling progress and view the genetic data.

Security assessments

Support to IT-infrastructure related security assessments and reporting, as well as engagement with the relevant JRC IT-security instances.

New release of Liferay

Deployment to production, configuration and maintenance of new releases of the content management system Liferay. Migration of portals, to the new versions.

Knowledge and skills

General IT experience in developing web applications and use of web content management systems : 10 years

  • Experience with Liferay,
  • Experience with PostgreSQL,
  • Experience with Java / J2EE,
  • Experience with XML
  • In-depth knowledge of relational database systems
  • In depth knowledge of 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
  • Very good oral and written knowledge of English is indispensable to communicate with JRC research staff and Commission services
  • Optional : Tableau : familiarity

    Tableau : familiarity

    Business Object : 2 years

    Important

    Any offer of employment is contingent upon you providing documents to verify your identity and employment eligibility, as required by law.

    Applicants are reminded that they will be requested to produce such documentation during the recruitment process.

    Please contact a member of the recruitment team if you require further details of acceptable types of documentation required for verification of identity and work authorization.

    Data Protection :

    When creating a profile on the Serco Career Centre you agreed to the Data Protection policy, a copy is available upon request.

    You may submit a written request revoking your consent to this agreement at any time.

    Package Description

    Full details on application - Relocation assistance provided, if applicable.

    Please note that this position is also open to freelancers (independent contractors).

    Invia candidatura
    Aggiungi ai preferiti
    Rimuovi dai favoriti
    Invia candidatura
    La mia Email
    Cliccando su “Continua”, autorizzo neuvoo ad utilizzare i miei dati ed inviarmi avvisi email come menzionato nella sezione Politica sulla Privacy di neuvoo. Posso ritirare il mio consenso e cancellare la registrazione in qualsiasi momento.
    Continua
    Modulo di candidatura