Media Insights Analyst at Pixability in Boston, MA

Summary: Pixability is a video technology and data company that empowers brands to optimize their media campaigns on platforms like YouTube. The Media Insights Analyst will extract and analyze data to develop client-facing reports and actionable insights, supporting media decision-making and performance improvements. Responsibilities: - Serve as the team's Google sheets expert while developing deep expertise in our business intelligence platform, Looker - Ensure all campaign and performance data is accurate, complete, and fully QA'd within the Looker data layer - Build Google sheets reports and Looker dashboards that help internal teams and clients understand campaign performance and relevant industry trends - Analyze campaign and industry data to identify trends, uncover insights, and translate findings into clear data-driven narratives - Support data analysis and presentation development for Quarterly Business Reviews and client end-of-campaign wrap-up reports - Partner with the Account Management team to prioritize reporting needs, clearly communicate requirements, and deliver insights on deadline - Troubleshoot complex campaign scenarios and develop custom reporting solutions using Google sheets and Looker - Partner with Product teams to design and develop new dashboards and reporting capabilities - Utilize Looker to analyze the competitive YouTube landscape and develop client-facing Google Slides presentations , enabling internal stakeholders such as Sales and Account Management to effectively communicate insights Required Qualifications: - 1+ years of experience working with data analytics, marketing analytics, ad agencies or ad tech - Experience in data analytics and report generation is a must - Proficiency in Microsoft Excel/Google Sheets and Powerpoint/Google Slides - Serve as the team's Google sheets expert while developing deep expertise in our business intelligence platform, Looker - Ensure all campaign and performance data is accurate, complete, and fully QA'd within the Looker data layer - Build Google sheets reports and Looker dashboards that help internal teams and clients understand campaign performance and relevant industry trends - Analyze campaign and industry data to identify trends, uncover insights, and translate findings into clear data-driven narratives - Support data analysis and presentation development for Quarterly Business Reviews and client end-of-campaign wrap-up reports - Partner with the Account Management team to prioritize reporting needs, clearly communicate requirements, and deliver insights on deadline - Troubleshoot complex campaign scenarios and develop custom reporting solutions using Google sheets and Looker - Partner with Product teams to design and develop new dashboards and reporting capabilities - Utilize Looker to analyze the competitive YouTube landscape and develop client-facing Google Slides presentations, enabling internal stakeholders such as Sales and Account Management to effectively communicate insights Preferred Qualifications: - Looker is a huge plus, proficiency in a similar BI tool (Tableau etc) considered - Experience in Google Adwords, or ad tech platforms is a plus - Past agency experience or proven knowledge of digital advertising is a plus Required Skills: Data analytics, Google Sheets, Looker Important Skills: Report generation, Google Slides Nice-to-Have Skills: Digital advertising, Microsoft Excel, PowerPoint, Google Adwords, Project management Benefits: Potential bonus opportunity, Equity