Sounds like you will be cut out of the deal. It's a great idea, but the club has a lot of exposure, if the cars don't get done on time or messed up they look really bad. In MN it won't be a year-round thing (unless they have a garage that could be used...could be, for the golf carts), so they won't hire someone (as an employee) to do detailing, they will look for a pro who will work onsite and give them a cut (effectively discounting his rate). There is no way that they will let you "help" the pro that they have hired, unless it's your father or something that owns the club, LOL. If you don't work every day, you might try asking if it would be alright if you on your own, asked some of the patrons if you could detail their cars while they golf, and that your detailing business is not affiliated with the club. The club will still likely charge you, and they would be clear of any liability...just possibly some bad press. If I were them, I would never let you do it (as an employee), I would want a pro who is insured, etc.
It might be better to get some more experience and THEN approach the club about it, saying you would like to be their pro detailer, etc.