Sales Analyst - Power Query and Power BI (Sales Department/ Manufacturing)
1 month ago
Work closely with Regional Sales Controller
Prepare sales performance analyses, considering key accounts and customers.
Collaborate with sales,..
- Work closely with Regional Sales Controller
- Prepare sales performance analyses, considering key accounts and customers.
- Collaborate with sales, marketing, and supply chain functions to develop monthly sales forecasts.
- Oversee the submission of sales forecasts to regional management through the business planning process, working with Sales, Business Partners, Marketing, and Supply Chain.
- Monitor year-to-date sales against forecasts and budget.
- Assist the Sales Department in preparing Minimum Purchase Agreements and tracking distributor performance.
- Review product gross profit drivers on a monthly basis and do presentation to management
- Submit various reports to management
- Support the Regional Sales Controller in reviewing market data provided by marketing for transfer pricing calculations
- Review all sales quotations, ensuring sales revenue, gross profits, and market-level pricing are reasonable, along with assumptions made by sales personnel.
- Analyze instances where quote values fall below floor prices and determine the cause.
- Calculate appropriate floor prices that align with management’s objectives of improving gross profits while expanding market share.
- Provide support to the local sales team by monitoring tender websites, managing sponsorship payments, verifying sales quotations, resolving order-related issues, and assisting with contract monitoring and updates.
- Calculate sales incentives according to the Company Sales Incentive Plan Policy, and handle the preparation of pro forma invoices and sales commission calculations.
- Track tender progress through various stages until sales are realized.
- Handle regional sales administration tasks such as product and price announcements, spare part price inquiries, and brochure requests.
Requirement:
- Diploma / Degree in any fields
- Candidate with experience in revenue data analysis
- Proficient in Power BI, Power Query
Interested candidates who wish to apply for the advertised position, please click on the APPLY button and send resume to [email protected]
EA License No: 13C6305
Reg. No.: R1985956
For candidate who applied for the advertised position is deemed to have consented to us that we may collect, use or disclose your personal information for purpose in connection with the services provided by us.
Official account of Jobstore.