Job description
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
Additional Information
Benefits
- Private medical insurance
- Travel allowance
- 25 days annual leave with the opportunity to buy 5 additional days
- Company pension scheme
- Annual performance-based bonus
- Life and Income protection insurance
- Tax efficient benefits (cycle to work, give as you earn)
- Additional optional benefits (Dental, critical illness, spouse/partner life assurance)
PA is committed to building an inclusive and supportive culture where diversity thrives, and all of our people can excel. We believe that greater diversity stimulates innovation, enabling us to fulfil our purpose of ‘Bringing Ingenuity to Life’, supporting the growth of our people, and delivering more enduring results for our clients.
We only recruit, promote and reward our people based on their contribution, without regard to gender, race, disability, religion, nationality, ethnicity, sexual orientation, age or marital status.
We welcome international applications, but we are unable to offer sponsorship for work permits, so you will need to have the full right to live and work in the UK. Unfortunately, your application will be automatically rejected if you do not have these rights.