Excel Pivot Table Remote 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
• Outstanding comprehensive benefits package
• PTO provided at date of hire
• 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
• Tuition Reimbursement
• Employee Assistance Program
• Inclusion Council and Employee Resource Groups
• Recharge Days and Volunteer Time Off
• This is a multi-level position.
• This is a remote position.

Life Takes You Places!  Are you ready to join us?

Compensation:

Pay Transparency: Our salary ranges are structured to provide opportunities for growth and advancement within a role. As a result, most new hires are placed between the minimum and midpoint of the range based on qualifications and experience, while the top of the range is generally reserved for employees who have demonstrated sustained expertise and performance in the position. Anticipated pay for new hires is between $41,000 and $48,000. The full pay range for the Premium Billing Reconciliation Specialist I is $41,000 to $62,900.  Pay is based on non-discriminatory factors including but not limited to work experience, education, location, licensure requirements, proficiency and qualifications, and company tenure & equity. In addition to base compensation, this role is eligible for an annual incentive plan based on company performance and individual performance.

Overview:

A Premium Billing Reconciliation Specialist performs a wide range of accounting and analytical functions related to reconciling individual and group premium payments for Life, Supplemental and Disability insurance policies.  This is not a traditional billing or accounts receivable role compromised of sending invoices and matching payments.  Every insurance premium payment presents a new puzzle and requires a high level of analytical and reconciliation skills to solve it.

A Premium Billing Reconciliation Specialist I will:

• Reconcile and process premium billings and balances daily reports.
• Maintain and research premium suspense
• Generate premium refunds and correspondence. 
• Perform member and group terminations
• Perform member level reconciliations

Essentials Duties:  

• Analyze, process and accurately reconcile and post group payments in a timely manner.
• Analyze and research suspense on the groups to ensure premiums are posted correctly.
• Complete payment audits for groups in MS Excel.
• Achieve acceptable quality and productivity benchmarks by multi-tasking in high volume environment on a daily basis. 
• Have excellent written communication skills, strong product knowledge and procedure expertise.
• Work collaboratively with internal customers to meet established departmental service level goals.
• May perform other duties as assigned based on department needs.

Required Knowledge, Skills, and Abilities:

• Ability to perform complex reconciliation and administrative research in servicing system
• Ability to analyze financial premium data and communicate results.
• Outstanding research and reconciliation skills
• 10-key skills 
• Intermediate MS Excel skills to include spreadsheet formatting, formulas, pivot tables, and VLOOKUPs
• Excellent verbal and written communication skills and ability to compose professional correspondence 
• Excellent analytical and critical thinking skills
• Ability to maintain attention to detail
• Ability to maintain a low error rate
• Ability to prioritize, multi-task, and meet tight deadlines
• Ability to handle confidential information

Required Education and Experience:

• High School Diploma or Equivalent
• 2- 4 years working in general accounting with understanding of related concepts and practices,
• Experience in a role requiring heavy research and reconciliation

Preferred Education and Experience:

• Life, Supplemental and Disability insurance premium experience
• LOMA 280 & 290; FLMI Bachelors degree or some college course work

This job description is intended to convey information essential to understanding the scope of the position and its general requirements. It is not exhaustive and may be subject to modification at any time to meet the evolving needs of the organization.

#USAL2