Data Quality Analyst (Fixed term contract) at Makro PRO
Bangkok, , Thailand -
Full Time


Start Date

Immediate

Expiry Date

02 Jun, 26

Salary

0.0

Posted On

04 Mar, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

No

Skills

Advanced Excel, XLOOKUP, INDEX-MATCH, Pivot Tables, Data Validation, Power Query, Data Cleaning, Reconciliation, SQL, Python, Pandas, HTML, CSS, VBA, Macros, Attention to Detail

Industry

Software Development

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 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.
Responsibilities
The role involves performing daily data audits, cross-checking internal pricing against competitor data, and identifying discrepancies in matching, conversions, and promotions to ensure data accuracy for pricing decisions. Responsibilities also include cleaning data issues like incorrect SKUs or outlier prices and analyzing pricing gaps versus competitors.
Loading...