Retail Media Data Ops Analyst — From Data to Insights

Omni-Channel BPO, Inc; Pasig; On-site; PHP 360,000 - 600,000; Full time

Job summary

Omni Channel Solutions is seeking a Retail Media Data Operations Analyst to transform fragmented reports from retail media networks, partners, and measurement providers into standardized, validated datasets for analysis.

You will own the data preparation lifecycle, perform quality checks, and collaborate with BI and cross-functional teams to support scalable, governed data pipelines and actionable client storytelling.

Qualifications

• Bachelor's degree in Business, Marketing, Economics, Statistics, Data Analytics, or related field.
• 1-3 years of analytics, category management, eCommerce, or shopper insights experience, preferably in the CPG or retail industry.
• Strong proficiency in Microsoft Excel (pivot tables, advanced formulas) and PowerPoint; experience with Power BI or other visualization tools is a strong plus.
• Familiarity with syndicated data sources (NielsenIQ, Circana), retailer POS data, and digital shelf analytics tools.
• Strong analytical thinking, problem-solving, and attention to detail.
• Excellent verbal and written communication skills; able to present data clearly to non-technical stakeholders.
• Demonstrated ability to manage multiple projects under tight deadlines.
• Collaborative, proactive, and results-driven work ethic.

Responsibilities

• Maintain a centralized inventory of required campaign, retailer, media partner, and measurement reporting, including schedules, missing inputs, and processing status.
• Collect and organize reporting from partner portals, shared locations, emails, APIs, and other sources using established structures and version controls.
• Consolidate reporting from spreadsheets, flat files, PDFs, presentations, and self-service platforms into standardized templates and analysis-ready datasets.
• Normalize naming conventions and map partner metrics to enterprise definitions.
• Reconcile hierarchies to ensure consistent reporting across data sources.
• Perform completeness, accuracy, duplication, reasonableness, and reconciliation checks before release for analysis.
• Validate spend, impressions, clicks, sales, ROAS, and other metrics against source totals and plans.
• Identify anomalies, missing dimensions, and data-quality issues; maintain an exception log.
• Document data transformations, rules, and quality checks for reproducibility.
• Develop reusable templates, mapping tables, validation routines, checklists, and SOPs to improve consistency.
• Identify manual activities for automation and translate processes into requirements for BI and data engineering.
• Collaborate with BI and data engineering to test automated ingestion, transformation, validation, and exception-management workflows.
• Coordinate with Retail Media and Shopper Marketing teams to meet downstream analysis needs.
• Participate in partner onboarding and reporting discussions, communicating status, risks, and dependencies.

Skills

Excel (Pivot)

PowerPoint

Power BI

SQL basics

Data quality

Analytical thinking

Communication

Project management

Education

Bachelor's degree in Business, Marketing, Economics, Statistics, Data Analytics, or related field

Tools

Power BI

SQL

Circana

NielsenIQ

Job description

Omni Channel Solutions is seeking a Retail Media Data Operations Analyst to transform fragmented reports from retail media networks, partners, and measurement providers into standardized, validated datasets for analysis.

You will own the data preparation lifecycle, perform quality checks, and collaborate with BI and cross-functional teams to support scalable, governed data pipelines and actionable client storytelling.