Design and development of online analytical data processing (OLAP);
Design, test and implementation of ETL processes;
Design and development of integrated data quality processes through the ETL process;
Data analysis and data modelling;
Database design & performance analysis;
Design and development of reporting applications;
Architecture and design of Information System Architecture;
Assistance in the testing, the technical documentation, the deployment, the evaluation and the reporting.
Requirements
University degree in IT or 5 years of relevant discipline combined with 11 years of IT professional experience;
Experience in business intelligence technologies, including ETL, online analytical data processing, data analytics, record linkage , big data, structure and unstructured data;
Strong knowledge of data quality and data control technics;
Knowledge of relational database systems applied to data warehouse & SQL;
Knowledge of data warehouse architecture & data and processes modelling tools;
Strong expertise with Object Oriented programming, and/or Python would be an asset;
Expertise with Git , version control & API expertise would be an asset;
Expertise with migration of data infrastructure to cloud (AWS, Azure) would be an asset;
Expertise with windows server application maintenance and Microsoft IIS would be an asset;
Capability of working in an international/ multicultural environment;