Data Engineer - Milton KeynesFull time permanent opportunityIn this team we have started to work 2-3 days in the office in Milton Keynes which works well and would be expected of you tooClosing Date is the 13th DecemberWhat's in it for you? Salary up to £59,000 Company Car scheme with a car worth up to £48,250 and 2 family members can take advantage of our loan car scheme, discretionary bonus, healthcare, pension and 27 days holiday in addition to statutory bank holidays plus much more!Fantastic opportunity to join us and support our company wide data initiative as a Data Engineer. You will develop, construct, test and implement data structures - such as data warehouses. The data is intended for data initiatives, including decision led analytics and operational useYou'll be responsible for delivering against the company-wide data strategy, using iterative solutions to demonstrate the future capabilities of data engineering. Utilising a unique set of skills and applying innovative approaches to data preparation, this role is expected to optimise and prepare current data structures to satisfy business outcomes, plus work closely with the data working group to architect VWFS' future data target state. You will lead on data initiatives and ensure optimal data delivery architecture is consistent throughout ongoing projects. You will be key in building and managing the data pipelines that enable efficient and reliable data integration, transformation, and delivery for all data users across the enterpriseKnowledge and experience you have that enables you to add value:You bring advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databasesModelling, building and optimising 'big data' data pipelines, architectures and data setsStakeholder management and strong communication which means you get to the root of a problem and ensure the correct priority and resources are available to resolve the issueStrong communication skills and you can present complex data and arguments in a way that is accessible to everyonePerforming root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvementProven experience in Data Engineering and BI development, building processes supporting data transformation, data structures, metadata, dependency and workload managementA successful history of manipulating, processing and extracting value from large disconnected datasetsWorking knowledge of message queuing, stream processing, and highly scalable 'big data' data storesSupporting and working with cross-functional teams in a dynamic environmentStrong Enterprise Data Management skills across data engineeringAbility to resolve issues through strong problem solving skills: root cause analysis; engaging people from multiple business areas and IT teamsExcellent project management and organisational skillsYou have a tenacious approach, you're focused and determined to get the job done effectively, overcoming any challenges you encounterIf you also had previous experience in Financial Services, Automotive Finance or retail consumer finance (B2C) and Agile certification this would be a great advantageTech Skillset essentials you must have:Expertise in ETL/ELT with industry standard tools: Informatica IPS/Cloud and SAP Data ServicesA high level skill in data reporting: SAP Business Objects with ability to support our business or data consumers for their reporting and business needsA high level of knowledge and experience in SQL - preferably PL/SQLExperience in Tableau and knowhow of Power BI and QliksenseProven experience of building data models, doing end-to-end Data Engineering and reporting working with diverse stakeholder(s).You have knowledge and experience of Python - supporting Data Engineering or Data Science and Insights teamTraining or Certification in any of the above Tech Stack or in Enterprise Data Management would be seen as a plusIt would be great if you had these too but not essential:Other data tools: Hadoop, Spark, Kafka and so onRelational NoSQL databases, including Postgres and CassandraKnowledge and experience of data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etcAWS cloud services: EC2, EMR, RDS, RedshiftStream-processing systems: Storm, Spark-Streaming, etc.Experience with object-oriented/object function scripting languages: Java, C++, Scala, etcStrong Machine Learning, AI and Data Mining skills working with structured and unstructured dataset.This is what you will be doing:You'll coach and upskill the Business Information (BI) Development team to enable the use of unique innovative data preparation methods, to increase readiness for future target statesDesign and develop data pipelines that extract data from various sources, transform it into the desired format, and load it into the appropriate data storage systemsDemonstrate data preparation methods enterprise wide, giving insight into the future capabilities required to move the company forward, as aligned to strategic data goalsYou will mentor junior members of the BI Development team to ensure their skills are kept up to date in line with the latest standard BI development techniquesDefine and support creating and maintaining optimal data pipeline architecture to allow development teams to deliver solutions sooner and saferYou're responsible for assembling large, complex data sets that meet functional / non-functional business requirementsLead the Identification, design, and implementation of internal process improvements to allow better value sooner through increased throughput of new developmentsAct as technical lead in automating manual processes, optimising data delivery and re-designing infrastructure for greater scalability within the data environmentYou'll lead the development of the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using Structured Query Language (SQL) and Amazon Web Services (AWS) 'big data' technologiesBuild analytics tools that utilise the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metricsWork with stakeholders including Product and System teams and Data Scientists in HQ to assist with data-related technical issues and support their data infrastructure needsEnsure VWFS UK data is kept separated and secure across national boundaries through multiple data centres and AWS regionsCreate data tools for Data Analysts and Data Scientists that assist them in building innovative and commercially valuable productsCollaborate with the IT Architecture team to ensure adherence to systems architecture roadmapsYou'll assist the BI Manager and Data & AI Technical Product Owner with planning workloads and backlog prioritisationEnsure knowledge transfer relating to new pipeline architecture and tools to the Business Intelligence and Analytics team, Application Management Services (AMS) Support and other stakeholders where requiredWhat's in it for you?A salary up to £59,000 subject to experience and working 35 hours per week. You'll also receive an excellent benefits package including tax efficient company car from day one, 2 additional vehicles for family members after 6 months, annual discretionary bonus and salary review, 27 days holiday with the option to purchase more, access to various health & wellbeing services, private medical insurance after 6 months as well as career progression, professional development and access to LinkedIn LearningAbout Volkswagen Financial ServicesOur mission is straight forward, we want to be 'The Key to Mobility'. What does that mean? To make getting from A-to-B as easy and simple for as many people as possible. To truly meet the mobility needs of people in a changing world, our offering goes beyond traditional vehicle financing. We do this by providing a range of finance and aftersales products on Volkswagen Group vehicles, as well as developing innovative mobility products designed to solve real problems and support our customers.Volkswagen Financial Services is committed to being an inclusive employer and we welcome applications from everyone. Diversity and Inclusion is not just a statement for us and we are nurturing an environment where everyone can be their 100% self. If there is anything we can do to support you being your 100% self during our recruitment process, please let us know and we will support you as best we can