Sales Compensation Systems Architect & Data Pipelines

SMP GLOBAL PTE. LTD.; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

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.

Qualifications

• 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.

Responsibilities

• 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.

Skills

SQL mastery

Python (Pandas)

Alteryx

Data warehousing

Cross-functional collaboration

SOX/compliance awareness

Tools

Snowflake

Azure Synapse

SQL Server

Airflow

SSIS

Job description

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.