Business Intelligence/Data AnalystChicago, IL

About Specialty Program Group:

Our goal is to partner with industry-leading specialty businesses to provide them with the ability to achieve their goals and optimize their businesses. Specialty Program Group offers access to capital andinvestment, deep carrier relationships, creative thinking, product development and broad distribution, while allowing our businesses to maintain the essence of what makes them successful. Specialty Program Group delivers leading-edge specialty expertise backed by transformative digital capabilities and sophisticated data and analytics.

About Squaremouth:

Squaremouth was launched in 2003 with the core goals of becoming the best workplace for its employees and the best place for customers to buy travel insurance. In 2014, we utilized our travel insurance expertise to develop and launch Tin Leg, a travel insurance brand with policies designed to address our customer’s most common and pressing travel concerns. Tin Leg quickly became one of the most popular travel insurance providers on and continues to offer some of the most comprehensive products in the travel insurance market.

We’ve grown from a small team to a company of over 50 employees, gaining national and international recognition along the way as one of the best customer service teams and best places to work. Widely recognized for our company culture, we are proud of most recently being named one of the Best Workplaces in America in 2023 by Inc. Magazine!

Continuing to strive toward our goal of being one of the most innovative companies in the field, Squaremouth was acquired in April 2023 by Specialty Program Group (SPG), a leading operator of specialty insurance brokerages and underwriting facilities. Today,, and its multi-award winning customer service team, has helped over 3 million travelers save time and money to find the best travel insurance policy for their trip.

Position Summary:

Squaremouth's mission is to take complicated insurance products and allow customers to easily compare them to find exactly what they need for peace of mind as they travel away from home.

We are looking for an experienced and motivated Business Intelligence analyst to join our team. We are looking for a team player who can work in a highly collaborative environment. They will teach themselves, learn from others, and take ownership of their successes and challenges. The ideal candidate should have an intrinsic desire for personal growth and professional success.

As the Business Intelligence analyst, you will be a valuable partner to the leadership teams across our company, developing and delivering high-impact, data-driven solutions to support business objectives and operations. You will play an important role in building and improving our data gathering and reporting capabilities, as well as critically assessing and analyzing collected data.

What you will do:

  • Design and develop tools, techniques, metrics, and dashboards for insights and data visualization

  • Examine and identify data patterns and trends to help answer business questions and improve decision making

  • Generate cross-functional solutions through the collection, interpretation, evaluation, and analysis of large data sets

  • Collaborate with key stakeholders to align data-driven solutions with business strategies and needs

  • Work cross-functionally with multiple teams and departments in the company

Experience and skills that are important for success in this position:

  • Bachelor's degree (4-year) specialized in a relevant discipline

  • 2-4 years of experience in an analytical role

  • On-the-job experience with statistical programming languages such as Python, R, or SQL

  • Experience with aggregating, transforming, and integrating data from various sources into AWS services for analysis

  • Ability to simplify complex technical and statistical information for various leaders and team members across the organization

  • Passion for growing your skills, tackling interesting work, and challenging problems

  • Excellent interpersonal, oral, and written communication skills

  • Energetic, positive attitude

It would be great if you had experience with:

  • Building reports using Tableau, Looker, Quicksight or similar BI Tool

  • Writing efficient SQL queries for MySQL

  • Designing dashboards to effectively communicate performance

  • Building documentation around data models to better understand and develop systems for future requirements


  • Salary range for this position is $75,000 - $100,000 annually, commensurate with experience

  • 401(k) match

  • Mandatory birthday off with $200 bonus

  • Involvement in major Squaremouth decisions

  • We are currently full time remote

Disclosure required under applicable state or municipality regulations: The expected salary range for this position is $75,000 - $100,000 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 health/dental/vision/life/disability insurance, FSA, HSA and 401(k) accounts, paid-time-off benefits, and eligible bonuses, equity and commissions for some positions.

Department Business Operations

Required Experience: 2-5 years of relevant experience

Required Travel: No Travel Required

Required Education: Bachelor's degree (4-year degree)

HUB International Limited is an equal opportunity and affirmative action employer that does not discriminate on the basis of race/ethnicity, national origin, religion, age, color, sex, sexual orientation, gender identity, disability or veteran's status, or any other characteristic protected by local, state or federal laws, rules or regulations. The EEO is the Law poster and its supplement is available here at

EEOAA Policy

E-Verify Program

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 US Recruiting Team toll-free at (844) 300-9193 This contact information is for accommodation requests only; do not use this contact information to inquire about the status of applications.