Commissions Data Analyst

SFG & NCC•Knoxville, TN

1d•Hybrid

About The Position

In this role, you will work with large, multi-source commission datasets to ensure accurate reporting and timely payments to our independently contracted agents and agencies. Your work directly supports financial accuracy, operational excellence, and the success of the professionals we serve. Why Join NCC? We offer more than a job — we offer a career with purpose and balance.

Requirements

Advanced Excel expertise (XLOOKUP, pivot tables, complex formulas; experience building/testing macros preferred)
Strong data analysis and reporting skills
Ability to navigate CRMs, ERP systems, and multiple web-based platforms
Excellent written and verbal communication skills (clear, professional grammar and spelling required)
Ability to compile, analyze, and clearly present large datasets
Strong critical thinking and sound judgment
Ability to manage confidential and sensitive financial information
Strong follow-up and cross-functional communication skills
Ability to prioritize, meet deadlines, and deliver accurate results consistently
Team-oriented mindset with a willingness to teach and collaborate
Associate’s degree (AS) or equivalent combination of education and experience
Experience in finance, accounting, or insurance carrier contracting
Advanced-level Excel proficiency
Experience with CRM systems
Strong computer and internet proficiency
Effective written and verbal communication skills in English
Experience with virtual meeting and training platforms (Teams, Zoom, WebEx, etc.)
Strong business and financial data acumen
Auditing experience

Nice To Haves

Bachelor’s degree in data analytics, finance, business, accounting, or related field
Experience with AI tools
Knowledge of insurance commissions and the carrier–agent ecosystem
Experience with Salesforce
Experience with an FMO or insurance carrier
Entrepreneurial or growth-stage company experience

Responsibilities

Download, format, import, and analyze commission reports from multiple insurance carriers
Process commission data within internal payment systems
Verify and supply financial data for accurate commission payments
Identify discrepancies, payment issues, and data inconsistencies
Communicate with Accounting, Contracting, and carriers to resolve commission questions
Assist Finance with accounts payable and payroll support as needed
Reconcile chargebacks, marketing assistance balances, and 1099 tax status setups
Perform manual commission calculations when required
Escalate and resolve commission issues efficiently
Complete special projects and leadership requests
Continuously support NCC’s value proposition for agents and internal teams
Collaborate across NCC and SFG to improve processes and cross-train team members

Benefits

Full-time W2 position with competitive base rate plus bonus
Comprehensive benefits package including medical, dental, vision, and telehealth
401(k) with 100% match up to 5% with immediate vesting
Student loan paydown assistance program
Paid parental leave
Paid compassionate leave (pregnancy loss/miscarriage)
Paid caregiver leave
Company-paid disability coverage
Three weeks PTO
Generously paid company holidays
“Twixmas” - paid closure between Christmas and New Year’s Day after our busiest season
Commitment to professional development
Full access to LinkedIn Learning
Collaborative, growth-oriented culture
Opportunities to teach, learn, and improve processes
A meaningful career supporting insurance professionals nationwide