About The Role

 

Our Analytics team is seeking a detail-oriented and analytical Business Data Coordinator for a summer contract. This role is ideal for an early-career professional with strong Excel skills who is interested in gaining hands-on experience in data analysis, reporting, and business insights within a professional services environment.

 

As part of the team, you will support data collection, validation, reporting, and dashboard preparation, helping transform raw data into meaningful insights that inform business decisions.

 

What You’ll Do

Assist in gathering, organizing, and validating data from multiple internal systems

Prepare and maintain recurring reports using advanced Excel functions

Support the creation and updating of dashboards and performance tracking tools

Perform data cleansing and reconciliation to ensure accuracy and consistency

Analyze trends and summarize findings for internal stakeholders

Assist with ad hoc reporting requests from leadership and operational teams

Document reporting processes and support continuous improvement initiatives

Collaborate with team members to streamline data workflows and enhance reporting efficiency

 

Qualifications and expertise that pave the way for Success

 

Strong Excel skills required (including pivot tables, VLOOKUP/XLOOKUP, formulas, data manipulation, and basic data analysis functions)

High attention to detail and strong analytical thinking

Comfortable working with large data sets and identifying discrepancies

Strong organizational and time management skills

Clear written and verbal communication skills

Familiarity with Power BI or other visualization tools is considered an asset

Interest in business intelligence, analytics, or corporate reporting

 

 

Elevate Your Career with HUB International

 

At HUB, we believe summer roles should be meaningful, educational, and engaging. As a Coordinator, you’ll gain real-world experience while working alongside experienced insurance professionals in a collaborative environment.

 

Here’s what you can expect during your time with us:

Hands-On Learning: Gain practical exposure to commercial insurance operations, policy administration, and client service within a specialized program.

Professional Mentorship: Learn from experienced brokers and account managers who are invested in supporting your development.

Real Industry Experience: Contribute to live accounts and meaningful projects that impact clients and program performance.

Collaborative Culture: Work in a supportive team environment that values initiative, curiosity, and professionalism.

Networking Opportunities: Build relationships within the insurance industry and develop connections that can support your future career goals.

 

 

Service: Our Ethos

At HUB International, service defines who we are. This dedication extends not only to our clients but also to our employees and the communities we’re proud to support. Our regional offices are actively engaged in local initiatives, reflecting our commitment to giving back and making a meaningful difference.

 

When you join HUB, you’ll find more than just a career—you’ll become part of a team where your skills are valued, your growth is encouraged, and your contributions have a lasting impact.

 

We encourage you to let us know if you need any assistance or accommodation during the recruitment process. We believe in providing every candidate with an equal opportunity to succeed and thrive in our inclusive work environment.

 

The expected salary range for this position is $18-20/h and will be impacted by factors such as the successful candidate’s skills, experience and working location, as well as the specific position’s business line, scope and level. HUB International is proud to offer comprehensive benefit and total compensation packages which could include extended health benefits, disability insurance, RRSP matching, paid-time-off benefits, and eligible bonuses, and commissions for some positions. 

 

AI and Automation Notice: HUB International uses limited AI and automation tools within our recruitment systems to enhance efficiency in the hiring process and in the candidate experience. These tools do not independently make hiring decisions or screen out candidates — all decisions are made through human review.

Department Account Management & Service

Required Experience: Less than 1 year of relevant experience

Required Travel: No Travel Required

We endeavor to make this website accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact the recruiting team HUBRecruiting@hubinternational.com. This contact information is for accommodation requests only; do not use this contact information to inquire about the status of applications.