Precision Cosmology With Inaccurate Data: Assessing And Addressing Systematic Errors In Large-Scale Structure