You will be part of the APAC E-Commerce Regional team, a team that supports the Personal Health country teams in APAC in advancing key E-Commerce capabilities. Personal Health is Philips Consumer business, offering products in Household Appliances, Personal Care and Health & Wellness.
E-Commerce is a rapidly growing channel and a strategic priority for our business. The E-commerce team is young, fast-moving and fun-loving, with an entrepreneurial and high performance mindset.
Your Key Areas of Responsibility
The initial focus is to streamline and extract maximum value (insights) from our growing sets of Ecommerce data. If successful, your data landscape and responsibility will increase to cover all BI data for the Philips Personal Health business in APAC to create an integrated daily management ‘cockpit’, and lastly to further integrate 3rd party Ecommerce platforms’ data with Philips Digital and Campaign data.
As E-Commerce & BI Business Analyst, your job will therefore be to drive the following domains:
Data infrastructure, dashboards & reporting
Integrate multiple 1st and 3rd party data sources (excels, powerpivots, SQL databases, etc) into a structured dataset with (automated) dashboards, liaising closely with our online retail partners, Philips country ecommerce & marketing managers to ensure consistency, accuracy & relevancy
Our dataset is quite complex and data needs to be cleansed / aligned periodically to enable proper reporting and analysis
Own monthly online sales and performance reporting, KPI & target tracking with the objective to automate reporting as much as possible
Develop a channel view in financial reporting, leading to a full BI solution and Daily Mgmt board with key business performance indicators
Analytics & insights
Manage and analyze reports & data portals from leading online retailers (e.g. Lazada, Amazon, Shopee) and drive platform-specific insights to grow our business,
Analyze the overall online channel data to track business performance, translate data to insights and flag issues / optimization opportunities
Generate insights on consumer demographics, behaviours and patterns, correlations etc for targeting purposes.
Run performance analysis on the following domains: Portfolio, Operations, Financial, On-site (in-store excellence), Campaigns, Market share, etc on a recurring basis, with occasional Deep dive studies on performance issues / growth opportunities in all domains
Deliver category and campaign specific insights and improvement recommendations to category marketing managers and ecommerce managers
Challenges of the job
Philips is a large company with many stakeholders and you need to find your way in order to make the most impact. You are the master of your own destiny (with support of course), but this is not something that everyone is comfortable with.
Besides being an analytical rockstar, you will be expected to learn to understand our business. Data is more than a set of datapoints and you need to understand the business story the numbers tell.
The audience for your insights spans a wide range of functions (marketing, management, ecommerce, finance, digital) which all have different insight requirements, and a wide range of data proficiency (mature to developing countries & teams). Your dashboards and tools therefore need to be granular enough for advanced users and intuitive enough for less proficient users.
Data is coming from many different sources and systems, and different channels report in different formats, with varying degrees of data quality. Extensive data checking, mapping, cleansing and structuring will be required (but you won’t start from scratch).
The ideal candidate would have:
Ability to set up a data warehouse / databases and automated reporting & dashboards, drawing from multiple data sources
Advanced Microsoft excel (VBA, power pivots) skills, experience with PowerBI / QlikSense and database/dataset structuring & manipulation abilities
Analytical thinking ability and a well-developed business understanding and commercial sense to identify opportunities and grow the business
Ability to prepare and give presentations on regional/national management level.
Fluency in English, verbally and in writing.
Typically, a Bachelor’s or Master’s degree with at least 3-5 years of related experience.
E-Commerce experience, either from brand principal, distributor or e-commerce platform
Ability to work independently, able to envision the big picture but executing with attention for detail with strong communication skills and a (fun) team player mentality
Why should you join Philips?
Working at Philips is more than a job. It’s a calling to create a healthier society through meaningful work, focused on improving 3 billion lives a year by delivering innovative solutions across the health continuum at http://www.philips.com/b-dam/corporate/corporateblog/2016/PhilipsChronicDisease_5.jpg . Our people experience a variety of unexpected moments when their lives and careers come together in meaningful ways.
To find out more about what it’s like working for Philips at a personal level, visit the Working at Philips page at http://www.philips.com/a-w/careers/healthtech/working-at-philips/working-at-philips.html on our career website, where you can read stories from our employee blog at http://www.usa.philips.com/a-w/our-people/life-at-philips.html . Once there, you can also learn about our recruitment process at http://www.philips.com/a-w/careers/healthtech.html , or find answers to some of the frequently asked questions at http://www.philips.com/a-w/careers/healthtech/faq.html .