Sales Analyst

Who we are:

Build your best future with the Johnson Controls team

As a global leader in smart, healthy, and sustainable buildings, our mission is to reimagine the performance of buildings to serve people, places, and the planet. Join a winning team that enables you to build your best future! Our teams are uniquely positioned to support a multitude of industries across the globe. You will have the opportunity to develop yourself through meaningful work projects and learning opportunities. We strive to provide our employees with an experience, focused on supporting their physical, financial, and emotional wellbeing. Become a member of the Johnson Controls family and thrive in an empowering company culture where your voice and ideas will be heard – your next great opportunity is just a few clicks away!

What you will do:

This position is responsible for assisting Sales Analyst Supervisor in Asia Pacific Region on Sales and Margin information, providing comprehensive and accurate sales analysis for business planning and decision making.

How you will do it:

Reporting

• Extraction and verification of sales, order intake and backlog data from multiple sources and consolidate to generate reports to APAC sales team.
• Generate weekly and monthly sales and margin analysis report into various segments, territory, customer and product line to sales and management team.
• Consolidate and maintain centralized database and ensure correct mapping of sales data to region and sales personnel.
• Prepare ad hoc reports/presentation slides for Sales and Finance teams.
• Provide backup support on reporting for different business units.

Sales Support

• Support APAC Business Unit sales team in weekly sales tracking, consolidate monthly forecast and assist in yearly budgeting.
• Support Business Leaders in target incentive allocation, monthly sales incentive calculation, generation of incentive plan and payout letters and provide monthly payout details to respective country HR/Payroll Team.
• Support Sales and Finance Team in warranty rebates monthly tracking and quarterly SFDC warranty rebates approval process.

What we look for:

• Minimum Bachelor’s Degree in a related discipline
• Minimum 2 years of relevant work experience
• Advance in MS Excel especially well-verse in generating Pivot Table and vlookup is a must
• Knowledge in Power BI is preferred
• Experience in analysing data and sensitive with data
• Possess analytical mindset and pleasant personality
• Meticulous and able to work independently
• Strong cross-functional collaboration who is able work well with others
• Fresh graduate will be considered
• Proficiency in English and Mandarin as this position will require to communicate with Mandarin speaking stakeholders

What we offer:

• Competitive salary
• Paid vacation/holidays/sick time
• Comprehensive benefits package
• On the job/cross training opportunities
• Encouraging and collaborative team environment
• Dedication to safety through our Zero Harm policy