Data Warehouse Developer
- Älmhult, Sweden
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
• 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
You love to work together with the business defining business requirements. When you know the requirements you put all your energy into finding ways to produce the needed information in our data warehouse. You like to work with data modelling, data warehouse development, testing and implementation. You have experience in working with business intelligence systems and databases.
You need to have very good knowledge and proven experience of the MS SQL stack and preferably knowledge of Microsoft Azure. If you have experience in M3 or DWD/BPW it is an advantage. You also have a clear understanding and good experience in information modelling and taking raw-data all the way to valuable, consumable information in our data marts.
You are familiar with modern DWH solutions and you have experience with different platforms and vendors. With your experience you can contribute to the design of the new target architecture. You have worked on large projects and can play a major role in the upcoming modernisation.
As a person you have strong analytical skills - being able to understand requirements from the business and build the fitting data solution. You have passion for details combined with the ability to see the big picture.
Since IKEA Components is a truly global environment, with colleagues from all over the world, you need to be fluent in English.
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.