This position involves managing a “data migration” role, delivering a GCP-based solution to accelerate business transformation. My remit includes modelling and implementing a suite of Big Query structures connected via specific ELTs through on-prem solutions such as SAP, Oracle & Microsoft SQL Server. The solution consists of building a complete business overview and migrating data from on-prem systems into the Cloud using custom/cloud transformation tools. The final goal is to retrieve data insights from the Cloud and provide essential information for the Veolia Group business. The data amalgamation consists of hundreds of tables and various data sources such as SAP, CMS, HR ERP, Microsoft Excel, and non-structured data.

Moreover, I have positioned myself as a data enabler, providing loads of documentation such as Best Practices, Data Dictionaries, Data Models diagrams, architecture documents and more.

Used technologies:

GCP, BigQuery, DBT+Dataflow, Airflow, Airbyte, Cloud Data Fusion, Dataform, Microsoft Power BI, Microsoft SQL Server, MQuery, DAX, Data Security, SQL Security, EAI, VBA, SAP Business Objects, Informatica Talend, Pentaho.