Back to search

Commercial Operations Analyst

Support commission processing, analytics, and operational coordination for a global advisory and commercial services organization.

  • Legazpi City, Albay, Philippines
  • Posted Nov 9, 2026
INDUSTRYSales & Business DevelopmentB2B Sales

Responsibilities

  • Calculate and check manual commission payouts
  • Maintain commission data workbooks
  • Prepare monthly and quarterly uploads to commission platform and Salesforce
  • Apply plan rules and track commission questions
  • Support commissions dashboard
  • Maintain consulting pricing template and project cost rates
  • Update rate cards and billable rates
  • Refresh and quality-check Salesforce reports and dashboards
  • Support data hygiene and bulk updates
  • Run monthly reconciliations between Salesforce and finance/ERP systems
  • Pull data and build analyses for planning requests
  • Support onboarding and offboarding steps in commercial systems
  • Own triage of the team's Jira service-desk queue
  • Manage calendars and meeting logistics
  • Take meeting notes and send recaps
  • Track action items in Asana
  • Maintain process documentation and SOPs
  • Help prepare monthly team update digests
  • Run recurring internal surveys and feedback cycles
  • Use AI tools in day-to-day work

Requirements

  • Bachelor's degree in Accounting, Finance, Business, Economics, Data Analytics, or a related field
  • Experience in a Sales Operations
  • Experience in a Revenue Operations
  • Experience in a Business Operations
  • Experience in a Finance Operations
  • Experience in a Payroll/Commissions

Nice to have: Incentive compensation tools (CaptivateIQ, Spiff, Xactly), Salesforce Data Loader, Tableau, Confluence, Box, Project/professional-services pricing, Rate cards, Cost models, Commodities or advisory-services markets

Skills

Advanced Excel/Google SheetsSalesforce reportingData validationReconciliationPivot tablesXLOOKUP/INDEX-MATCHNested IF/tiered logicTicketing or task management tool (Jira, Asana)Google WorkspaceSalesforceCaptivateIQExcel/Google SheetsJira Service ManagementAsanaConfluenceGoogle WorkspaceSlackBoxTableauAI assistants

Benefits

  • 21 leave credits plus all client-based holidays
  • HMO coverage with dependent benefits

Full description

