Business Intelligence Associate

About the Company

At HUB International, we believe the best workplaces invest in their people, celebrate their communities, and build cultures where everyone belongs. Recognized as one of America's Greatest Workplaces for Culture, Belonging, and Community, and among the top 20 Best Finance Companies to Work For as rated by women, we help individuals, families, and businesses protect and plan for what matters most through insurance, retirement, and wealth management products and services.

HUB is one of the world's largest insurance brokerages, with over 540 locations and more than 20,000 professionals across North America. We combine the resources of a global firm with the agility of a regional team, offering tools, support, and community to help you grow throughout your career.

About the Role

The Business Intelligence Associate is an entry-level role focused on developing core business intelligence skills while contributing to the team's reporting and analytics work. Working under the direction and mentorship of BI leadership and senior team members, the Associate learns to build and maintain reports, dashboards, and data models, developing foundational skills in Power BI, data modeling, and Microsoft Excel (including formulas and an introduction to VBA). The role emphasizes learning, supported execution, and gradually taking on greater responsibility.

This is a hybrid position based in our Norwell, MA office.

Responsibilities

• Assist in building and maintaining Power BI dashboards, reports, and data models under close guidance from BI leadership.
• Learn and apply Microsoft Excel skills, including advanced formulas and an introduction to VBA scripting.
• Support the team on automation tasks, such as CRM data-update processes.
• Help maintain automated internal CRM reports, including quick-view dashboards and scheduled email reports for staff.
• Learn to apply AI tools such as Claude to support reporting and analysis, building proficiency over time.
• Assist with AI adoption efforts, including collecting prompts, best practices, and enablement materials to share with staff.
• Help maintain and organize a SharePoint site for AI knowledge sharing, keeping content current.
• Gather reporting requirements from business users and, with guidance, translate them into reporting outputs.
• Build foundational skills in DAX measures, data transformations, and Power Query.
• Check and validate reports for accuracy under the direction of senior team members.
• Develop familiarity with the insurance industry to add context to analytical work.
• Actively participate in training, mentorship, and skill-development opportunities.

Requirements

• Foundational exposure to Power BI and Microsoft Excel, with a strong willingness to learn (through coursework, internship, or self-study).
• Basic understanding of data and reporting concepts.
• Familiarity with, or genuine interest in, AI tools such as Claude.
• Comfort with Microsoft 365 tools, including SharePoint.
• Strong attention to detail and a proactive, coachable attitude.
• Good written and verbal communication skills.
• Eagerness to learn the insurance industry and business development operations.

Preferred Qualifications

• Internship or coursework in data analytics, business intelligence, or a related field.
• Early exposure to DAX, Power Query, or SQL.
• Interest in automation tools (e.g., Power Automate) and in supporting organizational AI adoption.
• A bachelor's degree (recent graduate) or equivalent experience in a quantitative, business, or technical field.

Benefits

• Medical, Dental, Vision, and Prescription Drug Coverage
• Health Plan Reimbursement Program
• Health Savings Account (HSA) and Flexible Spending Accounts (FSAs)
• 401(k) Savings Plan
• Life and Disability Plans
• Long-Term Care
• Employee Assistance Program (EAP)
• Comprehensive Wellness Program
• Identity Theft Protection, Group Legal, Accident, Critical Illness, and Pet Insurance
• Low-Cost Loan Program and Student Loan Resources
• Vacation, Holiday, Sick, and Personal Time Off
• Flexible Work Arrangements
• Dress for Your Day Policy
• Comprehensive Onboarding and Continuing Education

Pay

The expected salary range for this position is $20.44/hr to $31.00/hr and will be impacted by factors such as the successful candidate’s skills, experience, and working location.