BI Engineer (Media data) (INBW23821) Amsterdam, Nederland
As BI Engineer you will play a vital part in setting up a media datamart that will enable the organisation to get in-depth insight into the effectiveness and efficiency of the various media campaigns.
You will work with the Data Office (a DevOps BI engineering team that will develop and maintain the datamart) and the Advanced Analytics team (media experts, the key users of the datamart).
Among your responsibilities:
- Offer guidance and advice on the best solutions regarding the specific connectors and data (to optimize functionality, administration and performance);
- Building connectors to establish optimal flow of data to the data lake from a wide variety of media sources (such as Bing, Facebook, TikTok, LinkedIn, Twitter/X, Awin, CM360, etc, and also print and radio);
- Develop ETL Pipelines for the optimized data loading for a wide variety of use cases on different levels;
- Creating data sets to best fit the specific use cases;
- Establish connections to external parties that use the datamart for various causes (analytics, modeling, building of tools etc);
- Train and coach colleagues in administration and further development of the data mart.