Does this pump need mains power on site?

No — it runs on its own diesel engine, making it suited to sites without a reliable power connection yet.