Sales Commission Analyst

"All candidates must be directly contracted by ASK Consulting on their payroll and cannot be subcontracted. We are unable to provide sponsorship at this moment".Job Title: Sales Commission AnalystLocation: Lehi UT 84043 (Hybrid role) (Local profiles needed)Duration: 6 months contract rolePay rate: $35 to $42/hr. On W2 Job Description:DutiesExecution:Perform the entire commissions process focusing on the monthly commission calculations and analytical audits across all sales teams and provide timely and accurate accrual information to accounting teamMaintain models with demonstrated proficiency in Excel and PowerBI and continuously review models and identify areas of potential improvementAdminister and update Excel and PowerBI to ensure transparency for our sales teamPartner with payroll and accounting to ensure proper payments each monthWork with management on various projects that use Excel, Python, Power BI, and SQL to drive process improvements, automation, and enhanced reportingPlan:Gain an understanding of all compensation plans for new and existing sales employeesGain an understanding of quota and resultsAssist in analysis of plan efficiencySupport:Ensure complete and accurate employee data and compensation plan detail across compensation systemsAssist in Ad-hoc analysis and track key performance metrics monthly.Ensure controls are performed for accurate payout of commissionsCollaborate with payroll to provide accurate and timely payments to field employeesAssist with timely and accurate resolution of commissions questions/disputes from field employeesAssist in the development, maintenance, and updates to systems, processes, and analytics reportingSkills:Must be highly proficient with Excel, Salesforce, Power BI, Anaplan, and SQL.Must be highly analytical2-3 years of relevant experience expectedBackground of cross functional interaction with internal organizations a plusExcellent communication skills, written and verbal and social skills requiredQuick learner with ability to achieve successful results with limited supervision often under tight deadlines.Attention to detail, problem solving, judgment, and initiative, critical for successAbout ASK: ASK Consulting is an award-winning technology and professional services recruiting firm servicing Fortune 500 organizations nationally. With 5 nationwide offices, two global delivery centers, and employees in 42 states-ASK Consulting connects people with amazing opportunitiesASK Consulting is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all associates.