Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Omnicom Global Solutions

Open 0d

Reporting & Insights - Specialist

Posted Updated

Description

Overview

About Omnicom Global Solutions

Omnicom Global Solutions (OGS) is Omnicom's integrated solutions engine, bringing together a global talent community and connected capabilities to build adaptive, future-ready solutions.

As an integral part of Omnicom, the world's leading marketing and sales company, OGS helps agencies and clients navigate what's next through expertise spanning Media, Data & Analytics, Technology, Creative, Strategy & Insights, MarTech, Commerce, Healthcare, and Business Support Solutions.

With over 8,000 professionals across India, the Philippines, and Colombia, and a growing global footprint, OGS combines deep domain expertise with scaled delivery to drive innovation, accelerate growth, and create meaningful business impact.

At OGS, the future is tested, built, and scaled every day for some of the world's most ambitious agencies, brands, and clients.

Let’s build what’s next.

Responsibilities
  • Data Collection & Export Management

  • Extract data from 10+ media and digital performance sources (Google Analytics, Toluna, Facebook, Instagram, YouTube, Tiktok, Sprout, Circana, and other reporting platforms)

  • Export data according to specified date ranges and parameters; verify data completeness and accuracy

  • Clean and format exported data by removing metadata, standardizing naming conventions, and organizing files into designated folders

  • Data Processing & Transformation

  • Execute Python scripts to consolidate data from different platforms (e.g., Channels.py, Landing Pages.py, Facebook Pages Combine.py, Instagram Combine.py)

  • Validate that required data columns are present and correctly named after script execution

  • Troubleshoot script failures and adjust file paths and parameters as needed

  • Create and maintain CSV and Excel files with proper naming conventions and folder structure

  • Clean and standardize survey data to ensure consistent formatting (waves, questions, segments, percentages)

  • Convert wide-format tables to long-format as needed for database optimization

  • Validate data quality and completeness before migration
Qualifications
  • Tableau proficiency: data setup, dashboard design, calculated fields, parameters, and filters

  • Knowledge of Python scripting (ability to modify and execute scripts)

  • Excel skills including formulas, pivot tables, and data consolidation

  • Strong attention to detail and data accuracy

  • Experience with data cleaning, standardization, and validation

  • Understanding of data structures (tables, relationships, field types)

  • CSV file management and data formatting expertise

Tools & Platforms (Required)

  • Tableau (minimum 5+ years of professional experience)

  • Media and performance data (general knowledge of media and marketing performance)

  • Airtable (required or strong willingness to learn)

  • Python (Hands on experience)

  • Microsoft Excel and Office Suite

Skills

Apply

See also