The current digitalization of energy systems, particularly in urban contexts, lags behind the requirements set by urban energy system modelling, energy management, the development of digital twins, and other data-driven services. Additionally, existing energy data lacks standardized formats and coherence, hindering its full utilization. To address this challenge, this paper introduces a use case-driven design approach tailored to reflect the requirements for data integration and privacy set by city stakeholders. The objective is to design a data exchange platform (DEP) capable of serving a diverse range of use cases. This platform will facilitate the integrated utilization of energy data in energy management systems, digital twin applications, and other activities aimed at extracting valuable insights. These efforts are specifically designed to support decision-making processes of public stakeholders, private investors, and service providers. Consequently, the platform holds potential to attract additional investments in both the clean energy transition and the digitalization of energy infrastructure.