We believe in the power of ingenuity to build a positive human future in a technology-driven world. As strategies, technologies and innovation collide, we create opportunity from complexity. Our diverse teams of experts combine innovative thinking and breakthrough use of technologies to progress further, faster. Our clients adapt and transform, and together we achieve enduring results. An innovation and transformation consultancy, we are over 4,000+ specialists in consumer, defence and security, energy and utilities, financial services, government, health and life sciences, manufacturing, and transport. Our people are strategists, innovators, designers, consultants, digital experts, scientists, engineers and technologists. We operate globally from offices across the UK, US, Europe, and the Nordics. PA. Bringing Ingenuity to Life. Are you up for the challenge of creating seamless user experiences from every angle? Our teams are trusted to deliver and given the space to be awesome. Were an inclusive community for the curious, generous, pragmatic and committed digital practitioner. You'll be leading teams who are collectively responsible for delivering functioning solutions to our clients. Junior members of the team will look to you for support, guidance and help with decisions. You'll have: Experience in the design and deployment of production data pipelines from ingestion to consumption within a big data architecture, using Java, Python, Scala, Spark, SQL. Perform tasks such as writing scripts, extracting data using APIs, writing SQL queries etc. Work closely with other engineering teams to integrate data engineering component into production systems. Knowledge of data cleaning, wrangling, visualization and reporting, with an understanding of the best, most efficient use of associated tools and applications to complete these tasks. Ability to travel to client site, where required, will be a consideration. Experience in processing large amounts of structured and unstructured data, including integrating data from multiple sources through ingestion and curation functions on AWS cloud using AWS native or custom programming. Knowledge of data mining, machine learning, natural language processing is an advantage. You enjoy working within cross-functional Agile teams and you are familiar with Scrum ceremonies. Youll be comfortable designing and building for the AWS cloud and will have designed and worked on architectures that include Platform-as-a-Service components and perhaps even server-less and container technologies. Apply today by completing our online application. Qualifications AWS is a significant growth area for us with a diverse and growing capability and we are looking for a data engineer with experience in AWS cloud technologies for ETL pipeline, data warehouse and data lake design/building and data movement. There are a variety of different tools, cloud technologies and approaches and while we have a preference for AWS tooling experience, open-source equivalence will be suitable. As an Lead Data Engineer, youll have experience leading teams to design, build, and maintain large scale data solutions and applications using AWS data and analytics services (or open-source equivalent) such as EMR, Glue, RedShift, Kinesis, Lambda, DynamoDB. Your team members will look to you as a trusted expert and will expect you to define the end-to-end software development lifecycle in line with modern AWS best practices. Your AWS experience spans data engineering, data science and product development projects, plus you will have an understanding of stream and batch processing. Additional Information Benefits Private medical insurance Travel allowance 25 days annual leave with the opportunity to buy 5 additional days Company pension scheme Annual performance-based bonus Life and Income protection insurance Tax efficient benefits (cycle to work, give as you earn) Additional optional benefits (Dental, critical illness, spouse/partner life assurance) Flexible working - We are guided by our client work and needs; however, you have autonomy to manage your time and diary to suit your work/life balance. PA is committed to building an inclusive and supportive culture where diversity thrives, and all of our people can excel. We believe that greater diversity stimulates innovation, enabling us to fulfil our purpose of Bringing Ingenuity to Life, supporting the growth of our people, and delivering more enduring results for our clients. We only recruit, promote and reward our people based on their contribution, without regard to gender, race, disability, religion, nationality, ethnicity, sexual orientation, age or marital status. We welcome international applications, but we are unable to offer sponsorship for work permits, so you will need to have the full right to live and work in the UK. Unfortunately, your application will be automatically rejected if you do not have these rights. Skills: Lead Data Engineer