I do my squats and yes my tiny butt looks better but it is not what I was hoping for… do I need to add weight to my squats to gain the desired result?

Try doing it anyways & see what you get & if you find you did not achieve your desired results for your buttocks then go back to the drawing board & find out what works for u. And if u need additional help then ask a trainer about what workouts are best for your body to achieve your desired results for your body.