Sales Force Effectiveness Manager

Otsuka; Indonesia; On-site; IDR 450,000,000 - 700,000,000; Full time

Job summary

Otsuka Indonesia is seeking a Sales Force Effectiveness Manager to drive growth through data-driven decision making. This role analyzes sales performance, builds insights, automates reporting, and offers strategic recommendations to management.

You will collaborate with Sales, Marketing, Finance, and Management to enhance performance using advanced analytics and digital solutions. Leadership, automation, and continuous improvement are key.

Qualifications

• Bachelor's Degree in Statistics, Mathematics, Industrial Engineering, Information Systems, Computer Science, Business Analytics, or related disciplines.
• Minimum 5 years of experience in Sales Analytics, Business Intelligence, Commercial Excellence, or Sales Planning.
• Minimum 2 years of managerial experience.
• Strong analytical thinking and problem-solving skills.
• Proven leadership capabilities in managing projects and teams effectively.
• Excellent communication and presentation abilities.

Responsibilities

• Analyze sales data to identify trends and provide insights for sales strategy development.
• Develop executive dashboards and business reports for management.
• Collaborate with sales leadership to create accurate sales forecasts and facilitate business planning.
• Implement advanced data analytics techniques to improve sales processes and outcomes.
• Utilize data visualization tools to present findings and recommendations to stakeholders.
• Design and automate reporting systems using Excel VBA, Power BI, SQL, and other analytical tools.
• Drive initiatives for process automation and digital transformation within the sales organization.
• Provide training and support to team members on tools and best practices in sales analytics.
• Collaborate with cross-functional teams to improve data quality and business processes.

Skills

Sales analytics

Executive dashboards

Forecasting

KPI management

Data technology

Excel VBA / Macros

Power BI / Tableau

SQL

Python

Education

Bachelor's Degree in Statistics / Mathematics / Industrial Engineering / Information Systems / Computer Science / Business Analytics or related

Tools

Excel VBA

Power Query

Power Pivot

SQL

Power BI

Tableau

Job description

Job Overview

The Sales Force Effectiveness Manager plays a crucial role in driving business growth through data-driven decision making. This position is responsible for analyzing sales performance, developing business insights, automating reporting processes, and providing strategic recommendations to management. This managerial position involves leveraging analytics and technology to optimize sales performance, ensuring the achievement of business objectives while fostering a culture of continuous improvement.

You will work closely with Sales, Marketing, Finance, and Management to improve business performance through advanced analytics and digital solutions.

Roles and Responsibilities

• - Analyze sales data to identify trends and provide insights for sales strategy development.
• - Develop executive dashboards and business reports for management.
• - Collaborate with sales leadership to create accurate sales forecasts and facilitate business planning.
• - Implement advanced data analytics techniques to improve sales processes and outcomes.
• - Utilize data visualization tools to present findings and recommendations to stakeholders.
• - Design and automate reporting systems using Excel VBA, Power BI, SQL, and other analytical tools.
• - Drive initiatives for process automation and digital transformation within the sales organization.
• - Provide training and support to team members on tools and best practices in sales analytics.
• - Collaborate with cross-functional teams to improve data quality and business processes.

Key Qualifications

• - Bachelor's Degree in Statistics, Mathematics, Industrial Engineering, Information Systems, Computer Science, Business Analytics, or related disciplines.
• - Minimum 5 years of experience in Sales Analytics, Business Intelligence, Commercial Excellence, or Sales Planning.
• - Minimum 2 years of managerial experience.
• - Strong analytical thinking and problem-solving skills.
• - Proven leadership capabilities in managing projects and teams effectively.
• - Excellent communication and presentation abilities.

Required Experience

At least 5 years of experience in sales analytics or a related field, with a demonstrated track record of enhancing sales effectiveness through data-driven strategies and technology utilization.

Required Skills and Competencies

• - Business Analytics and Sales Performance Analysis
• - Forecasting and KPI Management
• - Business Planning and Data Technology
• - Advanced proficiency in Microsoft Excel, including Excel VBA and Macros
• - Proficient in Power Query and Power Pivot
• - Experience with SQL and data manipulation
• - Familiarity with Power BI and Tableau for data visualization
• - Basic knowledge of Python for data analysis purposes

Additional Requirements

• - Preferred digital mindset and familiarity with productivity tools.
• - Experience in process automation and Business Intelligence technologies.
• - Understanding of AI-related applications in business contexts.
• - Strong commitment to driving digital transformation within the organization.