Eduardo Schmitz Bongiolo

Data Analyst @9 Friendly White Rabbits

Berlin, DE

I tapped into a data engineering role to retrieve data from two APIs. For this task, I used Python to develop a script capable of interacting with the API and writing the information onto BigQuery. Later I used dbt for the data model and Data Studio for visualization- Developed SQL data model capable of weighted Marketing Attribution for a client who had knowledge of each online platform\'s ROI separately, but wanted to look at the overall performance of all marketing channels including organic, TV, and print- Integrated ad data from a few social media platforms (Facebook, Linkedin, Youtube, and Google ads) into a single dashboard (Data Studio) using dbt to build the data model and Fivetran to load data into the DWH (BigQuery)- Designed tracking specifications for the pages of a new product, and oriented developers on implementing GTM and data layer pushes. Created visualization in Tableau from the new product\'s data integrating data from GA and SalesForce.