Data Quality Analyst (Fixed term contract)
atCP Axtra PCL (Lotus's)Data Quality Analyst (Fixed term contract)
> CP Axtra
- Bangkok, Thailand
Workplace: on_site
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.
Apply
[Apply at CP Axtra](https://apply.workable.com/joinmakropro/j/4C5980ABD8/apply)
Experience required
- any or no experience
Career level
- Middle Level
Salary
- Negotiable
Job function
- Analyst
- Quality Assurance
Job type
- Full-time
Company overview
Lotus's operates in Thailand as an omni-channel retailer. It sets out to bring shoppers well-made products at reasonable prices, while contributing positively to customers, colleagues and communities. Customers are reached through over 2,000 stores across Thailand and t ...
Why join us: “At Lotus's, we are looking for people who are the change-agent with a passion to grow in both work and life. People who have the ability to think in an agile way and make everyday as a history to leave their own legacy in every part of business.” Lotus's People are: People wh ...

