Senior Rebate Analytics Specialist

Connection; Merrimack (NH); On-site; USD 35,000 - 45,000; Full time

Benefits offered by this job

Total rewards package

401k plan

Medical insurance

Mental health support

Job summary

Connection is seeking a detail-oriented financial analyst to administer royalty and healthcare GPO programs, ensuring compliance with contracts and policies. You will track member payments, run accrual reports, and coordinate across Finance, Licensing Operations, and Vendor Accounting to ensure accurate settlements.

The role involves setting up rebates, monitoring program coding, and preparing timely payment requests, with quarterly audits to validate payouts and variances.

Qualifications

• Intermediate Microsoft Excel skills, including formula creation, filtering, sorting, and formatting.
• Microsoft Access experience, including query creation and report writing.
• Knowledge of JDE World Traveler, particularly Pricing & Availability and Advanced Pricing modules.
• Experience creating deal templates in Callback.
• Working knowledge of fundamental accounting principles.
• Demonstrated ability to analyze sales data, compare results with historical trends, and recognize anomalies.
• Ability to interpret contractual language related to payment obligations and reporting requirements.
• Strong cross-functional perspective and the ability to coordinate information from multiple departments.

Responsibilities

• Administer Royalty Administration Fee, Global Alliance Referral, and healthcare GPO programs in accordance with contractual terms, corporate policies, and applicable Sarbanes-Oxley controls.
• Manage healthcare GPO administrative fee requirements, including member tracking, timely payments, required reporting, and prevention of duplicate payments caused by cross-membership.
• Set up and maintain rebate programs, secure required approvals, and monitor program coding to support accurate commission adjustments.
• Analyze sales activity, prepare monthly accrual reporting for Finance, and produce timely check and wire-transfer requests based on contract terms and actual sales data.
• Conduct quarterly audits to validate accruals and customer payout amounts, investigate anomalies, and support accurate financial reporting.
• Partner across Finance, Licensing Operations, Vendor Accounting, BMG, Taxation, and other departments to resolve issues and complete payments and adjustments.
• Create and maintain custom static customer catalogs using an online tool; review output for compliance and coordinate with IS to troubleshoot production issues.
• Respond to inquiries through the Contracts and Proposals Rapid Response line, document requests in Call Tracker, and elevate issues when appropriate.
• Mentor less experienced analysts by providing guidance on day-to-day operations, responses, and issue resolution.
• Maintain working knowledge of the Account Specific Pricing module within JDE and provide backup support for creating and applying price schedules.

Skills

Analytical thinking

Financial acumen

Cross-functional collaboration

Contract interpretation

Communication

Problem solving

Tools

Microsoft Excel

Microsoft Access

JDE World Traveler Pricing

Callback deal templates

Job description

Connection is seeking a detail-oriented financial analyst to administer royalty and healthcare GPO programs, ensuring compliance with contracts and policies. You will track member payments, run accrual reports, and coordinate across Finance, Licensing Operations, and Vendor Accounting to ensure accurate settlements.

The role involves setting up rebates, monitoring program coding, and preparing timely payment requests, with quarterly audits to validate payouts and variances.