It may still help, but the value of the referral depends on the firm's process and how well the person can credibly endorse you. Do not assume all employee referrals carry identical weight.

Someone in a corporate function can still know your work or character well, but they may have less visibility into consulting recruiting expectations than a consultant in your target office.

If the person knows you well and is willing to refer you, that is different from asking a distant employee solely because they work at the firm.

Use the referral if it is genuine, but keep the rest of the application strong. A referral is not a substitute for the resume, assessment or interview process. For more detail, see the consulting networking guide.

I would care more about whether they actually know you than whether their title says consultant.