Data Warehouse and Reporting Developer

DESCRIPTION OF TASKS

• 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 of reports related to the data warehouse.

Operational production:

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

Maintenance:

• Reports catalogue maintenance.
• ETLT process corrections and improvements.
• 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.

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 (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 assets:

• QlikSense 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:

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

Due to the particular nature of the client, candidates should also have the following non-technical skills:

• Ability to integrate an international/multicultural environment, rapid self-starting capability and experience in working in team;
• Ability to participate in multilingual meetings;
• Ability to work in multi-cultural environment, on multiple large projects;
• Excellent Team Player
• Ability to understand, speak and write in English (B1/B2). French B1 will be an advantage;
• High degree of discretion and integrity is required

SPECIFIC EXPERTISE

• at least 3 years of specific expertise in RDBMS ORACLE
• at least 3 years of specific expertise in SQL
• at least 3 years of specific expertise in Unix/Linux

The following documents / procedures will be requested to successfully complete the hiring process :

• A copy of your university degree(s)
• A copy of your criminal record
• Security Clearance Procedure

WHO ARE WE?

CRI Group belongs to VASS GROUP as of November 2021 (https://vasscompany.com/en/).

VASS is a leading digital solutions group of companies headquartered in Madrid, Spain, present in 25 countries in Europe, the Americas and Asia with more than 4,300 professionals.

VASS helps large companies in their digital transformation process, developing and executing the most innovative and scalable projects, from strategy to operations.

All our growth comes from our talented people, passion for innovation, and a constant search for improvement, always the VASS way: “Complex made simple”.