Data Engineer

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.  AWS data and analytics services (or open-source equivalent) such as EMR, Glue, RedShift, Kinesis, Lambda, DynamoDB.  What you can expect 🌱  Work to agile best practices and cross-functionally with multiple teams and stakeholders. You’ll be using your technical skills to problem solve with our clients, as well as working on internal projects  Live in-person whiteboarding sessions to problem solve as a team, alongside asynchronous communication on Teams  Hybrid working with the team on client site or in our office a minimum of two days per week. However, the actual time you spend and where you spend it will vary by role or assignment, including up to 5 days per week on a client site.  An environment that deeply cares about its values  Values | PA Consulting You’ll work alongside colleagues from across PA – delivering transformative digital solutions to today’s most complex business challenges. You’ll be designing and building for the AWS cloud  Essential requirements ✅  Even if you don’t meet every requirement below, feel free to still apply as we are often hiring for similar roles which your background might be better suited to.  You thrive in problem-solving and analytical thinking   You enjoy collaborating with multiple stakeholders in a fast-paced environment  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.  Experience performing tasks such as writing scripts, extracting data using APIs, writing SQL queries etc. 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. Please be aware that some of our UK roles at PA Consulting require a UK security clearance. All PA people are required to undergo background checks and to achieve the Baseline Personnel Security Standard however, some UK roles also require higher levels of National Security Vetting, where applicants must have at least 5 years of continuous residency in the UK. We therefore ask that you only apply if you meet the residency requirements (i.e. you are a British citizen or have been resident in the UK for the past 5 years), as this is the prerequisite for a security clearance. If you're unsure about your eligibility, we encourage you to review the UK Government’s guidance on security vetting before applying. We believe in the power of ingenuity to build a positive human future.   As strategies, technologies, and innovation collide, we create opportunity from complexity.  Our teams of interdisciplinary experts combine innovative thinking and breakthrough technologies to progress further, faster. Our clients adapt and transform, and together we achieve enduring results.  We are over 4,000 strategists, innovators, designers, consultants, digital experts, scientists, engineers, and technologists. And we have deep expertise in consumer and manufacturing, defence and security, energy and utilities, financial services, government and public services, health and life sciences, and transport.   Our teams operate globally from offices across the UK, Ireland, US, Nordics, and Netherlands.  PA. Bringing Ingenuity to Life.  Assessment process ⚖️  Please note that the interview stages may be subject to change based on the specific requirements of the role.  Quick call with one of our Tech Recruiters – to discuss your application, the role and PA  Round 1: Either a competency or technical interview (60 mins)  Round 2: Either a competency or technical interview, whichever you didn’t do at first round (60 mins)  Final round 🎉: Meeting with a PA leader - a mini case study and discussion around your client-centricity (60 mins)  Life At PA encompasses our peoples' experience at PA. It's about how we enrich peoples’ working lives by giving them access to unique people and growth opportunities and purpose led meaningful work.  Our purpose guides how we work with our clients and our teams, and support our communities, to deliver insight and impact, solving the world’s most complex challenges. We're focused on building a workplace that values human difference and diverse mindsets, and a culture of inclusion and equality that unlocks the potential in our people so everyone can be their best self.  Find out more about Life at PA here .  We are dedicated to supporting the physical, emotional, social and financial well-being of our people. Check out some of our extensive benefits:  Health and lifestyle perks accompanying private healthcare for you and your family  25 days annual leave (plus a bonus half day on Christmas Eve) with the opportunity to buy 5 additional days  Generous company pension scheme  Opportunity to get involved with community and charity-based initiatives  Annual performance-based bonus  PA share ownership  Tax efficient benefits (cycle to work, give as you earn)  We’re committed to advancing equality. We recruit, retain, reward and develop our people based solely on their abilities and contributions and without reference to their age, background, disability, genetic information, parental or family status, religion or belief, race, ethnicity, nationality, sex, sexual orientation, gender identity (or expression), political belief, veteran status, any other range of human difference brought about by identity and experience. We welcome applications from underrepresented groups.  Adjustments or accommodations - Should you need any adjustments or accommodations to the recruitment process, at either a