Vertical

Admin

Description

Summer: responsible for the end‑to‑end data operations that power our variable compensation programs, including Monthly Commissions, Quarterly Individual Bonuses, and Quarterly Team Bonuses. This role will own the transition & ongoing maintenance of our variable compensation data pipeline from existing source systems (Sales, HR) into a new incentive compensation management tool. This role will serve as the functional & technical admin for Performio—managing data uploads, troubleshooting issues, maintaining configuration on the backend, and providing timely support to stakeholders

Key Responsibilities

Data Management

Download data from multiple sources, assemble in Excel using PowerQuery, and perform data quality checks.

Upload data into website tool

Enter data adjustments in backend of website per Manager emails.

Export, review data quality & submit to stakeholder teams (e.g. Payroll)

Point of Contact

Serve as the main communication point for managers, fielding responses from many different stakeholders to ensure their requests are entered into our website tool.

Distribute communication to all stakeholders, spanning a few hundred recipients.

Project Management

Track progress against a pre-determined calendar, initiating cyclical payment processes each month, quarter, and trimester.

Track independent timelines that may overlap at different times.

Organize documentation of all processes, to ensure all systems are using up-to-date Incentive Agreements.

Qualifications:

Technical Skills

SQL (highly preferred)

Familiarity with SQL would be very beneficial. A certified skill here would be great to see.

Python (preferred)

If someone has SQL and python experience, I think in order to acquire these two skills there is a lot of implied knowledge to get here that would be beneficial.

Plus, not a requirement.

Snowflake (plus)

Snowflake would be a plus if anyone has familiarity. It is not an issue if they do not have experience.

Excel (plus)

If a candidate has keywords like XLOOKUP or INDEX MATCH in their Excel experience, that would be great.

The range in market for Excel skills is incredibly wide. I would be fine with someone with more experience in other areas, as this is an easy skill for me to teach.

Soft-Skill Requirements

Detailed