Compensation Analyst

ROLE FUNCTION AND PURPOSE

The Business Intelligence Analyst works closely with the business leaders and the Director, Sales Compensation to administer sales variable compensation calculations, modeling and ROI analysis, strategic partnership management, reporting deliverables including preparing management reports, presentations, and documenting business process. This is an exciting and the critical role in the organization as this team manages the variable compensation for 400+ HC which involves various levels of corporate strategies with the power of real time compensation analytics, business intelligence tools and the inhouse platforms. The need to comprehend business concepts and ensure these concepts are delivered as meaningful analytics. The analyst facilitates design and concept gathering and assist in the creation of new reports or analytics. In addition, the analyst should be experienced with problem-solving and conflict resolution to help identify, communicate, and resolve issues.
KEY DUTIES AND RESPONSIBILITIES

The primary responsibility of this position is to support the regional sales leaders, Chief Data and Analytics officer, the Directors of Sales Compensation and Business Intelligence. Administer global sales variable compensation and partnership calculations like commissions, sales bonuses, and incentives. Create plans that pays for performance, financial business analysis and sales performance analysis with a view to deliver enhanced business performance.
- Responsible to build pay for performance sales commission and incentive plans for various roles from inside sales team to senior sales management team which enhances the decision-making abilities for the Senior Management and Executives.
- Engage with the business leaders on the sales ROI and promote new incentives to motivate the sales team to support organization growth.
- Sales Compensation Structures: Maintain compensation structures on the required systems based on Commission Plans
- Sales Variable Compensation: Run monthly sales commissions for various roles across the different geo’s we operate in.
- Management & Leadership Variable Compensation: Calculate monthly/quarterly incentives sales leadership roles.
- Sales Incentive Programs: administer and track individual performance under sales incentive programs.
- Compensation Reporting: reporting on the effectiveness of sales programs.
- Compensation Modeling: create competitive and pay for performance-based compensation plans to drive management goals.
- Measuring sales performance against an established set of KPIs.
- Responding to inquiries regarding compensation payout, partnership management, policies, and procedures.
- Prepare modeling to assess ROI & also conduct due diligence for partnership evaluation.
- Strategic Partnerships: Run and distribute accurate and timely Partner statements.
- Develop and support monthly partnership and client reporting and collaborate with stakeholders.
- Prepare modeling to assess ROI & also conduct due diligence for new partnerships evaluation.
- Prepare and update regular partner profitability analysis
- Prepare key Partnership Analysis and pricing reviews including modelling
- Assist in automation of key process and maintain regular reports for strategic partnerships.
- Identify and recommend improvements to current processes, with a focus on increased efficiencies and enhanced value-added analytics.
- Introduce new analysis, reporting formats etc., which provide insights to different areas of the business.
- Provide support on variety of integration and other special projects central to improving internal business processes.
- Support a variety of special compensation and partnership revenue share projects to improve internal business processes.
- Assist in implementing solutions for variable compensation and partner revenue share reporting and modeling.
- Maintain BI Documentation for all processes

ABILITIES AND ATTRIBUTES
- Ability to work independently and to prioritize work with a focus on deadlines and deliverables.
- Proven record as a strong team player in a fast-paced, deadline driven, diverse environment.
- Strong attention to detail and accuracy.
- Ability to trouble shoot, investigate and resolve issues.
- Demonstrable excellent written and verbal communication skills with business and technical stakeholders as well as internal and external users.
- Exceptional interpersonal skills.
- Proven ability to conduct and/or support multiple projects with mínimal oversight.
- Strong interviewing and listening skills to elicit detailed requirements.
- Proven analytical skills in defining business needs into product requirements.

KEY SKILLS
- Data analysis, reconciliation, and data mapping
- Microsoft Office - Excel (Advanced), Word, and PowerPoint
- Business Intelligence tools (Tableau, Power BI)
- Compensation modeling and administration knowledge/experience
- Intermediate Microsoft SQL & VBA/Macros
- Basic Knowledge of CRM syst