Zakaria H.

Project: Migration of SAP Procurement data to a centralized Snowflake Data Foundation composed of several layers (Staging, Data Warehouse, DataMart). Development and optimization of data pipelines to improve the quality and availability of analytical data.

Data Ingestion & Integration

• Data integration via SQL and IICS and storage in different layers (Staging, DWH, DataMart).

• Automation of loading and transformation of flat files from NAS to S3, then Snowflake.

• Snowflake Data Sharing: creation and management of shared views for partner teams.

• Implementation and execution of unit tests to ensure data quality.

DataMart Modeling and Optimization

• Design of fact and dimension tables in the Snowflake DataMart.

• Reverse engineering of Qlik Sense & Power BI applications and rewriting code in optimized SQL.

• Maintenance and evolution of Snowflake views for BI needs.

• Backend support during dashboard migration.

• Writing technical documentation.

Project: Development and maintenance of Qlik Sense and Power BI dashboards for the analysis of industrial performance at Sanofi.

Development and Maintenance of Qlik Sense and Power BI Applications

• Gathering and analysis of business needs to design relevant dashboards.

• Development of data extraction and transformation scripts.

• Publication and management of production releases on UAT and PROD environments.

• Bug tracking and technical maintenance related to dashboards.

• Onboarding of new developers and training on Qlik and Power BI tools.

• Support for business users to improve their skills in creating KPIs and custom dashboards.