Detection Engineering at Scale: A Framework for Autonomous Security Operations