Remote Advanced Excel Jobs in Arkansas (NOW HIRING)

When it comes to making a meaningful difference in the lives of our customers and employees, USAble Life is always ready.  We are a diverse group of individuals working together to go the extra mile. Through our DEI initiatives, employees feel empowered to bring their talents and voice to our culture.

Our passion for delivering the best products is matched only by our passion for our people. We are committed to making a meaningful difference in the lives of others which extends beyond our office walls. USAble Life has a long tradition of supporting our communities, and we’re proud of the fact that our employees share that commitment. 

We have been recognized as a “Best Places to Work” in Arkansas, Florida, and Hawaii. You’ll be rewarded with opportunities for personal and professional development and opportunities for advancement.  This, coupled with our engaging culture and a comprehensive benefits package, ensures we are committed to our employees. 

Check out how we make a meaningful difference in the lives of others!

https://player.vimeo.com/video/518665804

What We Offer You:

• A culture that values employees and celebrates, empowers, and inspires a diverse workforce
• 11 paid holidays
• 401(k) with up to 6% match; fully vested from day 1
• Remote opportunities with company-provided equipment
• Team-oriented, collaborative group of peers
• Career advancement opportunities
• Leadership Mentoring program
• Tuition Reimbursement
• Employee Assistance Program
• Inclusion Council and Employee Resource Groups
• Recharge Days and Volunteer Time Off
• This is a remote position.

The starting base salary range for a Sales Compensation & Commission Analyst II  is $55,000 to $77,000.  Actual salaries will vary by geographic location and are based on factors such as candidate’s qualifications, experience, skills, competencies, and company equity.  In addition to base compensation, this role is eligible for an annual incentive plan based on company performance and individual performance.  

Before You Apply:

• 2+ years of experience in sales compensation, commissions, compensation analysis, and variable pay
• Experience administrating sales incentive plans
• Advanced Excel skills, including formulas, pivot tables, and lookups
• Experience analyzing and manipulating large datasets
• Experience creating reports, identifying trends, and communicating findings to stakeholders
   

Sales Compensation & Commission Analyst II Overview

The Sales Compensation & Commission Analyst II is responsible for the development, analysis, reporting and administration of the organization's sales compensation and commission programs. This role carries a high level of responsibility and requires exceptional analytical capability, attention to detail, and financial acumen. The successful candidate will administer and validate complex sales compensation and incentive programs, ensuring accurate and timely payments. The position requires managing large volumes of compensation data and supporting processes that have substantial financial impact on the organization and its sales distribution partners. Accuracy, integrity, sound judgment, and a strong commitment to controls and compliance are essential. 

Essential Duties:

• Contributes to the design and development of sales compensation and commission plans that support the organization's sales positions. This includes update to sales compensation and commission collateral. 
• Responsible for maintaining and updating sales compensation and/or commission program applications, systems, and/or databases.
• Follows corporate audit guidelines to ensure accuracy and efficiency in the processing of system hierarchy and/or commission changes and preparation of commission and/or compensation statements and files. 
• Monitors the sales compensation and commission payout processes, ensuring that calculations are correct, and payments are submitted for processing within specified timelines.
• Acts as a liaison between the company and customer to respond to inquiries and resolve issues related to sales compensation and commissions
• Performs complex data modeling to analyze the design and effectiveness of current sales compensation and commission programs, identify trends, patterns and opportunities for improvement. Present information to stakeholders at all levels of the organization.
• Analyzes data to prepare and distribute reports on commissions, bonuses, sales compensation, and Form 5500 Schedule A information, including financial accruals
• Ensures documentation and procedures are updated and maintained. Responsible for providing onboarding training to new employees and delivers training to communicate and explain sales compensation and commission programs.
• Ensures that all compensation-related activities are in compliance with applicable regulations and standards
• Participates in various sales compensation and commission related projects
• Performs other related duties and responsibilities as assigned 

Required Knowledge, Skills and Abilities:

•  
  Experience administering and supporting a large portfolio of sales incentive and commission plans, including the ability to accurately interpret plan designs, calculate payouts, and manage complex compensation structures 
• Analytical skills with the ability to collect, organize, analyze and manipulate large datasets with attention to detail and accuracy
• Excellent communication and interpersonal skills with the ability to present complex data to stakeholders at all levels of the organization
• Adherence to ethical standards and the ability to maintain confidentiality when handling sensitive compensation information
• Problem-solving skills with ability to analyze compensation issues, propose solutions, and make recommendations for improvements
• Ability to work independently and as part of a team in a fast-paced environment with multiple priorities and deadlines
• Ability to create/modify queries and or reports and present findings
• Advanced Excel skills, including formulas, pivot tables, VLOOKUP with aptitude for learning other analytical tools
• Knowledge of database applications

Required Education and Experience:

• Bachelor's degree in Business Administration, Finance, Accounting, Economics, related field, or equivalent related experience
• 2+ years of progressive relevant work experience
• Or, equivalent military experience

Preferred Education and Experience:

• Experience with sales compensation management software is a plus
• Sales compensation plan design knowledge and/or experience
• SQL Experience
• SharePoint
• Salesforce
• LifePRO and/or Compass experience
• Understanding of financial concepts and the ability to interpret financial data.
• MS Reporting Services (SSRS) experience
• SQL Server Integration Services (SSIS) experience
• MS Power BI experience
• Experience with data visualization tools and development
• Insurance or Finance Experience
• Industry Certification(s)

#USAL2