Social & Media Analytics Consultant

C5i; Ciudad de México; On-site; MXN 450,000 - 750,000; Full time

Job summary

C5i is seeking a data analytics professional to build and manage its social data framework, aligning analytics with client social media goals. You will lead analyses, segmentation, and reporting across paid and organic initiatives, leveraging social listening and LLM-powered dashboards to drive decision-making.

Strong SQL, Excel, and Power BI skills are required, along with experience using Claude for structured analysis. English communication is essential; Spanish is a strong plus.

Responsibilities

• Build and execute the social data framework to align with client’s social media goals.
• Oversee deep-dive performance analyses, audience segmentation, and analyze paid and organic initiatives.
• Leverage social listening tools to track brand sentiment, crisis management, and market trends.
• Build executive-level reports/dashboards using LLMs and visualization software to report KPIs.
• Identify effective content formats, messaging and product demonstrations; assess influence on discovery and consideration.
• Coordinate geo-lift and controlled incrementality tests across paid media and LATAM markets.
• Interpret MMM contributions, response curves, saturation and uncertainty; integrate credible test findings with agency partners.
• Interpret MTA alongside MMM and incrementality evidence, acknowledging each method’s limitations.

Skills

SQL

Excel

Power BI

English communication

Analytical thinking

Tools

Claude

Job description

C5i is a pure-play AI & Analytics provider that combines the power of human perspective with AI technology to deliver trustworthy intelligence. The company drives value through a comprehensive solution set, integrating multifunctional teams that have technical and business domain expertise with a robust suite of products, solutions, and accelerators tailored for various horizontal and industry-specific use cases. At the core, C5i’s focus is to deliver business impact at speed and scale by driving adoption of AI-assisted decision-making.

C5i caters to some of the world’s largest enterprises, including many Fortune 500 companies. The company’s clients span Technology, Media, and Telecom (TMT), Pharma & Lifesciences, CPG, Retail, Banking, and other sectors. C5i has been recognized by leading industry analysts like Gartner and Forrester for its Analytics and AI capabilities and proprietary AI-based platforms.

Global offices

United States| Canada | United Kingdom| United Arab of Emirates| India

Overview

Key Responsibilities

• Build and execute the social data framework to align with client’s social media goals.
• Oversee deep-dive performance analyses, audience segmentation, and analyze the paid and organic initiatives
• Leverage social listening tools to track brand sentiment, crisis management, and emerging market trends.
• Build executive-level reports/dashboard using LLMs/ visualization software to report on key performance indicators (KPIs)
• Identify effective content formats, messaging and product demonstrations; assess influence on discovery and consideration.
• Coordinate geo-lift and controlled incrementality tests across paid media and LATAM markets.
• Interpret MMM contributions, response curves, saturation and uncertainty; integrate credible test findings with agency partners
• Interpret MTA alongside MMM and incrementality evidence, acknowledging each method’s limitations.
• Adapt recommendations to local market behavior; maintain KPI consistency, data quality and executive-ready communication.

Technical & AI Capabilities

• Proficiency in SQL, Excel and Power BI
• Hands-on familiarity with Claude for structured analysis, reusable prompts, reporting and scenario prototypes.
• Strong commercial judgment, analytical storytelling and agency/stakeholder management.
• Ability to work Mexico City business hours; strong English communication, with Spanish strongly preferred.