**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.