The Homesite Insurance Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Homesite Insurance Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Homesite Insurance? The Homesite Insurance Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for Homesite Insurance Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Homesite Insurance.</li>
<li>Practice real Homesite Insurance Business Intelligence interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Homesite Insurance Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Homesite Insurance? The Homesite Insurance Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Homesite Insurance Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Homesite Insurance.
- Practice real Homesite Insurance Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Homesite Insurance Business Intelligence interview.
        

Overview

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

Homesite Insurance Business Intelligence Interview Process

<p>Suppose your company needs to cut costs due to an economic downturn. During a coffee break, you hear a rumor that a lot of money goes to employees who don’t do their work, and you decide to find out if the rumor is true.</p>

<p>Given two tables: <code>employees</code> and <code>projects</code>, find the sum of the salaries of all the employees who didn’t complete any of their projects.</p>

<p>Clarification:</p>

<p>We will consider a project unfinished if it has no end date (its <code>End_dt</code> is <code>NULL</code>).</p>

<p>Given this, we’ll say an employee didn’t finish any of their projects when:</p>

<ul>
<li>They were assigned at least one project.</li>
<li>None of their projects have an <code>End_dt</code>.</li>
</ul>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>id</th>
<th>salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>projects</code> table</p>

<table>
<thead>
<tr>
<th>employee_id</th>
<th>project_id</th>
<th>Start_dt</th>
<th>End_dt</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>INTEGER</td>
<td>DATETIME</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>total_slack_salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Find the total salary of slacking employees.

Slacking Employees Salaries

<p>You’ve been asked to analyze the player’s behaviors at a gaming company.</p>

<p>Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><strong><code>players</code></strong> table</p>

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

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

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

<tr>
<td>players_10_plus_games</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Obtain count of players based on games played.

Player Analysis

<p>You have been given a table <code>tbl_numbers</code> with only one column: <code>int_numbers</code>.  It can have one integer number value per row in a sequential manner.</p>

<p>Write a query to return the number repeated by one times its own value.</p>

<p>For example, the integer number 5 would appear five times in the output (1 times 5).</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>tbl_numbers</code> table</p>

<table>
<thead>
<tr>
<th>int_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>seq_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>


Sequentially Fill in Integers

Homesite Insurance Business Intelligence Interview Questions

We are seeking a Product Analyst with insurance/product management experience to join our Performance team as part of the Product Analytics organization. The position includes responsibility for providing countrywide insights on the profit and growth performance of our Personal Lines products. This role will report directly to the Personal Lines Performance Senior Manager.

The Product Analyst is part of the Product Analytics team and will work cross functionally within Product Management on a regular basis to design and build financial and operational models and tools to report on and analyze performance and influence product improvements. Strong candidates are collaborative, curious, have a passion for working with data, problem solvers with strong quantitative acumen, demonstrate strong analytical and problem-solving skills. This position offers an excellent opportunity to interact with a variety of departments in the organization (Product, Finance, Claims, Reserving, Operations, etc.) and the broader American Family community.
Position Compensation Range:
$77,000.00 - $127,000.00 Pay Rate Type:
Salary Compensation may vary based on the job level and your geographic work location. Relocation support is offered for eligible candidates.
Primary Roles and Responsibilities:
Assist in the project management and creation of the monthly and quarterly reporting on Personal Lines business results.
Perform variance analysis on a countrywide basis.
Understand premium and coverage/peril drivers as well as claims and sales performance.
Deliver operational insights to achieve key performance indicators.
Analyze drivers of profitability, including production, retention, average premium, frequency/severity trends, loss ratios, and other data.
Recommend actions to achieve profitability and growth goals.
Perform modeling, “what-if’, scenarios on production, premium, and loss trends.
Build and enhance resources using Excel, Tableau, Power BI, etc. to create efficiency in processes used to maintain monthly and quarterly reporting
Requirements
Relevant Experience:  A minimum of 4 years of professional experience, ideally including work in Property & Casualty insurance.
Educational Credentials:  A bachelor’s degree and quantitative analytical knowledge is required; a graduate degree and/or CPCU designation is preferred, but not required.
Entrepreneurial Mindset:  A self-starter who can identify business opportunities, develop a product plan to capitalize on those opportunities, and successfully implement the plan.
Structured & Logical Thinking:  The ability to identify and define business problems and issues, and develop strategic, analytical, and financial frameworks to conduct analyses.
Analytical Rigor  : Analyze state performance, identify additional areas of research, and recommend improvements.
Powerful Communication  : The ability to communicate effectively, succinctly across a variety of media, and to various levels of management, including Senior Executives.
Team Player  : The candidate is collaborative, and able to work well as part of a team.
Software Experience:  Subject matter expertise in the areas of SQL, SAS, R, Python, Tableau, Power BI, and/or other programming/data query/reporting knowledge, in addition, intermediate to advanced skills in Microsoft Excel and PowerPoint. Think-cell knowledge is highly preferred.
Personal Qualifications:
The candidate selected for this position will be a creative, out-of-the-box thinker who is intellectually curious with a demonstrated interest in learning. This person will also need to be a self-motivated, high-energy individual who can easily function in a fast-paced, performance-driven environment. He/she must have a passion for working with big data, and building simple, visual tools and reports to analyze results. Be accustomed to working on multiple tasks in parallel and committed to meeting deadlines, including some with short time frames. This professional must demonstrate strong leadership skills, including the ability to gain credibility with and influence both team members and management.
In this hybrid role, you will be expected to work a minimum of 10 days per month from the office. Candidates should reside within approximately 35-50 miles of one of the following office locations: Madison, WI 53783; Boston, MA 02110
Internal candidates are encouraged to apply regardless of location
and will be considered based upon the needs of the role.

#LI-Hybrid
Your offer will be made contingent on the results of applicable background checks and signing a non-disclosure agreement for proprietary information, trade secrets, and inventions.
We encourage you to apply even if you do not meet all of the requirements listed above. Skills can be used in many different ways, and your life and professional experience may be relevant beyond what a list of requirements will capture. We encourage those who are passionate about what we do to apply!
We provide benefits that support your physical, emotional, and financial wellbeing. You will have access to comprehensive medical, dental, vision and wellbeing benefits that enable you to take care of your health. We also offer a competitive 401(k) contribution, a pension plan, an annual incentive, 9 paid holidays and a paid time off program (23 days accrued annually for full-time employees). In addition, our student loan repayment program and paid-family leave are available to support our employees and their families. Interns and contingent workers are not eligible for American Family Insurance Group benefits.
We are an equal opportunity employer. It is our policy to comply with all applicable federal, state and local laws pertaining to non-discrimination, non-harassment and equal opportunity. We also consider qualified applicants with criminal histories, consistent with applicable federal, state and local law.
#LI-DB1
#J-18808-Ljbffr

Question	Topic	Difficulty	Ask Chance
Slacking Employees Salaries	SQL	Medium	Very High
Player Analysis	SQL	Easy	Very High
Sequentially Fill in Integers	SQL	Hard	Very High

Homesite Insurance Business Intelligence Interview Guide

Overview

Homesite Insurance Business Intelligence Interview Process

Homesite Insurance Business Intelligence Interview Questions

Homesite Insurance Business Intelligence Jobs