Retail Data Analyst: Real-Time Dashboards & Insights

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

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.