Hydrochemical analysis is crucial for understanding soil and water composition dynamics in coastal aquifers. This study presents a novel framework for the comprehensive assessment of groundwater quality, integrating multivariate analysis and hydrochemical techniques. It comprises seven stages aimed at characterizing physicochemical properties, identifying water constituents, elucidating dominant mechanisms in water composition, evaluating ion exchange processes, analyzing spatial distribution of components, identifying impacting processes, and assessing drinking water quality. The framework was applied to the coastal unconfined Arroyo Grande aquifer in Cartagena, Colombia. Fifteen points were sampled, assessing physicochemical parameters such as total hardness, alkalinity, pH, temperature, electrical conductivity, anions, cations, among others. Findings reveal the presence of dominant anions including bicarbonate, chloride, and sulfate, with relevant variations observed between the dry and wet season, with manganese and iron surpassing WHO drinking water standards. The prevalence of these constituents has been attributed to mineral dissolution, ion exchange, salinization due to seawater intrusion, and anthropogenic contamination. Over 50% of samples in both seasons fail to meet freshwater drinking standards due to elevated dissolved mineral concentrations in groundwater. These findings provide insights for sustainable management and mitigation strategies, and the systematic approach enables researchers to identify key factors influencing water composition.