# Sales Compensation Analyst (Pipeline Operations & Data Integrity)

**Company**: S&P Global
**Location**: Penang-Jalan, MYS
**Experience**: mid
**Job type**: full-time
**Category**: Finance
**Industry**: Finance

**Apply**: https://spgi.wd5.myworkdayjobs.com/en-US/SPGI_Careers/job/Penang-Jalan-MYS/Sales-Compensation-Analyst--Pipeline-Operations---Data-Integrity-_332265-2?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply
**Canonical**: https://yubhub.co/jobs/job_e9b4e90e-954

## Description

The Sales Compensation Analyst (Pipeline Operations & Data Integrity) is an essential technical driver responsible for ensuring the operational health, daily precision, and end-to-end data integrity of the sales compensation data platform.

**Responsibilities and Impact:**

- Manage the day-to-day execution and monitoring of critical data ingestion pipelines, checking table populations across billing systems, CRM feeds, and target tables.

- Execute script-based pre-calculation validation checks daily to identify failed data syncs, malformed records, null foreign keys, and currency conversion discrepancies.

- Triage pipeline failures and data ingestion errors in real-time, working closely with global data architecture and systems teams to implement permanent fixes.

- Run, maintain, and enhance automated Python, Alteryx, and SQL reconciliation routines to verify that transactional revenue matches commission calculation inputs down to the penny.

- Detect and eliminate data discrepancies including duplicate order lines, inactive employee crediting, split-credit percentages exceeding 100%, and unmapped sales territories.

- Conduct root cause investigations on data bugs and transaction discrepancies, creating bug tickets with reproducible steps and proposing database-level logic fixes.

- Maintain and execute documented operational runbooks and Standard Operating Procedures (SOPs) for all recurring data processes, ensuring adherence to strict operational SLAs.

- Enforce SOX data controls and validation protocols across all operational cycles, ensuring that every calculation cycle is fully backed by auditable data logs and reconciliation sign-offs.

- Build and publish operational data health scorecards and pipeline status reports using Power BI and Excel, highlighting key error rates and data latency metrics to leadership.

**What We're Looking For:**

- 5+ years of technical experience in data operations, financial systems support, sales compensation analysis, or data pipeline validation.

- Advanced SQL skills, with the ability to independently write, debug, and optimize complex SQL queries.

- Hands-on experience building or maintaining automation scripts using Python (Pandas), Alteryx, or advanced VBA/macros.

- Exceptional diagnostic and troubleshooting skills with high attention to detail when working with complex financial datasets.

- Experience creating operational dashboards and reporting data in Power BI.

- Strong English communication skills (written and spoken) with experience and willing to collaborate across global time zones.

**Benefits:**

- Health & Wellness: Health care coverage designed for the mind and body.

- Flexible Downtime: Generous time off helps keep you energized for your time on.

- Continuous Learning: Access a wealth of resources to grow your career and learn valuable new skills.

- Invest in Your Future: Secure your financial future through competitive pay, retirement planning, a continuing education program with a company-matched student loan contribution, and financial wellness programs.

- Family Friendly Perks: It's not just about you. S&P Global has perks for your partners and little ones, too, with some best-in class benefits for families.

## Skills

### Required
- SQL
- Python
- Alteryx
- Power BI
- Excel
- Data Operations
- Financial Systems Support
- Sales Compensation Analysis
- Data Pipeline Validation

---

Source: [Apply at spgi.wd5.myworkdayjobs.com](https://spgi.wd5.myworkdayjobs.com/en-US/SPGI_Careers/job/Penang-Jalan-MYS/Sales-Compensation-Analyst--Pipeline-Operations---Data-Integrity-_332265-2?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply)