Drinking a soda a day shouldn't harm your kidneys as long as you drink water, tea or other healthy drinks along with that soda during that day.
So yes consuming too much soda as in 2 to 3 or more sodas per day could damage your kidneys and cause kidney failure overtime.
So if you want to drink soda make sure you drink other healthy drinks along with the soda to keep your kidney's healthy.