Google Data Studio Expert needed for Social Media Campaign Dashboard

Hi, for one of our key clients we are currently running multiple media campaigns on Facebook (organic and paid), Instagram (organic and paid), LinkedIn (organic and paid), Google Ad campaign (paid) and Google Key word campaign (paid). We have consolidated all channel campaign data into our Bigquery database via supermetrics / funnel connector. We now want to visualize this data in a state-of-art front-end design for performance marketing leveraging google data studio. Expected deliverable: - 1 dashboard consolidating all key KPIs (e.g. engagement, followers, impressions, likes, ....) across all channels with time / date as common nominator - 1 dashboard by channel (LinkedIn, Facebook, Instagram, Google) using similar layout structure if possible (e.g. same key KPIs as above) - 1 dashboard by channel LinkedIn, Facebook, Instagram, Google) showing how the content pieces perform / show comments / feedback - Additional dashboards as per freelancer guidance Key activities for the freelancer would be as such: - validate data flow and data availability in bigquery for both supermetrics and funnel connectors - link data tables from bigquery to google data studio (include as a database) - develop dashboards building on best practices from previous freelancer work (do not re-invent the wheel, be pragmatic and leverage what you have already done on other projects) - align with key stakeholders with the client to validate / optimize the dashboards - handover dashboard as well as key learnings to the customer (no extensive documentation is required) Key expectations towards the freelancer: - sound knowledge with bigquery database - expert in google data studio - expert in building performance dashboards - strong communication / engagement skills We are looking for support on this concrete customer project currently but are open for a more long-term engagement as we are planning to build / scale our customer base. Please provide a fixed price offering for this project but please also share hourly rates for future engagements. When applying for the role, please share your portfolio on google data studio dashboards (screenshots or direct link to dashboards). Kick-off would be asap, we would want to have first pilot of dashboards in place within 5 days (if possible). Feel free to leverage any existing work you have done in this field, copy+paste, be pragmatic. Looking forward to good applications. Let me know if you have any comments / questions. Cheers, Kornelius