Census Analyst Jobs in Missouri (NOW HIRING)

Location: Sun Life embraces a hybrid work model that balances in-office collaboration with the flexibility of virtual work. Our leaders are expected to foster connection and teamwork by being present in the office 2 to 3 days per week.

The Opportunity

The Audit Consultant plays a critical role in ensuring premium accuracy, financial integrity, and client accountability across Sun Life's Group Benefits business. This role conducts premium audits, analyzes census and billing data,identifiespremium discrepancies, calculates financial impacts, and partners directly with clients and internal business partners to resolve premium variances.

With a focus onboth self-administered and list-billed, this role supportsEmployer Benefits,StopLoss,SupplementalHealth, andNationalAccount clients as assigned.

Whatyou willdo:

• Analyze census, billing, eligibility, contract, and premium remittance data tovalidatethat premium paid aligns to policy provisions and rating methodologies.

• Use contract and premium calculation knowledge to explain audit outcomes, resolve questions, and help clients, brokers, and TPAs improve the accuracy of future premium remittance.

• Investigate premium discrepancies, calculation issues,monthly variance or flux items, and document findings clearly for internal review and client communication.

• Recreate premium calculations andvalidatepremium statement creation for Self-Bill API clientstoidentifyclient misunderstandingsor plan design set up disconnects.

• Review and support approval processes forhigh dollarrefundsandrevenue adjustments.

• Collaborate with Premium Administration, Billing, Underwriting, Client Services, Finance, offshore partners, Technology, Reporting, IT, and other cross-functional teams to research issues, coordinate membership updates, refine analytical reporting, and strengthen controls.

• Use Excel, reporting tools, and large data sets to analyze premium activity,monitorinventory,identifyrecurring root causes, summarize outcomes, and support audit readiness.

• Drive continuous improvement byidentifyingreporting gaps, automation opportunities, process defects, and client education needs that improve accuracy, efficiency, and client experience.

• Support company initiatives, special projects, and evolving audit priorities as assigned.

Whatyou willbring with you:

• Bachelor's degree in Accounting, Finance, Business, Economics, Mathematics, or related field preferred; equivalent insurance or premium administration experience may be considered.

• 1 to 3+ years of experience in accounting, audit, financial analysis, billing, premium administration, or insurance operations preferred.

• Knowledge of Group Benefits, Stop Loss, Supplemental Health, or related insurance products preferred.

• Client-centered mindset with proven ability to collaborate effectively with peers, clients, brokers, and cross-functional partnersthrough email,phoneor chat.

• Strong analytical and financial investigation skills, including ability to combine information from policy, census, payroll, eligibility, billing, and payment sources.

• Advanced Excelproficiency, including pivot tables, lookups, formulas, data validation, and comfort working with large data sets; Power Query or similar data transformation experience preferred.

• Strong attention to detail,organizationand ability to document conclusions clearly.

• Strong written and verbal communication skills, includingabilityto explain complex financial findings in plain language.

• Ability to work independently, manage competing priorities, and follow through on complex investigations within expected timelines.

• Demonstrated commitment to continuous improvement, problem solving, learning, and positive team collaboration.

Salary: $53,000 - 80,700

At our company, we are committed to pay transparency and equity. The salary range for this role is competitive nationwide, and we strive to ensure that compensation is fair and equitable. Your actual base salary will be determined based on your unique skills, qualification, experience, education, and geographic location. In addition to your base salary, this position is eligible for a discretionary annual incentive award based on your individual performance as well as the overall performance of the business. We are dedicated to creating a work environment where everyone is rewarded for their contributions.