Business Intelligence Analyst

Hi, we’re HUB!

We are proud to be ranked 5th among the world’s largest insurance brokerages where we advise businesses and individuals on how to reach their goals. When you partner with us, you’re at the center of a vast network of risk, insurance, employee benefits, retirement and wealth management specialists that bring clarity to a changing world with tailored solutions and unrelenting advocacy – so you’re ready for tomorrow.

The Opportunity!

As a Business Intelligence Analyst, you will report directly to the Director of Business Intelligence and collaborate with Senior Executive Leadership. Your primary responsibility will be to transform raw data into actionable insights using Power BI. By working closely with business stakeholders, you'll create data visualizations, reports, and dashboards that support strategic decision-making across the organization. The ideal candidate will possess strong analytical skills, expertise in Power BI, and proficiency in using SQL in large datasets to deliver actionable insights.

Core Competencies -

• Undergraduate program with a Major in Business Accounting, Computer Science or Math
• Proven experience as a Power BI Data Analyst or in a similar data analysis role.
• Solid understanding of SQL for querying and configuring data.
• Self-motivated with a strong interest in learning about the insurance industry.
• Excellent verbal and written communication skills.
• Exceptional organizational skills and the ability to manage multiple tasks simultaneously.
• Collaborative team player with a willingness to assist others.
• Enthusiastic about learning and being mentored by experienced professionals.
• Ability to work independently as needed.
• Strong prioritization and time management skills.
• A positive, team-oriented attitude focused on continuous learning.
• Proficiency in Microsoft Office Suite (Excel, Outlook).
• Ability to collaborate effectively with remote teams.
• Knowledge of the insurance industry is a plus.

Key Responsibilities -

• Proficiency in Data Visualization and Dashboard Development (Microsoft Power BI - Intermediate level)
• Expertise in Data Warehousing and advanced SQL, with a focus on creating analytical queries
• Advanced SQL development
• Python knowledge for data analysis and automation tasks
• Experience with Power Automate for flow development
• Familiarity with API integration (PowerShell, REST APIs) is a plus
• Knowledge of designing and developing data marts, views, and BI semantic layers for governed reporting and self-service analytics.
• Ensure data quality and integrity through regular validation and troubleshooting of discrepancies.
• Support business users by providing training and guidance on utilizing Power BI reports and dashboards.

Key Attributes -

• Detail-oriented and highly organized.
• Strong critical thinking and problem-solving abilities.
• A team player who thrives in a collaborative environment.
• A proactive learner, eager to develop new skills and stay current with industry trends.
• Positive attitude and strong work ethic.

Why Join HUB?

• Do you enjoy making friends? We love making friends; join our team of amazing people who all get along and thrive together!
• We work hard and play hard! Get ready for our Staff Holiday Parties!!
• Paid day off for your birthday – we want to celebrate you!
• Paid half a day off for volunteering in your community - HUB is a company that gives back and is active in our communities
• Room to grow within the organization
• Lots of company perks, benefits, RRSP matching and great compensation

Your future with HUB –

Choose a career with HUB International and take the first step toward creating a future that combines a diverse, challenging work environment with financial security and career satisfaction. By joining HUB, you will become part of a rapidly growing company that offers significant opportunity for advancement.

What makes us different than all the rest?

Our Vision: To be everywhere risk exists – today and tomorrow. Helping protect what matters most.

Our Mission: To protect and support the aspirations of individuals, families and businesses. To empower our employees to learn, grow and make a difference in their communities.

Our Core Values:

• Entrepreneurship: We encourage innovation and educated risk-taking.

• Integrity: We do the right thing every time.

• Teamwork: We work together to maximize results.

• Accountability: We measure and take responsibility for outcomes.

• Service: We serve customers, communities and colleagues.

If you value what we value, and like the perks along the way – Apply TODAY!

The employment offer is contingent upon completion of a successful background check.

HUB is a company where your contributions will make a difference. We invite you to learn more about our team at www.hubinternational.com. If you require any accommodations during the hiring process, please reach out to hcw.hr@hubinternational.com to request this. Only candidates selected for an interview will be contacted.