Commission Model & Automation Consultant (SOW Engagement)

Location: Remote (UK-based)

Fee structure: Day rate

Company

hirify.global operates in the education and skills sector.

What you will do

• Design the 2027 sales commission framework, including rates, thresholds, accelerators, product weighting, shared-credit rules, and leaver/joiner logic.
• Model plan costs, OTE scenarios, and affordability with Finance to prepare a commercial proposal for approval.
• Architect and build an automated calculation engine using SQL views, a cloud data warehouse, HubSpot, Google Sheets, Apps Script, and Make.com.
• Replace the current manual processing across approximately 50 workbooks with automated data transformation, calculations, reconciliation, and auditability.
• Run interim monthly calculations and payout reconciliations during the eight-week project to validate live data accuracy.
• Document the logic, edge cases, operational procedures, and handover materials for the internal team.

Requirements

• Deep expertise in complex incentive and commission structures, including tiered accelerators, ramp, proration, and clawbacks.
• Advanced proficiency with SQL, Google Sheets or Excel, HubSpot administration, Make.com webhooks and APIs, and Apps Script.
• Strong commercial and financial modeling skills, including cost-of-plan and scenario modeling.
• Ability to work autonomously and deliver outcomes from day one without an onboarding period.
• UK-based remote engagement with delivery against agreed project milestones.

Nice to have

• Familiarity with Xero, Fivetran or ELT workflows, or revenue models in the education and skills sectors.

Culture & Benefits

• Fixed-scope consultancy project with an estimated eight-week duration.
• Autonomy over how, when, and where deliverables are completed, subject to milestones and client integration points.
• Outside IR35 B2B services agreement on a deliverable basis.
• Consultant provides their own equipment and is responsible for correcting defective deliverables at their own expense.
• Right to provide a qualified substitute, subject to equivalent skills and security checks.

Hiring process

• Delivery is structured around four milestones: process audit by week 2, draft model and costings by week 4, final sign-off by week 6, and tested automated engine handover by week 8.