This study explores how small and medium-sized enterprises (SMEs) can leverage big data analytics (BDA) to gain competitive advantage (CA), highlighting the mediating role of data-driven innovation (DDI) and the foundational importance of data governance (DG) and data-driven culture (DDC). Despite the transformative potential of BDA, SMEs often struggle to translate data insights into competitive outcomes due to inadequate governance, cultural barriers, and a lack of clarity on how to operationalize analytics through innovation. Drawing on the resource-based view (RBV) and dynamic capability view (DCV), this study adopts a quantitative approach and analyzes survey data from 287 Chinese SMEs using partial least squares structural equation modeling (PLS-SEM). The results show that DG and DDC significantly enhance BDA, which directly improves CA and strongly drives DDI. DDI further mediates 61% of the total effect of BDA on CA, highlighting its key role in translating data insights into market innovation. The study advances the theoretical framework by positioning DG and DDC as valuable, scarce, inimitable and non-substitutable (VRIN) resources and DDI as a dynamic “access” mechanism. Practical insights urge SMEs to prioritize governance protocols, cultural alignment, and innovation channels to bridge the gap between analytical and competitive outcomes. Limitations include geographic focus and cross-sectional design, prompting future longitudinal and cross-industry investigations. This study provides a roadmap for SMEs to leverage data-driven strategies in turbulent markets.