My take as an indie dev who has contracted some work out (music), and also worked on a contract basis as a programmer in the corporate world...
First, there are consulting companies (e.g. Accenture) and there are freelance consultants. With the former, you'd be an employee of the consulting company working on-site at a client company. As the latter, you're a business owner.
Second, you'd probably be more of a contractor. The difference between a contractor and a consultant is pretty well explained here:
http://www.itworld.com/Man/3859/ITW344/a Contractor is a self-employed independent businessperson who agrees (contracts) to do work for another usually for a fixed price... The individual hiring the contractor defines the desired results and the schedule... The Contractor generally retains control over the work to be done including the means and methods used to do the job, the scheduling of the underlying work, who performs the work and determines how the work will get done within the standards and time requirements set. A contractor will generally use his own tools and work equipment and may employ others to do the work for them.
As an artist, you will probably always be providing work. As a developer, the only "advice" I would need from an artist would be in the form of UI mockups or concept art.
A bit of advice: Don't let anyone ask you to work for free, or for just "exposure", and don't join any of those so-called contests where they essentially get 10 artists to provide work and only pay for one. There's nothing wrong with offering indie-friendly rates, but I see too many freelancers offer work for free to build up their portfolio, which devalues the work of all other freelance artists/musicians trying to make a living, IMO.
You might also want to visit the IndieGamer forum where many freelancers hang out.