Only a few of the NESCAC schools offer merit aid and it is, of course, very competitive. It will not go to an athlete just because the coach wants him (in fact, merit aid to athletes is scrutinized because it doesn’t want to seem like athletic aid).
But there are lots of schools that do give athletic aid, merit aid, or need based grants. You just have to find the right academic, athletic and financial fit.