Data Engineer

PA Consulting; Belfast City District; On-site; GBP 60,000 - 90,000; Full time

Benefits offered by this job

Health and lifestyle perks

25 days annual leave

Generous pension scheme

PA share ownership

Annual performance-based bonus

Job summary

PA Consulting is seeking a Data Engineer with strong AWS cloud experience to design and build ETL pipelines, data lakes and data warehouses. You will work across PA’s Digital & Data teams to deliver data‑driven solutions for clients, often on client sites or in our offices.

You’ll design production data pipelines, collaborate with multi‑disciplinary teams, and ensure robust data movement using AWS native or custom tooling. Hybrid work and ongoing learning opportunities are available.

Qualifications

• Experience designing production data pipelines from ingestion to consumption in a big data architecture using Java, Python, Scala, Spark and SQL.
• Experience in writing scripts and queries, and extracting data via APIs.
• Experience processing large structured and unstructured data in AWS cloud using native or custom programming.

Responsibilities

• Work with agile teams to design, build and operate data pipelines and analytics solutions for clients.
• Collaborate with cross‑functional teams across PA to deliver data‑driven outcomes.
• Design and implement data movement on AWS, including data lakes and data warehouses.

Skills

Data pipelines

AWS

Java/Python/Scala

SQL

APIs

Team collaboration

Tools

AWS EMR

AWS Glue

Redshift

Kinesis

Lambda

DynamoDB

Job description

Company Description

We believe in the power of ingenuity to build a positive human future.

Company Description

We believe in the power of ingenuity to build a positive human future.

Company Description

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.

Job Description

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.

Why consider joining our Digital & Data community?

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

Qualifications

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.

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.

Additional Information

Assessment process

• 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, or other by 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 application or interview, please contact us on [e-mail]