Skip to main content

CS xxxx – DG REGIO (BI & DWH Expert ) – informal #853316

We consider near site consultants.
near site: being able to be at the office in 2h time by car 
  1. Context
DG REGIO's IT unit is looking for an external consultant who will work in the Reporting and Guidance sector more specifically in the Reporting team; he/she will be an expert on Business Intelligence tools and will work on the centralized data warehouse (DWH) that stands on shared models, business terms, processes, as well as reporting standards.
It is important to note that, there are no specialised functions in the Reporting team. The nature of the work for an external consultant is end to end. For instance, the consultant participates in the requirements gathering, implementation of the solution (all layers), testing and delivery to the user. Technically this implies data extraction-transformation-loading, DWH modelling, design of the universe and creation of the report.
  1. Specific Expertise Required and certificatons
Following specific expertise is mandatory for the performance of tasks:
  • Minimum 5-15 years of professional experience in the IT domain;
  • Minimum 3-6 years of  recent professional experience in report development (SAP Business Objects Objects or SAP BI);
  • Minimum 3-6 years of recent professional experience in Oracle RDMBS Database development, Data Modelling and SQL;
  • Minimum 3-6 years of recent professional experience in ETL development (SAP BODI or SAP BODS);
  • Minimum 3-6 years of recent professional experience in Data Warehouse;
Following certificates & standards are required for the performance of tasks:
  1. Languages
  • The consultants have to be fluent in English.  French is an asset;
  • Documents will be written in English.
  1. Provisional Description of the Work
In this context, the tasks include:
  • Creation and maintenance of a Business Object data warehouse;
  • Gathering  & analysis of the business requirements;
  • Design, development and documentation of complex Business Object reports;
  • Design, development and documentation of complex Dashboards;
  • ETL processes (BODS) review, analysis of improvements and implementation;
  • Data modelling;
  • Physical DB design and DB performance analysis;
  • Elaboration of test programs;
  • Technical migration to  new tools  or to new versions;
  • Writing of Business and Technical documentation;
  • Assistance in the implementation of Datawarehouse development methodologies to the team;
  • Collaboration with the team leader in the elaboration of strategy documents related to the Datawarehouse.
  1. Knowledge and Skills Required
  • In depth knowledge of relational database systems applied to data warehouse;
  • In depth knowledge of data warehouse architecture;
  • In depth knowledge of SQL;
  • In depth knowledge of Business Objects reporting tools;
  • In depth knowledge of ETL tools (BODS will be an asset);
  • Good knowledge of Data quality concepts;
  • Knowledge about development of dashboards will be an asset;
  • 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;
  • Knowledge of the organisation of the European Commission and experience working in an EC environment is an asset;
  • Excellent interpersonal communication skills.
  • Experience in Data Analytics (Power BI or SAP Analytics Cloud) is an asset
  • Experience in Data Virtualisation (Denodo) or Real Time reporting is an asset
  • Experience in Data Science (R-RStudio, Python-Anaconda or Knime) is an asset
  • Knowledge of the organisation of the European Commission with a focus on SFC DGs (REGIO, MARE, AGRI, EMPL and HOME) is an asset;