About the Role
We’re seeking a Business Analyst to join our Analytics team, supporting key decision-makers with actionable insights and efficient dashboard solutions. If you thrive in a dynamic environment and want to make an impact, this is the role for you.
Responsibilities
- Oversee all reporting and analysis for our personal insurance division (including retention reports, customer data analysis, year over year analysis, new business, etc.)
- Maintain, update, and enhance dashboards using Power BI, ensuring data accuracy and accessibility for leadership and finance teams
- Perform monthly analyses of financial metrics, including organic growth and new business trends, delivering insights to unit leaders
- Reconcile and upload data from multiple sources into visualization tools, ensuring consistency with corporate financial systems
- Prepare revenue forecasts, and year-end projections, to support business planning
- Create and maintain automated processes to enhance efficiency and reduce manual efforts across reporting workflows
- Provide ad hoc analysis and collaborate on special projects to support business objectives
Requirements
- 1-3 years of experience in data analysis or a related role
- Exposure to Power BI and advanced Excel functionalities (Pivot Tables, Macros, VBA, etc.)
- Proficiency in Python, SQL, and data visualization tools, with a focus on creating impactful dashboards and reports
- Exceptional attention to detail and organizational skills, ensuring high-quality output in a fast-paced environment
- A growth mindset with a drive to learn, collaborate, and innovate
- Strong teamwork and communication skills to work effectively with leadership, finance, and other departments
- We may ask you to complete an attribute-based assessment and other skills tests (such as coding, or MS office), at our Toronto office
Skills
- Power BI
- Advanced Excel
- Pivot Tables
- Macros
- VBA
- Python
- SQL
- Data visualization tools
Location
- Toronto
Work Type
- Onsite
Experience Level
- 1-3 years
Education Level
- Post-secondary education in Analytics, Economics, Finance, or a related field is an asset
Salary/Compensations
- $57,000 to $66,000
Benefits
- Competitive compensation package
- Incentives
- Bonuses
- Additional earning opportunities
- Flexible working arrangements
- Generous time-off policies
- Company-matched RRSPs
- HUB-sponsored training programs
- Tuition reimbursement
- Reimbursements for professional licensing and membership fees
- Special discounts on events, travel, accommodations, and personal home & auto insurance
About the Company
- HUB International is a premier insurance brokerage. Our expansive network, powered by over 20,000 dedicated professionals across 500 offices in North America, sets the stage for an enriching career that promises both stability and remarkable growth opportunities.
- In a rapidly changing world, we advise businesses and individuals on how to prepare for the unexpected. When you partner with us, you're at the center of a vast network of experts who will help you reach your goals through risk services, claims management, and compliance support.
- Headquartered in Chicago, Illinois, HUB International Limited (HUB) is a leading full-service global insurance broker providing property and casualty, life and health, employee benefits, investment and risk management products and services. From offices located throughout North America, HUB's vast network of specialists provides peace of mind on what matters most by protecting clients through unrelenting advocacy and tailored insurance solutions.
Equal Opportunity
- At HUB International, we are dedicated to fostering a culture where everyone feels a sense of belonging. We value the unique experiences and perspectives that each team member brings, creating an environment where all voices are welcomed and respected.
- If you require assistance or accommodation at any stage of the recruitment process, we encourage you to let us know—we’re here to support you.
- At HUB, building an inclusive workplace isn’t just part of what we do—it’s at the heart of who we are.
