Quantum chemistry and quantum simulation at scale : leveraging modern computing paradigms and hardware