Key Responsibilities
- 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
- 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
- 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
- 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
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
- 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
Bachelors 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
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
- 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
- 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
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
