Data Analyst Junior

Ogilvy Chile; Santiago; Presencial; CLP 20.088.000 - 35.712.000; Jornada completa

Descripción de la vacante

Ogilvy Chile is seeking a Social Media Data Analyst to act as the data guru across 13+ Nestlé brands, driving decisions with actionable insights. You will blend traditional social analytics with AI tools in a fast-paced agency setting and tell strategic stories with numbers.

You will lead dashboards, reports, and social listening, collaborating with Strategy, Creative, and client teams to optimize performance and reporting quality.

Formación

• Knowledge of Sprinklr.
• Experience with Meta Business Suite for account management and data extraction.
• Intermediate knowledge in Power BI and Looker Studio.
• Basic understanding of Google Analytics and CreatorIQ.

Responsabilidades

• Generate data-driven insights to fuel strategic decisions across 13+ client brands.
• Develop, automate, and present social media reports for organic and paid performance.
• Build end-to-end dashboards for real-time KPI tracking for PMs and clients.
• Conduct deep-dive social listening and competitive benchmarking.
• Translate data into content guidelines and performance efficiencies for creative teams.
• Pioneer AI capabilities by building and maintaining brand-specific AI agents in the Open Hub.
• Integrate Generative AI into daily workflow to automate reporting and elevate presentations.
• Coordinate with the client’s internal Data team and manage platform permissions with compliance.

Conocimientos

Data storytelling

Collaborative

Proactive mindset

Strategic thinking

Herramientas

Power BI

Looker Studio

Sprinklr

Meta Business Suite

Descripción del empleo

We are on the hunt for a brilliant Social Media Data Analyst to join our team and work closely with our Strategy & Planning crew. In this role, you will be the ultimate data guru for over 13 Nestlé brands, driving decisions through actionable insights. We are looking for an experienced, tech-savvy professional who isn’t just obsessed with numbers, but who knows how to tell a compelling strategic story with them. If you are an innovator who loves blending traditional social analytics with cutting-edge AI tools in a fast-paced, creative agency environment, this is your playground.

What you’ll do

• Lead the generation of data-driven insights to fuel strategic decision-making across +13 client brands.
• Develop, automate, and present comprehensive social media reports (unifying both organic and paid performance) across weekly, monthly, quarterly, and annual timeframes.
• Build and manage end-to-end custom dashboards for real-time tracking of KPIs, ensuring Project Managers and clients have a clear view of performance.
• Execute deep-dive social listening and competitive benchmarking to uncover actionable strategic insights.
• Translate complex data into concrete content guidelines and performance efficiencies for our creative teams.
• Pioneer our AI capabilities by building, maintaining, and optimizing brand-specific AI agents within the WPP Open Hub (including data optimization, prompt engineering, and guardrail setup).
• Seamlessly integrate Generative AI (Microsoft Copilot, Claude Opus) into your daily workflow to automate reporting, process data, and elevate client presentations.
• Act as the main point of contact with the client’s internal Data team, managing platform permissions and strictly ensuring compliance protocols (especially regarding external app connections).

What you’ll need

• Knowledge of Sprinklr.
• Some experienc with Meta Business Suite for account management and data extraction.
• Intermediate knowledge in tools like Power BI and Looker Studio.
• Basic understanding of Google Analytics and creator/influencer platforms like Creators IQ.
• A highly collaborative, proactive mindset, ready to work seamlessly with Strategy, Creative, and client teams.