Data Analyst - Finance

About Us:

Planet is a leading technology company transforming payments by putting customer experience first.

We offer integrated solutions that include payment processing, VAT refunds, dynamic currency conversion, and management services for merchants in the Retail and Hospitality sectors worldwide.

In recent years, we have experienced significant growth, expanding our services and global presence.

With strong private equity investors, Advent International and Eurazeo, we have the financial capital and expertise to grow our capabilities and reach through acquisitions.

Our mission is to create a world of connected commerce where payments are simple, secure, and seamless, enabling our partners to deliver exceptional experiences to their customers.

Function Overview 
Join our dynamic team as a Data Analyst - Finance, where you'll play a critical role in ensuring accurate commission payouts for a high-performing sales organization. You'll manage everything from commission calculations and reporting to troubleshooting and process improvements, all while collaborating closely with our Sales, Finance and Data teams.  This role requires a blend of technical expertise in data engineering and in-depth knowledge of commission structures, ensuring accurate, efficient, and scalable solutions.
If you thrive in a fast-paced environment, have a passion for data accuracy, and enjoy identifying efficiencies, this role is your opportunity to make a meaningful impact. Bring your Excel skills, analytical mindset, and enthusiasm for teamwork to help us deliver exceptional results!
 

What you'll do

Administration:

•    Responsible for all aspects of day-to-day commission administration resulting in accurate and timely commission payments.
•    Create, validate and audit monthly reports to ensure accuracy and completeness of commissions crediting and payout results.
•    Respond to compensation related inquiries from the Sales Team in an effective and timely manner.
•    Perform configuration, testing and other support activities related to plan, quota, and policy changes
•    Manage Sales Promotion, bonus and SPIFF payments.
•    Prepare key monthly commission reconciliation reports including reporting of monthly commission and sales attainment metrics.

Data Engineering and Modelling:
•    Design and implement scalable solutions for the commission’s calculator, ensuring accurate processing of complex commission structures.
•    Build and maintain robust data pipelines and workflows to support real-time and batch processing of commission data.
•    Integrate data from multiple sources, such as Salesforce, Snowflake, and legacy systems, to ensure seamless commission calculations.
•    Develop and maintain data models that support the commission engine’s requirements.

Testing and Validation:
•    Develop rigorous testing frameworks to validate the accuracy of commissions calculations.
•    Troubleshoot and resolve calculation and/or data errors.
•    Perform QA and troubleshoot discrepancies in commission results, implementing fixes as needed.
•    Governance and Collaboration:
•    Ensure compliance with data governance and security standards in all processes.
•    Create comprehensive documentation for the commission’s calculator, including workflows, data models, and calculation logic.
•    Work closely with Finance, Sales, and Data teams to understand commission structures and business requirements.
•    Collaborate with BI teams to deliver reporting solutions that provide clear visibility into commissions calculations and outcomes.

Governance and Collaboration:
•    Ensure compliance with data governance and security standards in all processes.
•    Create comprehensive documentation for the commission’s calculator, including workflows, data models, and calculation logic.
•    Work closely with Finance, Sales, and Data teams to understand commission structures and business requirements.
•    Collaborate with BI teams to deliver reporting solutions that provide clear visibility into commissions calculations and outcomes.
 

Who you are

•    Education: University educated in Business, Accounting or related field or equivalent work experience.
•    Commissions: 3+ years' experience in commission processing or business/finance analyst function for a high growth sales team, preferably in the payments or financial services industry.
•    PowerBI: Advanced expertise in PowerBI is essential, including experience with DAX, building automated reports, and creating complex, data-driven dashboards.
•    SQL: Strong proficiency in SQL, with experience working with large datasets in a cloud-based environment (Snowflake).
•    Data Modelling: Experience with data modelling and data pipeline processes (using dbt or equivalent).
•    Cloud Platforms: Experience with cloud data platforms (Snowflake, Azure as a plus).
•    ETL: Basic knowledge of ETL processes and experience working with data engineers to contribute to scalable solutions. Familiarity with GitHub for managing code and version control.
•    Azure: Experience with Azure cloud services.
•    Python (or Java): Proficiency in programming languages such as Python or Java for building and automating workflows.
•    Data Governance: Understanding of data governance and security best practices.
•    Excel: Advanced skills are a requirement.

Nice to Have:

•    Commissions Software: Commission software experience is a plus (ie. Spiff, Xactly, etc.). 
•    Certifications: certification in data engineering or analytics (e.g., Microsoft Certified: Data Engineer, AWS Certified Data Analytics).

Why Planet:

Planet is an equal opportunity employer where diversity is valued, and all employment is decided based on qualifications, merit, and business need.

Come and grow your career in the most exciting, fast paced technology market, with a business that delivers feel-good connected commerce. We would love to hear from you – Apply now.

At Planet, we embrace a hybrid work model, with three days a week in the office.
 

Reasonable accommodations may be made in order to allow for an individual to perform the essential functions of this role successfully.