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.