Job Description

Come play a key role in fostering a positive and inclusive culture at Rogers. Our Human Resources department is committed to growing teams across the country that are collaborative, digital-first, fast-moving, bold-thinking, and focused on delivering impact in everything they do. We are looking for Human Resource champions committed to improving employee productivity and engagement and who understand the impact of HR in influencing business results.
We believe in challenging work, rewarding opportunities, and giving back to make a positive impact for Canadians who need it most. When our team learns, grows, and reaches their true potential \xe2\x80\x93 we can make more possible. At Rogers, your journey is filled with limitless possibilities, let\xe2\x80\x99s make your possible.
Are you up for the challenge and the fun? Consider the following opportunity:
The Sales Compensation Team Lead will report to the Senior Manager Corporate Retail Sales Compensation Delivery and will support the Compensation Delivery Team within the HR Total Rewards department of Rogers Communications Inc. Compensation Delivery is responsible for the set-up, calculation, payment and reporting of Commissions for various channels and roles. The successful candidate will leverage leadership, analytical, customer service, organization and business acumen skills to help complete daily, weekly and monthly activities to ensure compensation Service Level is met.
Responsibilities:

• Participate and Lead in the analysis of business requirements for compensation and sales incentive payments to provide assessment on impact, data and changes required to support requested changes.
• Work with SQL Server databases and stored procedures to support sales compensation plans for various channels.
• Build and test new compensation plan and rules in CallidusCloud to support Compensation changes.
• Migrating of manual processes to Callidus for automated calculation.
• Build validation rules, processes and controls to ensure data accuracy.
• Analyze sales data and compensation results to ensure accurate payments
• Work in close partnership with the IT teams and business teams to address system issues, close process gaps and implement proactive system solutions to reduce internal gaps
• Participate in the development of new processes and improvements to existing ones
• Discovery and design of new reports and compensation statements; ad-hoc reporting as needed
• Maintain SQL databases that aggregate multiple data sources for cross platform analysis
• Manage and provide guidance to Jr. Analyst within the team.
• Other duties as assigned

Qualifications:

• Secondary Education Degree/Diploma in related field
• Ability to take business requirements and develop solid analytic methodologies to support requirements. This requires a solid understanding of the business and the ability to decipher and translate business requirements into data and analytics requirements.
• Advance level of knowledge in SQL \xe2\x80\x93importing and exporting of data, writing SQL query scripts to analyst data from across DB and Tables. This includes working with large transactional data sets and the ability to build optimized queries for compensation metrics and payouts.
• Knowledge of Vision 21, SGI and Maestro systems is a definite asset.
• Telecom Industry or sales commission experience preferred
• Willingness to take on new challenges and take on lead roles in new initiatives
• Ability to work on and manage multiple assignments
• Excellent written and oral communication skill.
• Reaction to changes and flexibility are paramount. Detail oriented

Technical Skills:

• Microsoft Excel \xe2\x80\x93 advanced experience creating formulas, pivot-tables, macros, charts/graphs, VBA,
• Microsoft Word and PowerPoint \xe2\x80\x93 intermediate/advanced knowledge.
• SQL scripting \xe2\x80\x93 advanced experience completing data extraction, report building, data-mining and validation
• CallidusCloud \xe2\x80\x93 Rules building and reference set up, building of reports using the native Callidus functions is a must.

Schedule: Full time
Shift: Day
Length of Contract: Not Applicable (Regular Position)
Work Location: 333 Bloor Street East (824), Toronto, ON
Travel Requirements: Up to 10%
Posting Category/Function: Human Resources & Compensation
Requisition ID: 287911
What makes us different makes us stronger. Rogers has a strong commitment to diversity and inclusion. Everyone who applies for a job will be considered. We recognize the business value in creating a workplace where each team member has the tools to reach their full potential. At Rogers, we value the insights and innovation that diverse teams bring to work. We work with our candidates with disabilities throughout the recruitment process to ensure that they have what they need to be at their best. Please reach out to our recruiters and hiring managers to begin a conversation about how we can ensure that you deliver your best work. You matter to us! For any questions, please visit the Rogers FAQ.

Posting Notes: Corporate