Data Engineer - Milton Keynes
Full time permanent opportunity
In 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 too
Closing Date is the 13th December
What'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 and27 daysholiday in addition to statutory bank holidays plus much more!
Fantastic opportunity to join us and support our company wide data initiative as aData 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 use
You'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 enterprise
Knowledge 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 databases
- Modelling, building and optimising 'big data' data pipelines, architectures and data sets
- Stakeholder 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 issue
- Strong communication skills and you can present complex data and arguments in a way that is accessible to everyone
- Performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
- Proven experience in Data Engineering and BI development, building processes supporting data transformation, data structures, metadata, dependency and workload management
- A successful history of manipulating, processing and extracting value from large disconnected datasets
- Working knowledge of message queuing, stream processing, and highly scalable 'big data' data stores
- Supporting and working with cross-functional teams in a dynamic environment
- Strong Enterprise Data Management skills across data engineering
- Ability to resolve issues through strong problem solving skills: root cause analysis; engaging people from multiple business areas and IT teams
- Excellent project management and organisational skills
- You have a tenacious approach, you're focused and determined to get the job done effectively, overcoming any challenges you encounter
- If you also had previous experience in Financial Services, Automotive Finance or retail consumer finance (B2C) and Agile certification this would be a great advantage
Tech Skillset essentials you must have:
- Expertise in ETL/ELT with industry standard tools: Informatica IPS/Cloud and SAP Data Services
- A high level skill in data reporting: SAP Business Objects with ability to support our business or data consumers for their reporting and business needs
- A high level of knowledge and experience in SQL - preferably PL/SQL
- Experience in Tableau and knowhow of Power BI and Qliksense
- Proven 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 team
- Training or Certification in any of the above Tech Stack or in Enterprise Data Management would be seen as a plus
It would be great if you had these too but not essential:
- Other data tools: Hadoop, Spark, Kafka and so on
- Relational NoSQL databases, including Postgres and Cassandra
- Knowledge and experience of data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc
- AWS cloud services: EC2, EMR, RDS, Redshift
- Stream-processing systems: Storm, Spark-Streaming, etc.
- Experience with object-oriented/object function scripting languages: Java, C++, Scala, etc
- Strong 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 states
- Design and develop data pipelines that extract data from various sources, transform it into the desired format, and load it into the appropriate data storage systems
- Demonstrate data preparation methods enterprise wide, giving insight into the future capabilities required to move the company forward, as aligned to strategic data goals
- You 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 techniques
- Define and support creating and maintaining optimal data pipeline architecture to allow development teams to deliver solutions sooner and safer
- You're responsible for assembling large, complex data sets that meet functional / non-functional business requirements
- Lead the Identification, design, and implementation of internal process improvements to allow better value sooner through increased throughput of new developments
- Act as technical lead in automating manual processes, optimising data delivery and re-designing infrastructure for greater scalability within the data environment
- You'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' technologies
- Build analytics tools that utilise the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics
- Work with stakeholders including Product and System teams and Data Scientists in HQ to assist with data-related technical issues and support their data infrastructure needs
- Ensure VWFS UK data is kept separated and secure across national boundaries through multiple data centres and AWS regions
- Create data tools for Data Analysts and Data Scientists that assist them in building innovative and commercially valuable products
- Collaborate with the IT Architecture team to ensure adherence to systems architecture roadmaps
- You'll assist the BI Manager and Data & AI Technical Product Owner with planning workloads and backlog prioritisation
- Ensure 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 required
What'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 Learning
About Volkswagen Financial Services
Our 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
