Expert Software Consultant (min. 9 years of experience Deadline 08/04/2021) (BB-6027E)
Trouvé dans: Xpatjobs BE
Description:The services to be provided consist in maintaining and enhancing the existing system(s) using SAS software upon which the data warehouse is built and other relevant tools.The types of tasks included in the service will concentrate on supporting the Commission staff in the area of data integration, analysing reporting needs, deducing data needs and data sources to fulfil them, document and develop the adequate SAS procedures to extract,transform and load the data in the datamarts of the Data Warehouse and maintain the existing and future implementations:Design and development of online analytical data processing (OLAP);Design, test and implementation of ETL processes using SAS software to extract datafrom several sources and to transform and load it into a datamart suitable for statistics;Writing SAS code to run tests or to write specific user transformations;Design and development of integrated data quality and monitoring processes throughthe ETL process;Data modelling;Database design performance analysis;Workflow design;Data analytics and data mining;Participation in meetings with the project teams;Writing of technical documentation and user manuals.REQUIRED SKILLSProven practical experienced in the following software of the SAS9 platform for at least one year:o SAS Data Integrator Studioo SAS Enterprise Guideo SAS Management Consoleo IBM Platform Process Management o SAS programing languageBusiness intelligence technologies, including ETL, online analytical data processing, data analytics, reporting, data text mining, dashboards reporting, big data Qlik Sense, Business Objects...;Data quality, data control and monitoring techniques;Relational database systems applied to data warehouse;Data warehouse architecture;Data and processes modelling tools;SQL, NoSQL;Enterprise Architect;Strong analysis skills;Self-starting capability and experience in team working.SPECIFIC SKILLSVery strong expertise with SAS Data Integrator Studio (minimum 1 year of experience);Capacity in preparing and writing clear and structured technical and user documents;Ability to apply high quality standards;Good communication and team working skills;Capability of working in an international / multicultural environment;Ability to work in English and French.WORK ENVIRONMENT / WORK PLACEThe tasks shall be performed on the Commission premises in Brussels.The infrastructure will be provided by the Commission.Subject to the agreement of the Commission, the service provider might be authorised to perform the tasks remotely (teleworking) up to 2 days per week in close vicinity to the Commission premises in Brussels.The line manager will assess whether the service provider is at a distance compatible with the tasks, based on the needs of the service.In view of the nature of the work, the close collaboration with the team leaders is required during the induction period when the service provider is trained and closely supervised.
calendar_todayil y a 2 jours