#Google Data Studio & BigQuery Dashboard Consultant – Immediate Hire

#Google Data Studio & BigQuery Dashboard Consultant – Immediate Hire We are looking for an experienced *Looker Studio (Google Data Studio) & BigQuery Consultant* to support the development of multiple analytics dashboards. This is an *immediate, project-based consulting requirement*, with the possibility of ongoing work based on performance. ## What We Need We currently have two immediate dashboard requirements: ### 1. Creator / Influencer Performance Dashboard Build a dashboard to track and compare creator/influencer performance across campaigns. The dashboard will combine creator performance metrics with associated costs/expenses to help evaluate: * Creator and campaign performance * Reach, impressions, views and engagement metrics * Creator/influencer costs * Media spend where applicable * Cost-efficiency metrics * Performance across platforms/campaigns * Creator comparisons and benchmarking * Performance trends over time The underlying data will primarily be available through *BigQuery*. ### 2. YouTube Analytics Dashboard Develop a dashboard for tracking and analyzing YouTube channel performance. This may include metrics such as: * Views and watch time * Unique/active viewers * Returning viewers * Subscriber trends * Engagement metrics * Video/content performance * Audience trends * Performance over different time periods The consultant should be able to help us structure the data appropriately and create an intuitive reporting experience in Looker Studio. ## Responsibilities * Understand existing datasets and reporting requirements * Create the required data models, calculated fields and metrics * Create the automated data flow/path for the final data * Build clean, professional and user-friendly dashboards * Create filters and drill-downs for different campaigns, creators, platforms and time periods * Validate dashboard numbers against source data * Work closely with our analytics team to incorporate feedback and iterations * Document the dashboard logic and key calculations ## Required Experience We are specifically looking for someone with hands-on experience in: * *Google Looker Studio / Google Data Studio* * *Google BigQuery* * *SQL* * Dashboard development and data visualization * Building dashboards using large or complex datasets * Creating calculated metrics, filters and interactive reporting * Data validation and troubleshooting Experience with *YouTube Analytics, social media analytics, influencer/creator analytics, or digital marketing dashboards* would be a strong advantage. ## Engagement * *Consultant / Freelancer* * *Immediate start* * Initial engagement focused on the two dashboards described above * Potential for additional dashboard and analytics projects ## When Applying Please share: 1. Examples of *Looker Studio dashboards* you have personally built 2. Your experience working with *BigQuery* 3. Any dashboards you have built for *YouTube, social media, influencer marketing, or digital marketing analytics* 4. Your availability to *start immediately* 5. Your expected hourly rate or project-based fee Please do not send only a generic profile. We would like to see examples of relevant dashboard work and understand your specific experience with *Looker Studio + BigQuery*.