Data Warehouse and Reporting Developer

Serco is the preferred partner for European Institutions and International Organisations, offering ICT services and Contact Centre management across Europe. Our expertise extends from Information System support to consultancy under the government framework, supporting key entities such as the European Commission and Executive Agencies. As a leader in Service Integration and Management, we ensure seamless delivery of services across various platforms, embodying our commitment to excellence in every aspect of our work.

We are hiring a …. for European Commission in Brussels and various locations around Europe.

Typical tasks of a Data Warehouse and Reporting Developer are related to:

• Operational aspects of the data warehouse.
• Development and maintenance on Enterprise Data Warehouses (EDW).
• Development and maintenance of the software - web or standalone - applications and the catalogue ofreports related to the data warehouse.

Operational production:

• Dataset updates.
• Data extractions.
• Report generation.

Maintenance:

• Reports catalogue maintenance.
• ETLT process corrections and improvements.2
• Assistance with deployment and configuration of the system.
• DB performance analysis.

Design/Development of:

• ETLT processes.
• Reporting applications.
• Physical DB.
• Test programs.

Other aspects:

• Writing technical documentation.
• Participation in meetings with other project teams.
• Interaction with the business analysts, customer, users, project leaders and the developers.

LEVEL OF EDUCATION

Bachelor's or Master's Degree

KNOWLEDGE AND SKILLS

Essential:

Practical experience in a Data warehouse production environment for periodic tasks. Ability to ensure business continuity of Data warehouse.

In depth knowledge of:

• SQL and RDBMS ORACLE and tools (sqlloader, sqlplus, etc.) (Minimum 3 years).
• Linux/Unix OS, scripting and tools (awk, sed, etc.) (Minimum 3 years).
• Java, Perl, Python (Minimum 3 years).
• Source control tools such as Git.
• Continuous Integration/Continuous Deployment with tools like Jenkins.
• Data warehouse concepts and ETLT tools.

Good knowledge of:

• Data processing, analytical analysis, reporting tool (especially BIRT).
• HTML/XHTML, XML, XSLT, CSS, JavaScript.
• The design and development of web and multi-tier internet applications (JAVA J2EE).

Considered as asset:

• PowerBI experience.
• Airflow experience.
• Software development methodologies, especially the methodologies used within the European Commission: PM² and RUP.
• Modelling tools (e.g. UML).
• Familiar with trade statistical data (e.g. from WTO, IMF or World Bank) and concepts.

Skills:

• Autonomous.
• Strong organisational and time-management skills.
• Excellent verbal communication.
• Attention to details.
• Good problem-solving skills.

Serco is a leading provider of public services. Our customers are governments or others operating in the public sector. We gain scale, expertise and diversification by operating internationally across five sectors and four geographies: Defence, Space, Justice & Immigration, Transport, Health and Citizen Services, delivered in UK & Europe, North America, Asia Pacific and the Middle East. More information can be found at Serco | Europe

Why should you join Serco ?

• Chance to contribute to innovation in the public services sector
• A company passionate about diversity and inclusion
• Permanent employment with comprehensive Serco Benefits package.

We are diverse and inclusive organisation

At Serco, we see people first and foremost for their performance and potential and we are committed to supporting the needs of all our colleagues. It’s a mix of people from different backgrounds, experiences and opinion that keeps our culture strong and vibrant.

We believe in equity so we strongly encourage applications from a diverse range of candidates. Disabled applicants who meet the minimum criteria for the job are encouraged to apply and demonstrate their abilities in an interview. We also welcome a conversation about any adjustments that would make the interview process more accessible for you. Wherever possible we are open to discussions around flexible working and we operate a hybrid work structure in many of our business areas.

In the UK we are proud to be a Disability Confident Leader in the government’s scheme and hold the Gold Inclusive Employer Standard; in Belgium we are partner of Diversicom and member of Charter der Vielfalt in Germany.

If you have any questions please do not hesitate to reach out to The Serco Europe Recruitment Team

Important

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

Please contact the recruitment team if needed

Data Protection:

For more information on how the personal data is processed, please see the link Data Protection policy here.

• Competitive Salary
• Corporate Benefits Package
• Chance to make a positive difference in a company passionate about diversity and inclusion.

Further information available from the Serco Europe Recruitment Team