Inter IKEA Group: Data Analyst (Tech job example)

You see things a little differently. So do we. We believe that what you value is more important than what your CV says. We offer positions that will challenge your skills and let you grow. Come see things a little differently with us!
In South Asia we’re on an exciting journey of expanding our business by adding new suppliers & categories and strengthening our existing suppliers. 
If you like challenges and really making a difference, maybe this journey is for you!
About the company
IKEA Range & Supply has the responsibility to develop, design, produce and supply IKEA stores with home furnishing solutions available to the many people. Each year IKEA Range & Supply introduce 2,000 new products in the IKEA stores. The total range is almost 10,000 products.

About the job

Take the leadership in the business development team to ensure supplier has goods ready in time and in full in order to fulfil customers’ need at lowest possible landed cost. 
By:

• Achieving excellence in running logistics operations in accordance with Category Plan, by interacting with respective stakeholders and complying with working methods; 

• Taking the lead in operational capacity planning at supplier level and contributing to tactical capacity planning; 
• Developing logistics performance through common Action Plans with Suppliers

About the assignment

Secure operational capacities by ensuring high quality of capacity data from suppliers and by working continuously towards exceptions together with Need Planner and Supplier in a proactive manner. Contribute to tactical capacity planning based on supplier performance on agreed capacity. 

• Update and secure correct business set-up information in all relevant systems. Furthermore work with systems and reports, to proactively detect and act on possible deviations from goal. 
• Prepare suppliers for best replenishment and delivery solutions by continuously maintaining & developing supplier delivery performance and sender lead-times. Contribute to identifying best logistical offer, furthermore implements, maintains and reviews by having customer and total cost in mind.
• Actively contributes in the planning and execution of the best set-up for range changes at supplier, constraints periods and activities. 
• Continuously follow-up, analyse and takes action to improve supplier delivery performance and ensures goods are shipped in time from suppliers. 
• Secures correct availability information from supplier to IKEA Retail in such quality that it can be for the benefit of customers. 
• Develops and maintains suppliers’ logistic competence towards becoming responsible on their own performance through: working closely with suppliers, running Supplier Development Projects and providing them relevant trainings & working methods. 
• Contribute to supplier development by taking a lead from logistic perspective and engages relevant competence in IKEA and at Supplier to assess supplier logistics capability and running supplier development projects.

About you

You should have:

• Good Understanding of IKEA Business model and IKEA Business model for growth.
• Good understanding of how your everyday work adds customer value by delivering to Democratic Design 
• Deep Understanding of IKEA Purchasing Manual and good understanding of IKEA Purchasing Development Process (PDP), IKEA Purchasing Year Cycle and the Governance Structure. 
• Understanding of IKEA Supplier Development Process (SDP), Develop Product Offer Process (DPOP) and knowledge around how supply planner contributes to them. 
• Knowledge of supplier capabilities, material, production flow, capacity planning and available capacities. Understanding IKEA Supply Chain organization and processes within Planning and Delivery. 
• Knowledge of administration and reporting systems (e.g. JDA Fulfilment, SCM, GPS, Qlick View etc.). 
• Knowledge of supply chain cost drivers from raw material to customer and logistic tools such as: different replenishment methods, delivery solutions and working with lead times.
   

Job Specific

• Capability to delivery results through involving and engaging stakeholders within IKEA and Supplier.
• Able to translate the Category Plan into logistics solutions; always act with the Customer, Supplier, Total IKEA and Total Cost Development in mind.
• Capability to transfer knowledge and working methods to IKEA suppliers.
• Capability to perform complex analysis, and draw conclusions to support the right business decisions and implementations

         Degree in Data Analytics or equivalent experience

·         2+ years creating reports in a BI tool

·         At least 1 year of professional experience writing queries in SQL/T-SQL

·         At least 1 year of professional experience working in a relational database

·         PowerBI experience a plus

·         Strong analytical skills

·         Detail oriented with the ability to multitask

·         Self-motivated individual with excellent written and verbal communication skills

·         A willingness to work both independently and in a team-oriented environment