Prepare for and practice interview questions from Hub International.

Hub International Interview Questions

Hub International Interview Guides

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Hub International Salaries by Position

Business Analyst Riverside, CA Hi were HUB . We are proud to be ranked 5th among the worlds largest insurance brokerages, advising businesses and individuals on how to prepare for the unexpected. At HUB we believe in investing in the future of our employees. Our entrepreneurial culture fosters an environment of open feedback and improvement that empowers our people to make the best decisions for our clients and organization. We are seeking a Business Analyst in the H ub Financial Center (HFC) , the centralized accounting team for HUB International. This is a hybrid work environment reporting to our Riverside, CA office. The Business Analyst will be responsible for supporting a leader from the HFC Management Team in analyzing business processes, identifying areas for improvement, and developing strategies to enhance efficiency and productivity. The ideal Business Analyst candidate will possess strong analytical skills and a deep understanding of business operations. Key Responsibilities <ul><li>Requirements Gathering - Collaborate with stakeholders to understand their needs and gather detailed business requirements. </li><li>Data Analysis - Analyze data to identify trends, patterns, and insights that inform business decisions. </li><li>Process Modeling - Develop and document business process models to illustrate current and future states. </li><li>Solution Development - Propose and design technical and process solutions that meet business needs and objectives. </li><li>Implementation Support - Work with Management and other departments to implement solutions and ensure they align with business goals. </li><li>Stakeholder Communication - Communicate findings, recommendations, and project updates to stakeholders and executives. </li><li>Documentation - Create detailed documentation of business requirements, processes, and solutions. </li><li>Quality Assurance - Participate in testing and validating new systems and processes to meet business requirements. </li><li>Continuous Improvement - Identify opportunities for process improvements and contribute to ongoing optimization efforts. </li> </ul>Qualifications Skills <ul><li>Strong analytical and problem-solving skills. </li><li>Proficiency in data analysis tools and techniques. </li><li>Excellent communication and interpersonal skills. </li><li>Ability to work collaboratively with cross-functional teams. </li><li>Experience with business process modeling and documentation tools. </li><li>Knowledge of project management methodologies and tools. </li> </ul>Preferred Qualifications <ul><li>Experience in Accounting, Finance, or Business-related field. </li><li>Familiarity with Applied Systems, Vertafore Products, Microsoft Applications, and Data Analytics Platforms. </li> </ul>Education <ul><li>Bachelor's degree in Business Administration, Accounting, or a related field is a plus. </li> </ul>Experience <ul><li>Minimum of 3+ years of experience as a Business Analyst or in a related Analyst role. </li> </ul>Disclosure required under applicable municipal regulations in NY and NJ, as well as the law in Colorado, California and Washington states: The expected salary range for this position is $65,000 to $90,000 and will be impacted by factors such as the successful candidates skills, experience and working location, as well as the specific positions business line, scope and level. If you believe that your qualifications and experience surpass the minimum requirements for this role, we encourage you to submit your application. By doing so, we will be able to keep your application on file for consideration for potential future positions within our organization. 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 such as vacation, sick, and personal days, and eligible bonuses, equity and commissions for some positions. Department Accounting & Finance 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 http://www.dol.gov/ofccp/regs/compliance/posters/ofccpost.htm . EEOAA Policy (https://hubinternational.jobs/eeo/) 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 or USRecruiting@hubinternational.com . This contact information is for accommodation requests only; do not use this contact information to inquire about the status of applications.

International. HUB International is a top 5 global insurance broker providing a broad array of property, casualty, risk management, life and health, employee benefits, investment and wealth management products and services. HUB has more than 600 offi Reporting Analyst, Operations, Analyst, Accounting, Reporting, Operation, Manufacturing

Hub International Interview Questions

Hub International Interview Guides

Hub International Interview Questions

Hub International Salaries by Position

Hub International Opening Jobs