Overview
The Commission Model & Automation Consultant will oversee the design and implementation of an updated sales commission framework and automated calculation engine for the organization. This remote engagement will span approximately eight weeks, requiring a consultant with specialized skills in complex incentive structures and financial modeling to ensure successful project delivery based on set milestones. The consultant will work independently, collaborating closely with finance teams to create a robust and efficient commission policy and operational documentation.
Responsibilities
- Design the 2027 sales commission framework including rates and thresholds.
- Model costs and scenarios in collaboration with finance for commercial proposal.
- Draft and finalize the official commission policy document.
- Architect and build the end-to-end calculation engine using SQL and other tools.
- Automate data transformation and calculation processes to reduce manual work.
- Execute interim monthly calculations and validation during the project.
- Produce comprehensive documentation, logic maps, and operational runbooks.
Requirements
- Deep expertise in designing complex commission structures with tiered accelerators.
- Proficiency in SQL, Google Sheets/Excel, and HubSpot administration.
- Experience with automation tools like Make.com (webhooks/APIs) and Apps Script.
- Strong capability in commercial and financial modeling.
- Ability to work independently without an onboarding period.
- Familiarity with Xero and educational revenue models is a plus.