Retail Data Analyst

Techdynamics OPC; Taguig; On-site; PHP 279,000 - 390,600; Full time

Job summary

A leading technology firm in Metro Manila is seeking a dedicated Data Analyst to focus on retail data processing and management. The successful candidate will utilize advanced Excel and Power BI skills to generate insight-driven reports and dashboards, ensuring data accuracy and compliance across departments. A bachelor’s degree in a relevant field and 1 to 3 years of experience in retail analysis are required. The role demands strong analytical abilities and effective communication in English.

Qualifications

• 1-3 years experience in retail, channel, or sales data analysis.
• Experience in consumer electronics, 3C, appliances, or retail operations preferred.
• Fluent in English (written and spoken).

Responsibilities

• Handle full-process retail data processing and validation.
• Conduct weekly data collection for sales and inventory.
• Build Power BI retail dashboards for performance monitoring.

Skills

Advanced Excel proficiency

Power BI dashboard creation

Data storytelling

Analytical skills

Problem-solving skills

Education

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

Tools

Power BI

Excel

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, and 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 and 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 preferred.
• 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.
• 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.