Retail Data Operations & Insights Analyst

Omni Channel Solutions; Pasig; On-site; PHP 400,000 - 650,000; Full time

Job summary

Omni Channel Solutions is seeking a Retail Media Data Operations Analyst to transform fragmented reporting into standardized, analysis-ready datasets. You will bridge reporting from retail media networks, partners, retailers, and providers with BI and client analytics to enable performance insights.

The role covers end-to-end data preparation, from intake and validation to documentation, automation opportunities, and scalable pipelines.

Qualifications

• Bachelor's degree in Business, Marketing, Economics, Statistics, Data Analytics, or a related field.
• 1–3 years of analytics/retail-related experience, preferably in CPG or retail.
• Strong Excel and PowerPoint; Power BI or visualization tools a plus.
• Familiarity with syndicated data sources (NielsenIQ, Circana) and POS data.
• Basic understanding of category management, retail media performance, and omnichannel shopper behavior.
• Strong analytical thinking, problem-solving, and attention to detail.
• Excellent verbal and written communication; ability to present data clearly.
• Ability to manage multiple projects under tight deadlines.
• Collaborative, proactive, and results-driven work ethic.

Responsibilities

• Maintain a centralized inventory of campaign, retailer, media-partner, and measurement reporting with schedules and status.
• Collect and organize reporting from partner portals, emails, APIs, and shared locations using established folder structures and naming conventions.
• Consolidate reports from spreadsheets, PDFs, and self-service platforms into standardized templates.
• Normalize naming conventions and map metrics to enterprise definitions.
• Reconcile hierarchies across data sources for consistent reporting.
• Perform completeness, accuracy, duplication, and reconciliation checks before release.
• Validate spend, impressions, clicks, sales, ROAS, and other metrics against source data.
• Identify data-quality issues and maintain an exception log with owners and resolutions.
• Document data transformations and business rules for reproducibility.
• Develop reusable templates, mappings, and SOPs to improve consistency.
• Identify manual activities for automation and translate to documented requirements.
• Partner with BI and data engineering to test automated ingestion and validation workflows.
• Collaborate with Retail Media and Shopper Marketing for downstream reporting needs.
• Participate in onboarding and reporting discussions, communicating risks and dependencies.

Skills

Excel

PowerPoint

Power BI

SQL

Analytical thinking

Communication

Project management

Collaboration

Data analytics

Syndicated data

Education

Bachelor's degree

Tools

Power BI

SQL

Excel

ETL tools

Job description

Omni Channel Solutions is seeking a Retail Media Data Operations Analyst to transform fragmented reporting into standardized, analysis-ready datasets. You will bridge reporting from retail media networks, partners, retailers, and providers with BI and client analytics to enable performance insights.

The role covers end-to-end data preparation, from intake and validation to documentation, automation opportunities, and scalable pipelines.