The Treasury Consultant role involves supporting revenue initiatives, providing technical expertise on treasury products, and ensuring effective communication with clients and bank resellers, including conducting demos and pricing recommendations.