Data Architect (Mid-Level)

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 diverse teams of 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

Key Responsibilities: 

• Design and Develop Data Architecture: Create, optimise, and maintain conceptual, logical, and physical data models to support the enterprise data strategy. 

• Data Strategy and Governance: Define and implement data management strategies, including data governance, metadata management, and data quality controls. 

• Database and Cloud Technologies: Select appropriate database solutions (SQL, NoSQL, Data Lakes) and cloud platforms (AWS, Azure, Google Cloud) to support the organisation’s data infrastructure. 

• Data Integration: Develop and manage ETL (Extract, Transform, Load) processes to ensure data from multiple sources is properly integrated into centralized systems. 

• Collaboration and Communication: Work closely with business stakeholders, data analysts, data engineers, and clients to understand requirements and deliver scalable data solutions. 

• Security and Compliance: Ensure data security, privacy, and compliance with relevant regulations (e.g., GDPR, HIPAA) by implementing data encryption and anonymisation techniques. 

• Documentation: Creation of detailed documentation of data architecture, flows, and processes for ongoing improvement and knowledge sharing. 

#LI-SW1

#LI-Hybrid

Qualifications

Required Qualifications: 

Experience: 

• 3+ years of experience in data architecture, database design, or data engineering roles. 

• Proven experience with database management systems (e.g., Oracle, SQL Server, PostgreSQL) and data warehousing technologies. 

• Experience with cloud-based data solutions (AWS, Azure, GCP). 

• Familiarity with big data technologies like Hadoop, Spark, and Kafka. 

Technical Skills: 

• Proficiency in data modelling (ERD, normalization) and data warehousing concepts. 

• Strong understanding of ETL frameworks and tools (e.g., Talend, Informatica, Apache NiFi). 

• Knowledge of programming languages such as SQL, Python, or Java. 

• Experience with BI tools (e.g., Power BI, Tableau) and data visualisation best practices. 

Soft Skills: 

• Excellent problem-solving skills and attention to detail. 

• Strong communication skills to explain technical concepts to non-technical stakeholders. 

• Ability to work in a fast-paced, collaborative environment. 

Preferred Qualifications: 

• Familiarity with Agile/Scrum methodologies. 

• Certifications in data management (e.g., CDMP, AWS Certified Data Analytics, Google Cloud Data Engineer). 

Additional Information

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.

We are currently operating a discretionary hybrid working model which is designed to help you plan your work and your life. We want our people to come into the office at least two days a week.

We believe diversity fuels ingenuity. Diversity of thought brings exciting perspectives; diversity of experience brings a wealth of knowledge, and diversity of skills brings the tools we need. When we bring people together with diverse backgrounds, identities, and minds, embracing that difference through an inclusive culture where our people thrive; we unleash the power of diversity – bringing ingenuity to life. 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)