Job Description

Data Audit & Validation

• Perform daily cross-checks between internal pricing data and scraped competitor prices.

• Identify discrepancies in product matching, unit conversions, and promotional mechanics.

• Ensure data accuracy before it is used for pricing decisions.

Data Quality & Cleaning

• Detect and correct data issues such as incorrect SKU mappings, unit mismatches, outlier prices, and scraper errors.

• Maintain clear product matching and validation standards.

Competitive Gap Analysis

• Analyze pricing gaps versus competitors and highlight significant deviations.

• Summarize key findings and trends for management review.

Process Improvement

• Develop Excel-based or simple script-based tools to streamline comparisons.

• Improve audit efficiency and support enhancements to scraper accuracy.

Cross-Functional Collaboration

• Work with the tech team to resolve scraping issues and validate mapping

Requirements

Technical Skills

• Advanced Excel skills (XLOOKUP/INDEX-MATCH, Pivot Tables, Data Validation; Power Query is a plus).

• Strong data cleaning and reconciliation ability.

• Basic SQL or Python (Pandas) is a plus.

• Understanding of HTML/CSS or VBA/Macros is a plus.

Core Competencies

• Exceptional attention to detail.

• Strong analytical and problem-solving mindset.

• Process-driven and able to maintain high accuracy in repetitive audits.