DESCRIPTION OF THE TASKS
Following tasks will be performed by external service provider:
• Statistical analysis, collect and pre-process datasets, build machine learning algorithms and predictive
models.
• Creation and maintenance of Enterprise Data Warehouses (EDW) and complex Business Intelligence
Solutions (Data Lakes / Data Lakehouses).• Designing architectures both on the cloud and on premises (whether hosting or cloud on-premises) or
combination of both (hybrid).
• Gathering business requirements.
• Designing ETL processes.
• Data virtualization and modelling.
• Design and development of reporting applications.
• Development of front-end (UI / UX) applications.
• Write SAS code to run tests or to write specific user transformations
• Physical DB design.
• DB performance analysis.
• Design of Data Quality and Health Monitoring processes.
• Elaboration of test programs.
• Writing of technical documentation.
• Assistance with deployment and configuration of the system.
• Participation in meetings with other project teams.
• Review of the architecture of existing systems.
• Design and development of component architecture and building blocks.
• Analysis of the integration of different information systems.
• Interaction with the business analysts, customer, users, project leaders and the developers.
3. LEVEL OF EDUCATION
Master degree
4. KNOWLEDGE AND SKILLS
Following skills and knowledge are required for the performance of the above listed tasks:
• Excellent knowledge of data warehouse design & architecture.
• Good knowledge of data lake/data lakehouse design and architecture.
• Excellent knowledge of relational database systems applied to data warehouse.
• Knowledge of non-relational database technologies.
• Excellent knowledge of SQL, NoSQL
• Excellent knowledge of business intelligence reporting tools.
• Excellent knowledge of ETL tools.
• Excellent knowledge of modelling tools.
• Excellent knowledge of online analytical data processing (OLAP) and data mining tools.
• Proven practical experienced in the following software of the SAS9 platform for at least 1 year is an asset:
o SAS Data Integrator Studio
o SAS Enterprise Guide
o SAS Management Console
o IBM Platform Process Management
• Knowledge of near real time data warehousing and/or change data capture technologies.
• Good knowledge of cloud-based business intelligence design.
• Working experience of Angular / D3 languages.
• Working experience of Python, Anaconda, Django.
• Experience with Database Mining systems and in Big Data technologies.
• Experience with Artificial Intelligence.
• Experience with Message Oriented Middleware/Enterprise Service Bus technologies.
• Experience with modern UI paradigms (client-side scripting).
• Ability to work under pressure efficiently and fast.
• Ability to apply high quality standards.
• Analysis and problem solving skills.
• Capability to write clear and structured technical documents.
• Ability to participate in technical meetings and good communication skills