Retail Data Analyst

Key Responsibilities

1. Full Data Processing & Management

• Handle full-process retail data processing and validation

• Conduct weekly data collection and checking for sales, activation, inventory, PSI, exhibition, and competitor product suppression ratio

• Aggregate KA channel data and ensure unified data standards

• Perform abnormal data troubleshooting and root cause analysis

• Ensure data accuracy, completeness, and consistency

2. Advanced Excel Data Processing

• Perform multi-dimensional analysis using Pivot Tables, advanced formulas, Power Query, and data models

• Generate automated weekly and monthly reports

• Produce store rankings, achievement rates, year-on-year comparisons, and anomaly warnings

• Build dynamic dashboards and automated reporting tools

3. BI Visualization & Dashboard Development

• Build Power BI retail dashboards (performance, store monitoring, product display, personnel, competitor analysis)

• Enable automatic data refresh and chart linkage

• Create store penetration and performance monitoring tools

• Support management decision-making through real-time visualization

4. Professional PPT Reporting

• Independently prepare high-quality weekly, monthly, and quarterly retail reports

• Create logical, visually structured business presentations

• Prepare standard reports including:

• Target achievement

• Channel performance analysis

• Product structure analysis

• Issue tracking and resolution

• Next month action plans

5. Retail Special Analysis

• Conduct new product sales analysis

• Perform competitive analysis for OQ / panoramic camera products

• Analyze store productivity, manpower efficiency, and display efficiency

• Translate data into actionable business recommendations

• Provide insights to support business decisions, not just reporting

6. Cross-Department Data Coordination

• Work closely with retail platform, training team, display team, and KA/ARS teams

• Provide data support across departments

• Coordinate with headquarters for reporting requirements

• Ensure accurate, timely, and compliant data submission

Job Qualifications

1. Education & Experience

• Bachelor’s degree or above in Business, Analytics, IT, or related field

• 1-3 years experience in retail, channel, or sales data analysis

• Experience in consumer electronics, 3C, appliances, or retail operations preferr

2. Excel Skills (Advanced)

• Strong proficiency in Pivot Tables, charts, and advanced formulas (VLOOKUP, XLOOKUP, IFS, SUMIFS)

• Experience using Power Query for data cleaning

• Experience using Power Pivot for data modeling

• Ability to perform multi-table merging and automated report creation

• Able to build dynamic dashboards and reporting templates

3. Power BI Skills (Required)

• Experience in data import, cleaning, and modeling

• Knowledge of DAX expressions

• Strong dashboard and visualization design skills

• Ability to independently build:

• Retail performance dashboards

• Channel monitoring dashboards

• Store performance dashboards

4. PowerPoint Skills (Advanced)

• Ability to create professional business-level presentations

• Strong data storytelling and visualization skills

• Able to convert data into insights, strategies, and action plans

• Experience preparing management or headquarters-level reports

5. Language & Soft Skills

• Fluent in English (written and spoken)

• Strong analytical and problem-solving skills

• High attention to detail and data accuracy

• Ability to work under pressure and meet deadlines

• Strong accountability and data sensitivity

Preferred Qualifications

• Knowledge of drone, imaging, or power products

• Familiarity with Philippine KA and retail channels

• Experience with PSI, retail terminal data, and display analytics

• Experience in competitor analysis and retail performance tracking