Retail Data Analyst

techdynamics opc

1-3 Years

Philippines, Taguig

Early Applicant

Posted 2 months ago
Be among the first 10 applicants

Job Description

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
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
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

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
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
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
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