Data Engineer

Paconsulting; Manchester; Hybrid; GBP 55,000 - 90,000; Full time

Benefits offered by this job

Private healthcare

25 days annual leave + Christmas Eve 0

Company pension

Job summary

PA Consulting in Manchester is seeking a Data Engineer to join our Digital & Data team. You will contribute to ETL pipelines, data warehouse design and data lake building on AWS, collaborating with product, design and other experts across sectors.

Hybrid working with two days in the office per week, learning-driven culture, and opportunities to gain certifications. You’ll work on varied projects using Java, Python, Scala, Spark and SQL.

Qualifications

• Problem-solving and analytical thinking required.
• Strong collaboration with multiple stakeholders in a fast-paced environment.
• Experience designing and deploying data pipelines in big data architectures using Java/Python/Scala/Spark/SQL.
• Experience writing scripts and SQL queries; data extraction via APIs.
• Processing large structured and unstructured data on AWS cloud (native or custom).

Responsibilities

• Work to agile best practices with multiple teams and stakeholders.
• Design and build data solutions for the AWS cloud.
• Collaborate on internal projects and client work with cross-functional teams.

Skills

Problem-solving

Analytical-thinking

Collaboration

Data-pipelines

Java

Python

Scala

Spark

SQL

AWS

Tools

AWS

SQL

Java

Python

Scala

Spark

Job description

Why consider joining our Digital & Data community?

We believe in the power of ingenuity to build a positive human future. We challenge where it matters and own the outcome. We combine strategic thinking, customer-centric service design, and agile engineering practices to accelerate innovation in a tech-driven world.

Join our Digital & Data team working alongside product, design and a wide range of other experts and cross-disciplinary teams to bring ideas to life through innovative software solutions.

Grow a flexible and unique career within a trust-based, inclusive environment that values excellence, innovation, and curiosity. You have the option to progress with us on a technical career track. No need to go onto the Partner career track if this doesn't align with what you want to do.

Hybrid working – our approach is to be in the office or on client site a minimum of 2 days per week.

Work on a broad variety of projects and tech stacks for clients across seven sectors – no project is ever the same.

Join other experts within our supportive and collaborative tech community through knowledge-sharing and peer-level support, coaching and mentoring.

Deepen your expertise through a culture of learning and growth – you'll have budget to take courses (technical and non-technical training), plus gain certifications.

Our tech stack

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.

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.

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

• 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.

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 pensi