Software Consultant in Data Integration

Job description

Trasys International offers IT Consulting jobs at the European Institutions and International Organizations 🌎 We strive to provide the best talent to our customers, and to do that, we need enthusiastic and competent people like you.


If you feel ready for the European challenge, keep reading! 👇


For our customer, a EU institution based in Brussels, we are looking for a highly motivated Software Consultant in Data Integration



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, analyzing reporting needs, deducing data needs and data sources to fulfill 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 data from 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 through the 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.

Requirements

Very strong expertise with SAS Data Integrator Studio (minimum 1 year of experience);

Proven practical experienced in the following software of the SAS9 platform for at least one year:

o SAS Data Integrator Studio

o SAS Enterprise Guide

o SAS Management Console

o IBM Platform Process Management

o SAS programing language


Extraction, Transformation and Loading (ETL), business intelligence, online analytical data processing, data analytics, reporting, data & text mining, dashboards & reporting, big data Qlik Sense, Business Objects, web scraping…;

Data quality, data control and monitoring techniques;

Relational database systems applied to data warehouse;

Data warehouse architecture;