Project Specialist - Compensation Data at Aston Carter

Santa Monica, California, United States -

Full Time

Start Date

Immediate

Expiry Date

29 May, 26

Salary

35.0

Posted On

28 Feb, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Project Management, SQL, Python, Excel, PowerQuery, Data Quality Checks, Data Uploads, Troubleshooting, Backend Configuration, Communication, Documentation, Incentive Compensation Management, XLOOKUP, INDEX MATCH

Industry

Staffing and Recruiting

Description

Job Title: Project Specialist - Compensation DataJob Description This role is responsible for the end-to-end data operations that power our variable compensation programs, including Monthly Commissions, Quarterly Individual Bonuses, and Quarterly Team Bonuses. The Project Specialist will manage the transition and ongoing maintenance of our variable compensation data pipeline from existing source systems, such as Sales and HR, into a new incentive compensation management tool. Additionally, this role will function as the technical and functional administrator for Performio, handling data uploads, troubleshooting issues, maintaining backend configurations, and providing timely support to stakeholders. Responsibilities Download data from multiple sources, assemble in Excel using PowerQuery, and perform data quality checks. Upload data into the client's website tool. Enter data adjustments in the backend of the website based on manager emails. Export, review data quality, and submit to stakeholder teams, such as Payroll. Serve as the main communication point for managers, ensuring requests are accurately entered into the website tool. Distribute communication to all stakeholders, encompassing a few hundred recipients. Track progress against a predetermined calendar, initiating cyclical payment processes each month and quarter, while managing independent timelines. Organize documentation of all processes to ensure all systems are using the most up-to-date Incentive Agreements. Essential Skills Strong project management skills. High proficiency in SQL is highly preferred. Familiarity with SQL and Python is beneficial, as acquiring these skills implies a lot of necessary knowledge. Experience with Excel, particularly XLOOKUP or INDEX MATCH functions. Additional Skills & Qualifications Experience with Snowflake is a plus but not required. Excel skills have a wide range in the market and are considered easy to teach if lacking. Work Environment The work environment involves the use of various technologies and tools, such as Excel and the Performio system, to manage data operations efficiently. The role requires effective communication and organization to coordinate with multiple stakeholders. The work involves cyclical timelines for data processing and documentation to maintain accurate records of incentive agreements. Job Type & Location This is a Contract position based out of Santa Monica, CA. Pay and Benefits The pay range for this position is $30.00 - $35.00/hr. Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: • Medical, dental & vision • Critical Illness, Accident, and Hospital • 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available • Life Insurance (Voluntary Life & AD&D for the employee and dependents) • Short and long-term disability • Health Spending Account (HSA) • Transportation benefits • Employee Assistance Program • Time Off/Leave (PTO, Vacation or Sick Leave) Workplace Type This is a hybrid position in Santa Monica,CA. Application Deadline This position is anticipated to close on Mar 4, 2026. About Aston Carter: Aston Carter provides world-class corporate talent solutions to thousands of clients across the globe. Specialized in accounting, finance, human resources, talent acquisition, procurement, supply chain and select administrative professions, we extend the capabilities of industry-leading companies. We draw on our deep recruiting expertise and expansive network to meet the evolving needs of our clients and talent community with agility and excellence. With offices across the U.S., Canada, Asia Pacific and Europe, Aston Carter serves many of the Fortune 500. We are proud to be a ClearlyRated Best of Staffing® double diamond winner for both client and talent service. The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law. If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please email astoncarteraccommodation@astoncarter.com for other accommodation options.

Responsibilities

This role manages end-to-end data operations for variable compensation programs, including commissions and bonuses, by overseeing the data pipeline transition into a new incentive compensation management tool. The specialist will also function as the technical and functional administrator for the Performio system, handling data uploads, configurations, and stakeholder support.