Logo for #twiceasnice Recruiting

Incentive & Reconciliation Analyst (Strong Excel Skills Required) – REMOTE

Role overview

Summary

This role focuses on managing incentive and bonus calculations, data reconciliation, and financial reporting within the insurance industry. You will work remotely, collaborating with various teams to ensure accurate processing of incentive programs and maintaining documentation.

Qualifications

  • Bachelor's degree is required.
  • 3+ years of accounting or financial analytics experience are required.
  • Advanced Excel skills, including VLOOKUP, HLOOKUP, and PivotTables, are required.
  • Experience performing data reconciliations and researching variances is required.
  • Strong analytical skills, problem-solving abilities, and attention to detail are required.

Responsibilities

  • Manage recurring incentive programs, including setup, calculations, reconciliation, & processing
  • Calculate new business, book transfer, and other incentive bonuses based on contractual terms
  • Reconcile data across multiple sources, research variances, and resolve discrepancies
  • Prepare recurring reports, analyze data, and respond to routine reporting requests

Key facts

  • Remote from: United States
  • Full time
  • Mid-level (2-5 years)
  • Reconciliation Analyst
  • $75K – $84K / year
  • English

Hard skills

Key skills for this role

Other skills

  • Microsoft Excel
  • Analytical Skills
  • Problem Solving
  • Detail Oriented
  • Social Skills

About the company

#twiceasnice Recruiting logo

#twiceasnice Recruiting

  • Staffing & Recruiting
  • Scaleup
  • 51–200
We help our clients save money and hire better with our custom-built searches, 9.9% fee, and 18-month guarantee. Our team is forever obsessed with the metrics and efficiency around #twiceasnice’s one service: direct placement recruiting.

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Incentive & Reconciliation Analyst (Strong Excel Skills Required) – REMOTE
Location: Fully Remote - United States 
Salary: $39-$44/hour + $650/Month Wellness Stipend + $5,000 Annual Bonus
Benefits: 138 Hours of PTO, Paid Holidays, 401K w/ Match, $650/Month Wellness Stipend
Job Type: Full-Time
Core Hours: M-F, 10am-4pm ET required plus flextime = 37.5-40 hours/week 
Start Date: ASAP
Sponsorship: Not available
Travel: Once Annually for Team Building

Incentive & Reconciliation Analyst (Strong Excel Skills Required) – REMOTE Description

Our client in the insurance industry is looking for an Incentive & Reconciliation Analyst to join their fully remote team. In this role, you will manage incentive and bonus calculations, data reconciliation, financial reporting, and related analytics to ensure accurate and timely processing of incentive programs. This is an Excel-heavy financial operations and reporting role, rather than a traditional data analyst position, with a strong focus on incentive administration. The ideal candidate will have a background in accounting or financial analytics, advanced Excel skills, and experience reconciling data and researching discrepancies. To be successful, you must be highly organized, detail-oriented, and able to independently manage priorities and meet deadlines. This is a great opportunity to join a company known for its excellent remote work culture, long-tenured employees, and supportive team environment.

Incentive & Reconciliation Analyst (Strong Excel Skills Required) – REMOTE Responsibilities

•    Manage recurring incentive programs, including setup, calculations, reconciliation, & processing
•    Calculate new business, book transfer, and other incentive bonuses based on contractual terms
•    Apply business logic from contracts to determine incentive eligibility and payment amounts
•    Maintain incentive program requirements, eligibility criteria, schedules, and documentation
•    Prepare incentive calculations and payment files for review and process approved distributions
•    Reconcile data across multiple sources, research variances, and resolve discrepancies
•    Validate carrier data files and support carrier onboarding and ongoing data maintenance
•    Prepare recurring reports, analyze data, and respond to routine reporting requests
•    Collaborate with carriers, field personnel, Accounting, and internal teams to resolve data issues
•    Support users with reporting inquiries and troubleshoot data-related questions
•    Document procedures and identify opportunities to streamline recurring processes

Incentive & Reconciliation Analyst (Strong Excel Skills Required) – REMOTE Qualifications

•    Bachelor's degree is required
•    3+ years of accounting or financial analytics experience are required
•    Advanced Excel skills, including VLOOKUP, HLOOKUP, and PivotTables, are required
•    Experience performing data reconciliations and researching variances is required
•    Strong analytical skills, problem-solving abilities, and attention to detail are required
•    Strong interpersonal and communication skills for partner collaboration are required
•    High-speed internet connection & ability to participate in regular video meetings is required

Related jobs

See all Reconciliation Analyst jobs

Other jobs at #twiceasnice Recruiting