Sales Compensation Analyst

SMP GLOBAL PTE. LTD.; Singapore; Presencial; SGD 120.000 - 180.000; Jornada completa

Descripción de la vacante

SMP GLOBAL PTE. LTD. is seeking a Sales Compensation Analyst (Systems Architecture & Data Pipelines) to design, optimize, and maintain database schemas and ETL pipelines for large sales data. You will ensure clean data feeds to downstream engines and BI platforms, collaborating with Finance, Revenue Operations, and Technology teams.

The role focuses on automating data integration, governing data quality, and ensuring SOX-compliant practices while supporting financial close cycles.

Formación

• 4–7+ years in database development, data engineering, or finance systems.
• Advanced SQL proficiency including complex joins, CTEs, window functions.
• Strong Python (Pandas/SQLAlchemy) or Alteryx for data transformations.
• Experience with enterprise cloud warehouses (Snowflake, Synapse, Redshift).
• Ability to liaise with IT, Data Eng, and Finance teams to drive requirements.
• Translate complex commercial deals into clean data structures.

Responsabilidades

• Design, build, and optimize relational tables, views, and stored procedures for large datasets.
• Collaborate with BI/Data Eng to evaluate data warehouse architecture.
• Optimize heavy extraction queries and indexing for near-term close windows.
• Identify bottlenecks, drift, and ingestion lags between CRM, billing, and engines.
• Build and maintain ETL pipelines using SQL, Python, and orchestration tools.
• Transform multi-source data into dimensional models (Fact/Dimension).
• Monitor batch runs, resolve runtime errors and API ingest issues.
• Implement automated failover, alerts, and logging for data quality.
• Lead root-cause analyses of data issues and fix schemas as needed.
• Document architecture, ERDs, and data dictionaries.

Conocimientos

SQL mastery

Python (Pandas)

Alteryx

Data warehousing

Cross-functional collaboration

SOX/compliance awareness

Herramientas

Snowflake

Azure Synapse

SQL Server

Airflow

SSIS

Descripción del empleo

Sales Compensation Analyst (Systems Architecture & Data Pipelines)

Role Overview:

The Sales Compensation Analyst (Systems Architecture & Data Pipelines) serves as a key technical developer and systems specialist bridging Finance, Revenue Operations, and Technology. In this role, you will be responsible for designing, optimizing, and maintaining database schemas, ETL pipelines, and data warehouse staging layers that ingest massive volumes of commercial transaction and billing data. You will ensure that downstream calculation engines and BI platforms receive performant, validated, and normalized data feeds.

Key Responsibilities:

Database Schema Design & Pipeline Optimization

• Design, build, and optimize relational database tables, views, indexed views, and stored procedures supporting large sales compensation datasets.
• Partner with Business Intelligence and Data Engineering teams to evaluate data warehouse architecture (Snowflake/Azure/SQL Server), contributing to schema evolution and data dictionary updates.
• Optimize heavy data extraction queries, indexing strategies, and execution plans to minimize batch processing runtimes during critical financial close windows.
• Identify and eliminate pipeline bottlenecks, schema drift, and data ingestion lags between CRM systems (Salesforce), billing platforms, and compensation calculation engines.

Automated ETL & Integration Workflows

• Build, deploy, and maintain robust data integration pipelines using SQL, Python (Pandas/NumPy), and workflow orchestration tools (e.g., Alteryx, Airflow, or SSIS).
• Engineer automated data transformation steps that map unstructured and multi-source commercial data into standardized dimensional models (Fact/Dimension schemas).
• Monitor scheduled data batch runs, resolving runtime errors, connection dropouts, and API ingest exceptions immediately.
• Build automated failover, alerting, and logging mechanisms that trigger automated notifications whenever staging tables show row count disparities or anomalous data types.

Systemic Data Diagnostics & Root Cause Analysis

• Lead technical root cause investigations on systemic calculation anomalies originating from data ingestion bugs, logic mismatches, or source-system schema modifications.
• Trace transaction histories through staging layers and transformation scripts back to initial CRM transaction entries to verify data lineage and accuracy.
• Deploy automated regression testing scripts to validate that new system deployments, CRM updates, or database schema enhancements do not disrupt compensation tables.

Governance, Controls & SOX Compliance

• Implement technical change control processes for database objects, maintaining version-controlled code repositories (Git) for all production scripts and schemas.
• Ensure all database tables and pipelines adhere strictly to internal SOX-compliance protocols, maintaining automated lineage tracking and immutable audit logs.
• Document detailed technical architecture specifications, entity-relationship diagrams (ERDs), and data dictionary definitions.

What We’re Looking For:

• Experience: 4–7+ years of hands-on technical experience in database development, data engineering, financial systems, or complex sales compensation systems.
• SQL Mastery: Advanced proficiency in SQL (writing complex joins, CTEs, window functions, stored procedures, dynamic SQL, and query tuning).
• Scripting & Automation: Strong practical experience in Python (Pandas/SQLAlchemy) or Alteryx for automated data transformations and pipeline builds.
• Data Warehousing: Experience working with enterprise cloud data warehouses (e.g., Snowflake, Google BigQuery, AWS Redshift, or Microsoft Azure Synapse).
• Cross-Functional Collaboration: Demonstrated ability to liaise effectively with IT, Data Engineering, and Finance stakeholders to drive technical requirements.
• Commercial Deal Translation: Ability to interpret complex commercial deal structures, including joint/split deals and strategic accounts, and translate them into clean, structured, repeatable data frameworks for system processing.