ABOUT THE ROLE We are hiring a Sales Operations Analyst to join a small, high-impact Business Operations team at a global advisory and commercial services organization. You will support three areas: Commission Operations: Running and checking the manual parts of the sales commission process. Commercial Analytics and Pricing Support: Keeping pricing templates, rate cards, dashboards, and reports accurate and current. Operational Coordination: Managing the internal service-desk ticket queue, scheduling and calendar management, meeting notes, recaps, and process documentation. WHAT YOU WILL DO Commission Operations (About 25%) Working alongside the Senior Reporting Analyst, you will: Calculate and check manual commission payouts that sit outside the commission platform (CaptivateIQ). These include tiered referral splits (25/50/75%), forward-sales alternative structures (upfront and deferred payments), partner commissions, specialist and marketplace plans, success-fee payments, and commission advance recoupment. Maintain the commission data workbooks (e.g., alternative-structure and internal-referral workbooks), and help repair and stabilize them. Prepare monthly and quarterly uploads to the commission platform and Salesforce, and reconcile them against gross profit, payment receipts, and deal IDs. Apply plan rules correctly, including tier breakpoints, rate tables, caps per transaction, and payment timing (on close, on payment receipt, quarterly, and semi-annual). Track commission questions and corrections, prepare statements for sign-off, and help document every manual process so it can be standardized or automated over time. Support the commissions dashboard and the "paid / pending / missing" status reporting. Commercial Analytics and Pricing Support (About 35%) Maintain the consulting pricing template and project cost rates (Excel/Box). Update rate cards and billable rates after promotions, new roles, or rate changes, and coordinate related updates in the Salesforce-based project management tool. Refresh and quality-check Salesforce reports and dashboards (regional, vertical, product, and leadership KPI dashboards) and keep the reporting library up to date. Support data hygiene by identifying outdated close dates, missing fields, and inconsistent records; bulk-update data using Data Loader or similar tools; and follow up with record owners when needed. Run monthly reconciliations between Salesforce and finance/ERP systems, and support gross profit uploads. Pull data and build first-draft analyses for planning requests, such as vertical performance, deal size, sales cycle, and pipeline views. Support onboarding and offboarding steps in commercial systems (Salesforce, project management tool, LMS), and share people changes with reporting so productivity calculations stay accurate. Operational Coordination and Enablement (About 40%) Own triage of the team's Jira service-desk queue: categorize, route, resolve routine requests, and escalate the rest with clear context. Manage calendars and meeting logistics for recurring team forums (weekly team meetings, director and manager meetings, and all-hands segments), including invitations, agendas, and attendee updates. Take meeting notes and send concise recaps with decisions, owners, and due dates. Track action items in Asana. Maintain process documentation, SOPs, and the team's Confluence pages and shared drives so the latest version of each process is easy to find. Help prepare monthly team update digests, rollout communications, short tutorials, and slide updates. Run recurring internal surveys and feedback cycles (e.g., Google Forms and Salesforce surveys) and consolidate results. Use AI tools in day-to-day work (summaries, drafting, data preparation) within company guidelines. Requirements WHAT YOU WILL BRING Required 3+ years in sales operations, revenue operations, business operations, finance operations, payroll/commissions, or a similar analytical support role, ideally supporting a US or European company. Advanced Excel/Google Sheets skills, including XLOOKUP/INDEX-MATCH, pivot tables, nested IF/tiered logic, data validation, and reconciliation. Hands-on Salesforce experience as a reporting user, including building reports and dashboards, and exporting and importing data. A careful, accuracy-first approach to working with confidential compensation data. Strong written and spoken English. Ability to write clear, concise meeting recaps that busy executives can easily read. Experience working with a ticketing or task management tool (Jira, Asana, or similar) and Google Workspace. Preferred Experience with incentive compensation tools (CaptivateIQ, Spiff, Xactly, or similar). Experience with Salesforce Data Loader, Salesforce Inspector, or other bulk data tools. Exposure to Tableau or another BI tool. Experience with Confluence, Box, or knowledge-base management. Experience with project/professional-services pricing, rate cards, or cost models. Familiarity with commodities or advisory-services markets (helpful, not required). A bachelor's degree in Accounting, Finance, Business, Economics, Data Analytics, or a related field. HOW YOU WILL BE MEASURED (FIRST 6–12 MONTHS) Manual commission calculations delivered on time and accurately, with fewer corrections and commission tickets over time. Documented SOPs for every manual commission process you support. Jira queue response and resolution times kept within the agreed service levels. Pricing templates, rate cards, and core dashboards kept current with no stale data. Meeting recaps sent within 24 hours, with clear owners and dates. TOOLS YOU WILL USE Salesforce CaptivateIQ Excel/Google Sheets Jira Service Management Asana Confluence Google Workspace (Calendar, Drive, Forms, Meet) Slack Box Tableau AI assistants Benefits WHY JOIN US? Enjoy a healthy, supportive, and conducive work environment at a Great Place to Work™ Certified company for five consecutive years! Be part of an innovative organization delivering cutting-edge solutions across multiple industries. Work in a fast-paced, high-growth environment with opportunities to take on meaningful responsibilities. Receive a competitive salary with opportunities for career advancement. Thrive in a collaborative and forward-thinking work culture. Enjoy 21 leave credits plus all client-based holidays. Receive HMO coverage with dependent benefits. Gain exposure to world-class leadership from both local and international supervisors. Ready to take the next step in your career? Apply now!

Commercial Operations Analyst at pandroutsourcing | Referso Jobs