Is night work going to affect my sleep and health?

It may: We are adapted to the light/dark cycle by circadian (about 24 hours) rhythm. Night duty means that you have to readapt to a reversal of this timing of activity/sleep and some people cannot do this. Exercise and a good diet to maintain health is your best method of enabling this readaptatation to occur.

Yes: 7-8 hours of restful and restorative sleep in tune with the natural daylight cycle and the body's normal circadian rhythms is ideal for almost everyone. Any interruption or change in that pattern is associated with higher risk of health issues. Night shift workers clearly have a higher risk of developing chronic disease, impaired cognitive function, impaired memory, depression, etc.