Social Analytics & AI Insights 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 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.