Data Architect-Manager - City of Edinburgh

Line of Service · AdvisoryIndustry/Sector · Not ApplicableSpecialism · Technology StrategyManagement Level · ManagerJob Description & Summary · About the role:   · PwC's Data & AI Consulting team is rapidly expanding as we invest in building a new generation of Artificial Intelli ...

Job description

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Technology Strategy

Management Level

Manager

Job Description & Summary

About the role:  

PwC's Data & AI Consulting team is rapidly expanding as we invest in building a new generation of Artificial Intelligence (AI) products that transform how we deliver value to our clients. We're recognised by industry analysts, such as Gartner and IDC, as a market-leading Data & AI services consultancy and are actively working with clients to design, develop and deliver AI-powered products and data capabilities that achieve tangible outcomes and business value.

We're looking for self-starting, progressive, and inquisitive individuals who want to shape the future of how AI is applied in real business contexts. You'll join a collaborative and entrepreneurial team that combines deep technical expertise with sector knowledge and product thinking. We work in cross-functional squads to design, build, and launch solutions that create measurable impact for our clients and strengthen PwC's position as a leader in trusted, responsible AI.

If you want to apply your skills to complex challenges, help define new products, and be part of an ambitious team that's re-imagining the role of AI in professional services, this could be the role for you.

What your days will look like:

Contributing to the design of enterprise data architectures that support modern analytics, AI, and digital transformation programmes - shaping how data is ingested, modelled, governed, and served across cloud platforms.

· Supporting the definition of end-to-end data architecture approaches, including data modelling patterns, integration methods, lineage, quality, metadata management, and MDM, ensuring solutions are secure, scalable, and aligned to client needs.

· Participating in architectural discovery and helping shape data workstreams, contributing to technical delivery approaches across Azure, AWS, GCP, or Snowflake environments.

· Working as part of cross-functional product squads - including Data Engineers, Data Strategist, AI specialists, and Business SMEs- to design, build, and provide technical assurance for data-driven architectures

· Engaging with client stakeholders to understand business challenges, gather data requirements, evaluate technical options, and contribute to clear, value-led recommendations.

· Collaborating with engineering teams to translate data architecture designs into practical solutions, supporting modelling, pipelines, integration patterns, and cloud platform components through delivery

· Contributing to data strategy discussions and architectural roadmaps, helping clients enhance their data landscape and enable modern analytics and AI capabilities.

This role is for you if:

Proven experience in enterprise architecture, including:

· Hands-on experience designing and delivering platform-agnostic data architectures, working with cross-functional teams to build data models, pipelines, and semantic layers.

· An understanding of how data modelling and architecture decisions support business outcomes and sector-specific needs.

· Experience contributing to technology evaluations and able to articulate key considerations, trade-offs, and suitability for client environments.

· Good working knowledge of data governance, lineage, quality frameworks, and MDM, and how they fit within a modern data platform.

· Experience delivering high-quality work in client-facing environments and building effective working relationships with stakeholders.

· Strong consulting foundations: impactful communication, structured problem-solving, adaptability, and the ability to navigate ambiguity and deliver under pressure.

· You'll bring strong technical capability across:

o Design expertise in core data architecture disciplines including data modelling (proficient in at least one data modelling tool e.g. Erwin or ER Studio), metadata management, data migration and master data management

o Experience applying data architecture approaches to ingest, model, and serve data from a range of enterprise systems, such as ERP (Oracle, SAP), CRM (Salesforce), and HR systems (Workday)

o Practical knowledge of core data ETL and visualisation skills- for example using non structured and structured storage and database solutions native to the cloud providers

o Technical interest, in one or more of the following areas: Master Data Management tools such as Informatica, writing API specs in JSON and integrating with tools such as MuleSoft.

· "Nice to have" skills for this role include:

o Experience in Agile delivery and Agile techniques, such as Scrum and Kanban

o Experience designing data solutions to support Artificial Intelligence (AI) and Agentic AI products.

What you'll receive from us:   

No matter where you may be in your career or personal life, our benefits are designed to add value and support, recognising and rewarding you fairly for your contributions. 

We offer a range of benefits including empowered flexibility and a working week split between office, home and client site; private medical cover and 24/7 access to a qualified virtual GP; six volunteering days a year and much more.

Education (if blank, degree and/or field of study not specified)

Degrees/Field of Study required:Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Optional Skills

Accepting Feedback, Accepting Feedback, Active Listening, Analytical Thinking, Coaching and Feedback, Communication, Creativity, Data Access Design, Database Administration, Database Development, Database Management System (DBMS), Data Development, Data Integration, Data Lake, Data Modeling, Data Virtualization, Data Warehouse, Data Warehouse Architecture, Data Warehousing Frameworks, Data Warehousing Implementation, Data Warehousing Lifecycle, Data Warehousing Trends, Embracing Change, Emotional Regulation, Empathy {+ 14 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Up to 60%

Available for Work Visa Sponsorship?

Yes

Government Clearance Required?

No

Job Posting End Date