Sobre

We are seeking a true technical Data Rockstar who eats, sleeps, and breathes numbers and social media. This is not a typical analyst role. We need someone with a strong technical background who is also sharp enough to intuitively recognize emerging social media trends across Instagram, TikTok, and other key platforms. Your core responsibility is to go beyond surface-level analytics. You will be responsible for wrangling and consolidating data from various sources (potentially through APIs) and mastering it within Google Sheets or Excel. The ultimate goal is to build and maintain robust KPI dashboards that provide clear, actionable insights to our high-profile creators and influencers. Your analysis will be the engine that helps them replicate successful content strategies, increase engagement, and maximize growth. If you are a technical expert who loves data and is obsessed with what makes content go viral, we want to hear from you. Key Responsibilities & Deliverables Build & Maintain KPI Dashboards: Design, build, and manage comprehensive dashboards in Google Sheets or Excel to track content performance, engagement metrics, and creator growth. Data Wrangling & Integration: Proactively pull, clean, and merge data from diverse sources (including platform analytics, third-party tools, and APIs) to create a unified view of performance. Viral Trend Analysis: Proactively hunt and identify viral content, sounds, and emerging trends on Instagram, TikTok, and other relevant platforms. Deliver Actionable Insights: Translate complex data into clear, actionable insights and strategic recommendations. You won't just report the numbers; you'll explain why they matter. Weekly Reporting: Create and deliver weekly KPI reports and trend analyses to our top-tier influencers and creators, helping them understand why specific content goes viral and how to replicate its success. Required Skills Expert-level proficiency in Google Sheets and/or Excel (pivot tables, complex formulas, data visualization, VLOOKUP/INDEX(MATCH), etc.). Proven experience in building and managing KPI dashboards from scratch. Strong technical ability to wrangle and clean data from multiple sources. Demonstrable experience with using APIs to pull data is a major plus. A deep, intuitive understanding of the social media landscape (specifically TikTok and Instagram Reels). Ability to work independently and communicate complex data findings in a simple, clear way.