Within concrete engineering, the uptake of self-compacting concrete (SCC) represents a notable trend, delivering improved workability and placement efficiency. However, challenges persist, notably in achieving optimal performance while mitigating environmental impacts, particularly in cement consumption. However, simply reducing the cement content in the mix design can directly compromise the structural-concrete requirements. Towards these challenges, global trends emphasize the utilization of appropriate waste materials in blended concrete. This study explored a promising strategy by integrating supplementary cementitious materials (SCMs) to contribute to the United Nations' Sustainable Development Goals (SDGs) in addition to the engineering contributions. It suggests an optimal combination of Metakaolin (MK) and Limestone Powder (LP) to partially substitute cement. The research methodology employs the response surface method (RSM) to systematically explore the ideal ingredient ratios. Through a comprehensive analysis of orthogonal array of 16 mixes, encompassing both mixture and process variables, this study aims to explain the effects of MK and LP addition on the rheological and mechanical properties of SCC with varying cement replacement levels. In terms of mixture constituents, the total composition of cement, MK, and LP was fixed at 100%, while coarse aggregate (CA), fine aggregate (FA), and the water-to-binder ratio were held as process variables. In order to assess the rheological properties of the mix-design, various tests including slump flow, L-box, and sieve segregation were conducted. Additionally, to evaluate mechanical strength, samples were tested for compressive strength at both 7 and 28 days. Findings from the experiments reveal higher concentrations of MK result in reduced workability and hardened properties. Through RSM-based designed experimentation covering both rheological and mechanical aspects, it is observed that the optimal cement replacement level lies between 40 and 55%. The findings of this study contribute to the advancement of sustainable and structurally robust concrete practices, offering insights into the optimal utilization of SCMs to meet both engineering requirements and environmental sustainability goals.