Gartner→
Variable Compensation Territory Specialist at Gartner in Irving, TX
Entry LevelHybridFull-timeIrving, TX$56k–$78k/yr
Skills
excelsqlsaas commission applicationdata validationdata quality checkscompensation plan understandingdata analysiscommission calculation reconciliationlistening
Job Description
Summary: Gartner is a leading research and advisory company, and they are seeking a Variable Compensation Territory Specialist to support the administration of various compensation plans. The role involves managing commission applications, performing data analysis, and collaborating with sales associates to ensure payment integrity and process improvements.
Responsibilities:
- Complete recurring manual tasks for processes not systematically automated, frequent use of Excel, SQL, SaaS commission application
- Maintain commission application by performing a variety of data inputs, perform validation and data quality checks on both data imports and exports
- Identify and research inconsistencies to determine root causes and offer proposals for remediation
- Review monthly commission payments, confirm commission calculations by reconciling data to source systems, and sign-off on payment integrity
- Interact with Sales associates and leadership to explain and assist in the understanding of sales performance, commission calculations, and reporting
- Complete Ad-hoc analyses for Variable Compensation Leadership and various business partners
- Recommend process improvement and system enhancements
- Implement, and test system enhancements as needed
- Collaborate between multiple financial, sales, and operational departments
- Coordinate and complete additional projects as requested
Required Qualifications:
- 1 year of relevant experience
- Moderate Excel skills; proficient in various lookup types, conditional functions, concatenations, if functions, pivot tables, advanced filters and sort
- Understanding of SQL, basic query writing and use of pre-written templates
- Strong problem-solving skills, curious mindset
- Comfortable working with large data sets from multiple sources
- Ability to understand compensation plan elements
- Excellent verbal and written communication skills, effective listening skills
- Willingness to take the initiative and accept new projects in proactive manner
- Excellent organization & time management skills
Required Skills: Excel, SQL, SaaS commission application, Data validation, Data quality checks, Compensation plan understanding, Data analysis, Commission calculation reconciliation, Listening
Benefits: Generous PTO, A 401k match up to $7,200 per year, The opportunity to purchase company stock at a discount
Benefits
Generous PTO
A 401k match up to $7,200 per year
The opportunity to purchase company stock at a discount