Data Engineer

Bringing Ingenuity to Life

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

PA. Bringing Ingenuity to Life.

Recognising the growing market demand for BI and information management, we are growing our BI team and are seeking exceptional candidates with ambition and track record in delivering game-changing BI capabilities.

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.

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

Must have:

As this role involves supporting on the Home Office Transformation portfolio you must be eligible for a Security clearance.

To be eligible, the below must be applicable to you:

- You have been a resident in the UK for 5 years or more

- You have not been outside of the UK for any extended periods of time 
- You do not require sponsorship to work and live in the UK

If the above does not apply to you, sadly we will not be able to progress with your application on this occasion and your application will be rejected.

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 Engineers