Commercial Operations Analyst

Pandr Outsourcing; Legazpi; On-site; PHP 360,000 - 600,000; Full time

Job summary

Pandr Outsourcing in the Philippines seeks a Sales Operations Analyst to join a small, high‑impact Business Operations team. You will support three areas: Commission Operations, Commercial Analytics and Pricing, and Operational Coordination, ensuring accuracy and timely delivery of data across systems such as Salesforce, Excel, Jira, Asana, and Confluence.

Key duties include calculating non-platform commission payouts, maintaining data workbooks, uploading and reconciling data in Salesforce,

Responsibilities

• Commission Operations: Calculate and check manual commission payouts outside the platform (CaptivateIQ).
• Maintain commission data workbooks and assist in stabilizing them.
• Prepare monthly and quarterly uploads to the commission platform and Salesforce.
• Apply plan rules, track questions, and document manual processes.
• Support the commissions dashboard and status reporting.
• Commercial Analytics and Pricing Support: Maintain pricing templates and rate cards; update Salesforce-based tools.
• Refresh Salesforce reports and dashboards; maintain reporting library.
• Data hygiene and bulk updates; run reconciliations; build first-draft analyses.
• Operational Coordination: Triage Jira queue; manage calendars and meeting logistics.
• Take meeting notes and share concise recaps; track action items in Asana.
• Maintain SOPs and Confluence; share people changes for productivity calculations.
• Prepare monthly team updates and rollout communications; run internal surveys.

Job 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 elevate 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