Reporting & Insights - Specialist (Bengaluru)

Reporting & Insights - Specialist (Bengaluru)

17 Nov
|
Annalect, Omnicom Media Group India Private
|
Bengaluru

17 Nov

Annalect, Omnicom Media Group India Private

Bengaluru

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 qualified 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

📌 Reporting & Insights - Specialist (Bengaluru)
🏢 Annalect, Omnicom Media Group India Private
📍 Bengaluru

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: reporting & insights - specialist (bengaluru) / bengaluru

Subscribe to this job alert:

Get the latest job offers by email for: reporting & insights - specialist (bengaluru) / bengaluru