Retail Data Analyst

Techdynamics OPC; Philippines; On-site; PHP 420,000 - 660,000; Full time

Benefits offered by this job

Employee Discount

Sick Leave

Vacation Leave

Wedding Leave

Job summary

Techdynamics OPC seeks a data analytics professional to manage comprehensive retail data processing, validation, and cross-channel aggregation. You will build multi-dimensional analyses using Pivot Tables, Power Query, and Power Pivot to generate automated weekly and monthly reports.

You will develop BI dashboards, enable real-time visualizations, and provide data-driven insights to support management decisions. Fluency in English and strong attention to detail are essential.

Qualifications

• 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
• 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 build dynamic dashboards and reporting templates
• Fluent in English (written and spoken) and strong analytical skills

Responsibilities

• Full Data Processing & Management: handle data processing, validation, and aggregation across channels
• Advanced Excel Data Processing: perform multi-dimensional analysis and automate weekly/monthly reports
• BI Visualization & Dashboard Development: enable real-time visualization and dashboards
• Professional PPT Reporting: prepare weekly, monthly, and quarterly reports and presentations
• Retail Special Analysis: analyze new product sales, competition, store productivity, and insights
• Cross-Department Data Coordination: coordinate with retail platform, training, display, and KA/ARS teams

Skills

Advanced Excel

Power BI

SQL Data Processing

Data Visualization

Data Modeling

Data Quality Assurance

Education

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

Tools

Power Query

Power Pivot

Excel Pivot Tables

DAX

Job description

Job Description

Government Mandated Benefits

Employee Discount

Sick Leave, Vacation Leave, Wedding Leave

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
   • 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:
     • Channel performance analysis
     • Issue tracking and resolution
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
   • 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:
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

Data Analysis Analytical Skills SQL Data Processing Business Data Analysis Data Monitoring Marketing Analysis Data Reporting Excel PPT