Company Description
With over 100 years of experience, Sika is a worldwide innovation and sustainability leader in the development and production of systems and products for commercial and residential construction, as well as the transportation, marine, automotive, and renewable energy manufacturing industries.
Sika has offices in over 103 countries with over 400 manufacturing facilities and more than 33,000 employees worldwide. With annual sales of CHF
- 24 billion in 2023, our commitment to quality, innovation, and the environment as well as putting our customer's needs first, encompasses why Sika is the global leader in our industries.
Job Description
Specific Duties and Responsibilities:
Revenue Analysis & Reporting
Responsible for design & generation of regular sales reports such as but not limited to:
Daily Sales Dashboard
Monthly Sales Report
Detailed Sales Variance Analysis
Sales & Gross Margin Analysis
Sales Monthly Trend
Generation of special purpose reports such:
TM Concrete Sales, Volume & Margin Report
TM Industry Sales & Margin Report
Cross-Selling Report
Key Project Management Reports
Generation of special or adhoc reports or data request coming from Sales Group Heads, TM, Finance and GM for purpose of monthly business reviews, regional reporting, customer reviews, special projects progress reporting.
Drive data collation and synthesis of budgeting, forecasting and all kinds of forward- looking revenue & margin projections such as:
Sales Bridge (Weekly & Monthly Sales Plan, Actuals & Forecast)
12 Month - Rolling Forecast
Annual Sales Budgeting Files
Seasonal Sales Projections Exercise
Special Purpose Projections (e.g. for RPA input)
Analytical calculations for purpose deriving conclusion on trends and behavior of revenue and margin in relation to customer, product, volume, segments, sections and other slices of data as the situation demands.
Regularly interacts and coordinate with different sales & marketing group for purpose of getting insights on relevant reports as well as giving guidance on how to accomplish various budgeting, forecasting and analysis templates.
Pricing Generation and Maintenance
To facilitate the annual pricing review exercise (SMP/SRP Review) by:
Collate relevant financial data for historical references such average prices, discounts, costs, margins, and volume
Gather inputs from sales and marketing group in terms of target price, competitor's prices, volume projections, data outliers (i.e. product promotions)
Gather inputs from costing and inventory officer for product costing, inventory information, product lifecycle, SLOB considerations, critical costing assumptions.
Provide a working template to synthesize all relevant reference, inputs and calculation in aid of pricing decision-making.
To manage end to end pricing requests (SMP/SRP request) in terms of accuracy, timeliness and completeness, going through the required inputs from relevant department or personnel.
To generate control and monitoring pricing reports such as price effect reports, pricing initiatives progress reports, price waterfall analysis and other pricing analytics.
To maintain and keep updated all types of pricing records in different systems such as but not limited to Microsoft AX (including Trade Agreements), Salesforce Pricebook, Pricelists (Broadcasted Internal & External).
To maintain and keep updated database of competitors equivalent products and prices periodically for purpose of providing supporting assumption on price positioning.
To provide insights and feedback to pricing committee in terms of pricing suggestions, pricing issues, price improvements and price competitiveness.
Qualifications
Education:
Graduate of Business or Commercial Data Science related courses (Economics, Mathematics, Accounting)
Work Experience:
At least five (5) years relevant experience in business intelligence or financial reporting (pricing, commercial finance, data handling & analysis)
Worked in a position exposed in knowledge of market trends & commercial aspects of the business
Skills:
Highly advance use of Microsoft Excel
Possesses a strong analytical and logical skill
Can work under pressure and tight deadlines
Able to communicate well at all levels in the organization
Has a proven track record in a multinational set-up
