Data Engineers - Leading Innovation in Analytics

The role

We’re an innovation and transformation consultancy that believes in the power of ingenuity to build a positive-human future in a technology-driven world. Our diverse teams of experts combine innovative thinking with breakthrough-technologies to progress further, faster.

We are looking for Data Engineers and Architects - at the heart of our business are our people – strategists, technologists, digital experts, consultants, designers, scientists and engineers – all of whom bring real-world experience and apply it at pace. 

Our data engineering and architecture expertise helps unlock our client’s data, opening doors to new business opportunities, optimal organisational performance and great user experience.

We are looking for people who know how the future data platforms look like and know how they interact with existing legacy clients’ architecture.

When you join PA, we ask for your ideas, expertise and commitment. In return we’ll give you stimulating work that improves people’s lives, opportunities to learn from brilliant people and a supportive culture where you can thrive.

What we're looking for

Required skills / experience

  • Strong SQL
  • Building and managing fully automated data pipelines (ETL, ELT, ELTL) including:
    • designing and building data interfaces to source systems
    • combining and transforming data into the appropriate format for storage
    • developing data sets for analytics purposes
    • developing pipelines that can handle common issues/errors in a robust and automated way
  • Cloud experience in Azure, AWS or GCP
  • Experience across Big Data Lakes and Data Warehouses

Desirable skills / experience

    • Working Agile and DevOps
    • Basic Python, Bash, or PowerShell for automation
    • Spark / PySpark
    • Data modelling
    • Data visualisation in Power BI, Tableau, Qlik or similar
    • Architecting Data Platforms - designing BI/MI/Analytics solutions using Big Data, Relational or Streaming technologies
    • One or more of the following certifications:
      • Microsoft Certified: Azure Data Engineer Associate
      • AWS Certified Data Analytics - Specialty
      • GCP Professional Data Engineer

About us

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 3,200 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.

Benefits

We all work best when we feel valued, supported and life feels balanced, so we got the folks who actually work here to design our benefits.

Looking after you and yours

Flexible healthcare plans just for you or your family. Depending on your office location, we offer a range of benefits including dental, eye tests, gym discounts, Cycle to Work, and more.

Finding work/life balance

Now, more than ever, we’re big on flexible working. Whatever the situation at the time, we’ll have an open discussion about what works for you. We’ve also enhanced our parental leave, so you can make more time for what really matters.

Taking a break

Because there’s more to life than just work… All our office locations have competitive annual leave allowances. You can also buy up to five extra days per year.

Personal growth

Learning never stops – it feeds the mind, expands our skills, and strengthens our team. We offer a range of ongoing internal and external training programmes covering everything you'll need to feed and grow your career ambitions.

Planning for the future

Don't worry, we offer all the sensible stuff, including a pension, life assurance, income protection schemes, and PA shares.

Giving back

Take advantage of our great Give as You Earn scheme, or why not volunteer up to three days a year for a charity close to your heart?

A home for everyone

Whether just starting out, or a practised hand, we have active and firm-wide support communities in place to help everyone get the support they need.

Find out more

Going further afield

With offices in countries across the globe, as a firm, we’re able to relocate folks who want to move – whether temporarily or permanently. Your starting location doesn’t have to be forever, as your career takes off.

Location

The base office for this role is Victoria, London. However, you may sometimes be required to work onsite at client offices, too. You can find out more about our offices and remote working approach on our Locations page.

Address

10 Bressenden Place, Westminster, London SW1E 5DN

Transport links

Our office is a short walk from Victoria station. Victoria is on the National Rail as well as Circle & District and Victoria Underground lines.

Victoria – 2 minutes walk
Charing Cross – 15 minutes by tube
Waterloo – 15 minutes by tube

Our offices