Business Intelligence Expert - Sansaone

Your tasks: 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 and 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 and DB performance analysis; Assistance with deployment and configuration of the system; Review of the architecture of existing systems; Design and development of component architecture and building blocks. Requirements Master’s degree in IT, combined with 7 years of professional experience; 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: SAS Data Integrator Studio, SAS Enterprise Guide, SAS Management Console, IBM Platform Process Management,SAS programing language; 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, Djang...