Senior Incentives Systems Analyst

We're looking for a Senior Revenue Incentive Compensation Systems Analyst to help us build and maintain our Compensation System. You'll develop the requirements needed to implement and calculate the commission plans, bonus plans and SPIF programs within the sales compensation software, and SPIF programs by translating business requirements into technical solutions. Understanding integrations and data flow will be key to this role. In line with Hootsuite's distributed workforce strategy, our flexible work arrangement allows for remote work or a hybrid model. This role is open to applicants located in British Columbia & Ontario. In this role, you will report to the the Director, Revenue Incentives and Operations.

WHAT YOU'LL DO:

• Manage day-to-day administration and provide the operational support of the Compensation System, and ensure the viability of its integration with Salesforce.com.
• Translate business requirements into technical requirements in order to design and build commission and bonus plans, and SPIFs within the Compensation System.
• Partner with Sales and Customer leaders and the Compensation team to collect feedback from Plan participants to find ways to improve the implementation of the system and increase user adoption of the compensation system (UI design, reporting, systems interconnections).
• Audit and document processes and technical designs, and identify areas for continuous improvement of the Compensation System.
• Develop and test Connect processes and monitor data flows to and from Compensation System to ensure data integrity/accuracy. Identify opportunities for further data automation and efficiency.
• Develop technical solutions to requirements/issues; validate and communicate solutions to internal and external team members, test solutions and ensure it meets specifications.

WHAT YOU'LL NEED:

• Significant relevant experience in Data Engineering, SQL Development, Data Analysis, Database administration, or implementation and administration of customizable enterprise applications. B2B SaaS experience is preferred. Finance, consulting and sales compensation experience also considered.
• Strongly prefer a comprehension of end to end Sales Compensation processes and systems.
• Knowledge of Compensation Systems integration with external applications such as Salesforce and HR system (Workday). Experience with SQL and developing integrated solutions between systems.
• Advanced understanding of formulas (excel or sheets)
• Deep understanding of software testing with knowledge on building test plans and completing them in unit, functional and user acceptance test cycles.
• Experience developing and maintaining calculations for large data sets using spreadsheets or database models.
• Strong problem solving, critical thinking, and analytical skills to set up and interpret logic, data tables, and rule relationships.
• Open Communication: clearly conveys thoughts, both written and verbally, listening attentively and asking questions for clarification and understanding
• Problem Solving: uses an organized and logical approach to find solutions to complex problems. Looks beyond the obvious to understand the root cause of problems
• Process/Project Management: skilled at figuring out and managing the processes and timelines necessary to get work accomplished
• Creativity and Innovation: seeks new and better ways of doing things, generates original and imaginative ideas, products, or solutions

WHO YOU ARE:

• Tenacious. You are determined to succeed, and you are motivated by the success of Customers, colleagues and the community.
• Curious. You are always learning and seeking ways to make things better.
• Conscientious. You keep your promises, taking your commitments to others seriously, and you have strong integrity.
• Humble. You lead with humility and empathy, respecting and learning from the perspectives of others.

In all we do, our six guiding principles light the way:

Step Up: Show the world what it looks like to live and work by these guiding principles. #StepUp

One Team: Make Hootsuite a place where everyone feels safe, welcome, valued, and empowered to do their best work without compromising who they are. #OneTeam #FreeToBeMe

Customer Obsessed: Focus relentlessly on helping our customers succeed. #CustomerObsessed

Go Fast, Be Agile: Widen our competitive advantage by committing to speed and simplicity over perfection and complexity. #GoFastBeAgile

Play to Win: Commit to building an incredible, profitable company for our customers, our employees, and our stakeholders. #PlayToWin #NoExcuses

Neighbours & Allies: Give back to our communities and be an ally. #SocialForGood #Allies

Accommodations will be provided as requested by candidates taking part in all aspects of the selection process.

#LI-Hybrid