Data warehouse developer with Data vault knowledge

Scania is currently undergoing an exciting transformation from a traditional truck manufacturer to a provider of complete sustainable transport solutions. IT is a crucial part of this transformation as Scania’s success is depending on flexible and efficient IT solutions that support current and future business requirements.

Quality Information is a fantastic team of data warehouse developers, analysts and data scientists within R&D at Scania. We work with data analysis and management of information connected to the contract sales, quality KPI's and BI-tools to analyse the quality of Scanias products. Since quality is a core value at Scania a sustainable data flow is fundamental.

Job description

You will further develop current ETL flow and data staging structures using the Data Valut principle. You will also, in close cooperation with other data warehouse developers develop a new data warehouse and sustainable ETL-flow that will support both advanced analytics and self-service BI solutions.

You will be part of a group with different expertise’s and responsibilities, that always strive to deliver as a team. We support each other whenever needed. To be successful at your job, you understand the big picture and you take charge of your own work.

You will be responsible for:


• analyse, design, develop and implement Data Vault ETL flows for good performance, traceability, manageability and security
• build dimentional Kimball modeling on top of the Data Vault structure 
• development and monitoring of data integrations
• maintenance of existing data structure
• follow the development of new technology and techniques that can enhance our data platform

Your profile

You have a B.Sc. or M.Sc. in systems or computer science or equivalent work experience. You are fluent in both written and spoken English.

You are curious, have excellent problem-solving skills and a genuine interest in developing in the role as a IT developer.

You have:


• deep knowledge in SQL Server and SSIS
• advanced understanding of data warehouse and ETL concepts
• excellent communication skills needed to cooperate with Scania central IT department to find the best and most efficient and effective solution for a sustainable ETL-flow.

Considered as benefit if you have:


• experience in Data Vault modeling 
• experience from big data technologies
• experience with building dimentional Kimball models
• experience with creating optimized tabular models

 

For more information:

Group Manager Jonatan Elnäs +46 (0)8 553 89763


Scania is a world-leading provider of transport solutions. Together with our partners and customers we are driving the shift towards a sustainable transport system. In 2020, we delivered 66,900 trucks, 5,200 buses as well as 11,000 industrial and marine power systems to our customers. Net sales totalled to over SEK 125 billion, of which over 20 percent were services-related. Founded in 1891, Scania now operates in more than 100 countries and employs some 50,000 people. Research and development are mainly concentrated in Sweden. Production takes place in Europe and Latin America with regional product centres in Africa, Asia and Eurasia. Scania is part of TRATON GROUP. For more information visit: www.scania.com.