[Hiring] Operations Analyst @HUB International

Role Description

An ideal candidate for the Operations Analyst – Data & Revenue Operations position will be detail-oriented, analytical, and energized by problem-solving in a complex data environment. You will take ownership of manual, data and revenue operations tasks, including:

• Account lookups
• Content mapping updates
• Carrier reconciliation data entry
• Reference documentation
• Carrier commission reconciliation
• Production report support

This role is foundational: you'll learn SPG's data architecture, carrier relationships, revenue operations, and insurance operations while executing essential validation, data entry, reconciliation, and reporting tasks. Working directly with the operations and leadership team, you will gain hands-on experience in:

• Data governance
• CRM administration
• Revenue reconciliation
• Business analytics support

As established processes are refined, this role is expected to take on ownership of running them going forward. This is an ideal entry-level position for someone looking to build a career in data or revenue operations.

Qualifications

• Bachelor's degree or higher
• 1-2 years' experience in operations, data entry, business analysis, finance, or a related role (preferred but not required)
• Detail-oriented with a strong commitment to data accuracy and completeness
• Proficiency in Microsoft Excel (pivot tables, basic formulas) and experience with databases or data tools
• Comfort with CRM systems or willingness to learn Salesforce quickly
• Comfort working with financial/commission data; exposure to revenue reconciliation or accounting concepts is a plus
• Strong organizational and time-management skills; ability to prioritize and meet deadlines
• Effective communicator with ability to document findings clearly and present data to non-technical stakeholders
• Analytical mindset with curiosity about data and process improvement
• Self-starter who thrives with minimal oversight, comfortable with ambiguity and continuous change in a fast-paced, startup-style environment
• Ability to work 100% remote and manage time independently
• Team-oriented mindset with willingness to support cross-functional initiatives
• Interest in growing toward analytics, revenue operations, data governance, or operations leadership

Requirements

• Look up account information and respond to account-specific questions.
• Update content mapping templates (lines of coverage, carriers) as requested.
• Maintain reference and workflow documentation, including carrier contract updates, as products and processes evolve.
• Support carrier reconciliation data entry.
• Support the highest level of data quality through consistent and efficient data QA and validation, including QA of data content in and outside of Salesforce.
• Cross-train to support QA testing and reporting of Salesforce configuration changes and process updates.
• Support data alignment across multiple data sources, managing file receipt, consolidation, and clean-up, and coordinating follow-up where needed.
• Document and escalate any known data concerns or progress blockers.
• Support organizational data governance, consistently updating field mappings and update rules.
• As established operational processes are refined, take ownership of running them going forward.
• Maintain a general feedback loop with leadership on operational improvement opportunities as they arise in the course of day-to-day work.
• Procure carrier commission statements and provide to cash application resource; own outreach to carriers when statements are missing or discrepancies arise.
• Log and reconcile monthly carrier commission revenue received against carrier statements, ensuring accurate and timely posting by carrier and client.
• Pull premium and commission figures from carrier statements to support contingent commission calculations.
• Maintain monthly accrual tracking (e.g., reserves, intercompany payments) as part of revenue close, including coordination of revenue share activity.
• Own coordination with the collections resource on commission variance and carrier follow-up inquiries, providing status updates to leadership.
• Handle tactical, ad hoc data pulls from finance, flagging anything requiring leadership judgment.
• Audit the monthly production report for completeness and accuracy, flagging missing carriers, late payments, transfers between other P&Ls, and posting errors; coordinate with the cash application resource to resolve discrepancies.
• Assist in updating the production report to reflect producer compensation activity and maintain the list of producer-assigned accounts in collaboration with others on the team.
• Support onboarding of new carriers/clients into the production report structure, maintaining consistent carrier/client naming and data structure, obtaining portal access, and collaborating with another operations resource for appointment and ACH paperwork.
• Maintain and update monthly revenue forecast models based on guidance and methodology provided by leadership (e.g., historical averages, watchlist tracking for late-pay carriers, quarterly payment schedules).
• Flag one-time or non-recurring payments (e.g., catch-up payments, true-ups) for leadership review so they can be excluded from run-rate assumptions.
• Keep forecast assumptions organized and documented so they're easy to review and audit.
• Prepare month-end revenue summaries (actual vs. budget vs. forecast) under manager review.
• Calculate and flag budget-to-actual variances by line for manager review.
• Help maintain month-over-month tracking of key revenue metrics for leadership reporting.
• Document data sources and calculation rationale for all manual adjustments.
• Own first-pass audit and review of BenAdmin invoices ahead of leadership approval.

Benefits

• We invest in your growth. HUB offers structured training, licensing support, and ongoing development opportunities designed to accelerate your career.
• Competitive pay with comprehensive health benefits, retirement savings matching, and company-paid life and disability plans.
• Generous paid time off, paid parental leave, and a wellbeing program designed to support real work/life balance.
• A collaborative, high-performing culture with meaningful engagement, community impact through HUB Gives, and genuine room to grow your career.