I'm a civil engineer with over 25 years of experience. I thrive on the project management and client relations portion of the business. In looking at a career transition I'm thinking of getting a MBA to help shift away from design/technical and more into a business advisory role, specifically with the idea of helping my clients meet their sustainability and or energy transition goals. Are there specific schools that would help with this endeavour? I'm needing to study in the UK (part-time/Executive MBA).

Would an MBA have much relevance? How about the Cambridge sustainability masters? https://www.cisl.cam.ac.uk/education/postgraduate-study/overview-our-part-time-masters-level-sustainability-leadership-built