Senior Client Services Account Analyst – Private Wealth and Retirement
Summary Of Responsibilities
The Data Analyst supports Account Managers in the Retirement practice by performing the data loading, data entry, and data manipulation that drive plan administration. The role is responsible for the accurate and timely preparation of plan data — including census loads, recordkeeper file loads, asset reconciliation, and compliance sing inputs — enabling Account Managers to deliver compliance, government reporting, and client service in accordance with the practices, policies, and procedures of the Company.
- Data & Recordkeeping Load and review data provided by clients and recordkeepers.
- Reconcile contributions and plan assets in preparation for Form 5500 filing.
- Compliance Testing
- Prepare and compile data for compliance sing (e.g., top-heavy, 410(b), 402(g), ADP/ACP, 401(a)(4), (415).
- Prepare data for, and assist with the calculation of, employer contributions (e.g., match, profit sharing, new comparability).
- Government Reporting
- Aid with the preparation of Form 5500, 8955-SSA, and other filing requirements.
- Systems & Process Improvement
- Maintain the CRM (Customer Relationship Management) system by updating records, importing data, and helping build workflows.
- Provide support, training, and documentation for CRM users.
- Develop and maintain proficiency in all software required for the role, including Excel, ASC, the CRM, and vendor websites.
- Identify and implement workflow efficiencies using tools such as macros, AI assistants, and other process improvements.
Required Qualifications
- Bachelor’s degree in Business, Finance, Data Analytics, Mathematics, or a related field OR commensurate experience.
- Strong proficiency with Microsoft Office products, particularly Excel.
- Comfortable working with and manipulating large data sets.
- Strong attention to detail, accuracy, and follow-through.
- Two or more years of relevant work experience in retirement plan administration or a similar role; candidates with internship or co-op experience will be considered.
- Ability to multitask, prioritize, and adhere to deadlines.
- Self-motivated, detail-oriented, and well-organized, with the ability to thrive in a team environment.
- Excellent organizational, interpersonal, verbal, and written communication skills.
- Experience with CRM platforms (data entry, record maintenance, or workflow configuration).
Preferred Qualifications
- Prior experience in business operations, insurance, or financial services.
- Exposure to project management tools or methodologies.
- Insurance industry experience.
What We Offer You
- Youthful and supportive workplace culture.
- Investment in your professional development.
- Competitive benefits package.
- Flexible work arrangements.
- Comprehensive wellness programs.
- Accommodation requests.
Department
Account Management & Service
Required Experience
- 2-5 years of relevant experience.
Required Travel
- Negligible.
Required Education
- High school or equivalent.
EEO Statement
HUB International Limited is an equal opportunity employer that does not discriminate on the basis of race/ethnicity, national origin, religion, age, color, sex, sexual orientation, gender identity, disability or veteran's status, or any other characteristic protected by local, state or federal laws, rules or regulations.