Sales Compensation Analyst
Core
Design, optimize, and maintain database schemas, ETL pipelines, and data warehouse staging layers for massive sales compensation and billing data to feed calculation engines and BI platforms.
Role type
Senior IC data engineer (sales compensation systems)
Builds
Production data pipelines and database schemas for sales compensation
Domain
Financial services / Sales compensation / Data engineering
Required skills
SQL (complex joins, CTEs, window functions, stored procedures), Python (Pandas, SQLAlchemy), Data Warehousing (Snowflake, BigQuery, Redshift, Azure Synapse), ETL orchestration (Airflow, SSIS, Alteryx), Git, SOX compliance
Preferred skills
Experience with Salesforce CRM integration, automated regression testing, root cause analysis of data anomalies
Technologies
Snowflake, Azure, SQL Server, Salesforce, Alteryx, Airflow, SSIS, Git, Python, Pandas, NumPy
Responsibilities
Design and optimize relational database tables, views, and stored procedures for large sales compensation datasets; Build and maintain automated data integration pipelines using SQL and Python; Monitor batch runs and resolve runtime errors or API ingest exceptions; Lead technical root cause investigations on systemic calculation anomalies; Implement technical change control processes and maintain version-controlled code repositories
Seniority
Senior, hands-on IC
