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.
