Data Engineer

Permanent
10/09/2020
 

Role Description 

Job Title: 

Data Engineer 

Branch: 

Milton Keynes Head Office 

Salary: 

£40,000 to £50,000

Reports To:   

Head of IT Development 

Hours of Work: 

08:45 – 17:00 Monday to Friday  

Closing date: 

Summary 

Due to our continued success as one of the country’s leading suppliers of heavy commercial vehicles we have a new and exciting opportunity for Data Engineer to join the team based at our Head Office in Milton Keynes. 

An exciting new opportunity to work with our software development team scoping out new potential developments and redevelopments of our current legacy applications used by our employees. We are striving to digitally transform all areas of the company and require a strong, capable and structured Data Engineer to help achieve this. Our developments are predominantly Microsoft On-Prem SQL / Azure SQL & ADF v2 / Snowflake / Talend.  

The purpose of this role is to design and develop the Data Warehouse and ETL required to populate it.  Designing and building data integrations and identifying and integrating new sources of data into the Data Warehouse as required by the business.  Communicating with Business Intelligence developers and other internal partners to troubleshoot problems and analyse their requirements.  Work as part of the wider BI team to advise on the best technical approach to deliver what the business is asking for. 

Essential Duties and Job Responsibilities 

  • Create ETL / ELT solutions according to specifications.  

  • Manage and develop the Data Warehouse environment. 

  • Talent that thrives on solving complex problems to be part of something special 

  • Talent that can champion technical direction and lead others on the journey of delivering on it 

  • Development of well-structured modular systems which utilise efficient code that follows our in-house coding standards 

  • Effective and meaningful documentation of systems to ensure ease of support and modification in the future. 

  • Systems which meet agreed functional and technical requirements and which provide excellent usability and reliability from a user perspective. 

  • Provision of timely and effective support to existing systems and solutions. 

  • Ongoing personal development to ensure that the latest development tools and techniques can be utilised where appropriate 

  • Excellent collaboration with colleagues and internal customers, to ensure that development sprint targets are met and that customer expectations are met. 

  • Collaboration with product experts within ICT and other areas of the business to ensure that a unified approach to data integration is adopted and that project dependencies are identified and managed appropriately. 

  • To work flexibly, which may on occasion involve out of office business hours including early mornings, evenings and weekends. 

This job description provides an indication of the role and responsibilities but should not be construed as an exhaustive list of duties that the post holder may be asked to undertake. 

Candidate Requirements 

Essential Knowledge/Qualifications: 

  • Educated to degree level or equivalent. 

  • Extensive experience of: 

  • SQL Server 

  • SSIS 

  • TSQL 

  • Talend 

  • Knowledge of software interfacing processes and technologies including web services and APIs. 

  • Thorough understanding of the complete software development lifecycle. 

  • Understand SCRUM / Agile working practices. 

Desirable Knowledge/Qualifications: 

  • Azure Development 

  • Azure Data Factory 

  • AWS Development 

Experience / skills regarded as ideal but not essential 

  • Experience in using Test Driven Development best practices  

  • Previous experience working in a similar capacity. 

  • Experience of developing high quality software solutions which meet agreed technical and functional specifications. 

  • Experience of testing and de-bugging solutions and of release management/roll-back strategies. 

  • Experience of supporting and enhancing existing software solutions. 

  • Proven ability to produce high quality technical and end-user documentation. 

  • Experience of working effectively with non-technical end users to deliver effective business solutions. 

  • Experience of using Agile methodology. 

  • Experience of source control and automated build/test systems.  

Scania’s 6 Core Values 

  • Customer first? 

  • Respect for the Individual  

  • Elimination of waste  

  • Determination  

  • Team spirit? 

  • Integrity 

How to apply 

Working for Scania is not just about the job. It’s about you too, and this is where the company goes the extra mile, and provides an industry leading employment package. 

Scania is dedicated to delivering exceptional products and services to our customers and the successful candidate will reflect our core values;?Customer First,?Respect for the Individual, Elimination of Waste, Determination, Team spirit?and?Integrity?in all we do. 

If you feel you have the skills and expertise for this challenging role, then please apply today. 

Scania (Great Britain) Ltd is an equal opportunities employer. 

**Strictly no Recruitment Agencies**