Data Warehouse Developer

IKEA Components task within IKEA is to pursue the development of future unique and customer friendly solutions within fittings and components to the IKEA range. We create substantial cost and quality benefits for IKEA in our development and trade of raw materials, components and fittings.

IKEA Components is part of the IKEA group and shares the IKEA vision and values. Our business is global and we are 1500 employees based in Sweden, Slovakia and China. Through co-operation with IKEA Purchasing Offices we are in addition represented at several other sites around the world.

We are looking for an experienced Data Warehouse Developer to join our business intelligence team!

Having the right information about business performance is key to our success. If you know how to turn raw data into valuable and visual information to our stakeholders you may be the one we are looking for.
You will be part of a global team of approx. 8 co-workers, providing the IKEA Components organisation and other stakeholders with correct information about the business performance. Our internal title for this role is Solution Expert BI and in this role, you will be reporting to the Process Development Manager.

The position is located in Älmhult, Sweden. Älmhult has excellent commuting possibilities with hourly trains to Malmö, Lund and Växjö and an IKEA shuttle bus back and forth to Helsingborg three times a day.

Main responsibilities in the assignment:
•    Develop IKEA Components’ BI solution with an end-to-end perspective
•    Act as an owner of the entire BI solution but with a clear focus on the backend (data warehouse)
•    Drive development and implementation of new data models to provide measurements and KPIs
•    Design, implement and secure flows from fetching raw data to quality secured models for our report developers and analysts
•    Supports planning of external resources and acts as an orderer towards the supplier
•    Be the primary stakeholder within BI for development of business solutions and processes
•    Own and develop the physical information model
•    Acts as an orderer towards the data integration team
•    Work closely with business analysts and report developers 
•    Support change- and incident management

Our current BI platform consists of a centralised data warehouse based on Microsoft SQL products and Infor’s DWD as a modelling tool. We use Microsoft BI (Power BI and SSRS) as a frontend to our reports consumers. 
All information modelling is done in the data warehouse, i.e. this is the complex part of our BI platform. Data is provided to the report developers in data marts or SSAS cubes.
We are planning to modernise (re-build) our data warehouse in the near future and in your role you are the main contributor to the effort.

This adds some aspects to the assignment:
•    Set a target architecture for a modern, future-proof data warehouse
•    Select components, solutions and vendors
•    Plan/support the migration from existing to future DWH
•    Co-operate on a wider IKEA level and secure we remain connected 

Sounds interesting?

We look forward to receiving your application – CV and letter of motivation – in English latest  15 of November 2020. Please note that we will be interviewing continuously, which means that we may close the application process earlier than stated if we find the right candidates.

If you have any questions regarding the role, please contact Process Development Manager Tim Richter at +46 728 865 841. If you have questions regarding the recruitment process, please contact Recruitment Specialist  Christina Appelqvist at +46766113408.