Monitor real-time sales data from distributors & retailers using Power BI dashboards.
Identify sales trends, repeat purchase rates, and retailer engagement to optimize distribution strategies.
Provide daily/weekly sales reports to Area Sales Managers & leadership.
Analyze data product-wise, area-wise, sales team-wise, expenditure-wise and establish cross relationships to aid decision making.
2️. Cost Tracking & Cost Card Analysis
Track expenses across production, distribution, and operations using Power BI.
Create cost cards per product to monitor per-bottle costs.
Analyze cost fluctuations in ENA, packaging, transportation, and other cost centers.
Provide alerts if raw material costs increase, helping in pricing strategy adjustments.
3️. Field Visit & GPS Tracking
Implement Power BI maps to track field visits based on geolocation data from sales reps.
Ensure route optimization for sales & distributor deliveries using Power BI & Google Maps API.
Verify retailer visits using GPS camera photos and track coverage in low-performing areas.
4️. Power BI & Business Intelligence Implementation
Automate data collection from VAT bills, distributor invoices, and field sales reports.
Use Power BI, SQL, and Excel automation to replace manual WhatsApp reports.
Set up automated alerts for sales trends, underperforming areas, and cost increases.
Job Specification
Key Skills & Requirements
Power BI (MUST) – Advanced dashboard creation, real-time data visualization, and automated reporting.
Data Analytics & SQL – Ability to handle large datasets, write queries, and create interactive reports.
Cost Tracking & Financial Analysis – Experience in cost-per-product tracking and business finance insights.
Automation & BI Tools – Knowledge of Power Automate, Google Data Studio, or other BI tools.
FMCG / Liquor Industry Experience (Preferred) – Understanding of sales cycles, distributor networks, and pricing models.
Critical Thinking & Problem-Solving – Ability to convert raw data into actionable business insights.
Qualifications
Bachelor's or Master's degree in a relevant field like statistics, mathematics, computer science, or a related discipline
1 - 2 years Data Analysis experience
This Job is expired. The Company is no longer accepting applications for this position.
Organization Summary
Natural Spirits Nepal, headquartered in Handigaon-05, Kathmandu, is a liquor manufacturing company operating a dedicated production facility in Dhading. The company currently manufactures and markets the following products:
