The Starr Companies Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Starr Companies Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Starr Companies? The Starr Companies 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 Starr Companies Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Starr Companies.</li>
<li>Practice real Starr Companies 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 Starr Companies Business Intelligence interview.</p>


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

- Know what skills are necessary for Starr Companies Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Starr Companies.
- Practice real Starr Companies 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 Starr Companies Business Intelligence interview.
        

Overview

Starr Companies Business Intelligence Salary

<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.

Starr Companies Business Intelligence Interview Process

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.</p>

<p>Write a query to get the total three-day rolling average for deposits by day.</p>

<p><em>Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout</em></p>

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

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

<p><code>bank_transactions</code> table</p>

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

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

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

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

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

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Rolling Bank Transactions

<p>Let’s say you’re working for a social media company trying to grow your user base. You know that people tend to use the same social network as their peers, so you want to target all your growth and marketing efforts on specific age groups so as to take advantage of network effects.</p>

<p>You wish to begin with the age group that is currently generating the most connections (fastest growing).</p>

<p>Write a SQL query to find the average number of accepted friend requests for each age group and order the results in descending order.</p>

<p><em>Note: The average number of accepted friend requests is calculated as the total number of friend requests sent by an age group that was accepted divided by the number of members in said age group.</em></p>

<p><em>We can assume the tables hold valid data in that there are no duplicate friend requests, friend requests are only accepted once, and user A can only accept a friend request from User B after B sends A a friend request.</em></p>

<p><em>The result should be rounded to two decimal places.</em></p>

<h3>Example:</h3>

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

<p><strong><code>friend_requests</code></strong></p>

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

<tbody>
<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>receiver_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>sent_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>requests_accepted</code></strong></p>

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

<tbody>
<tr>
<td>accepter_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>accepted_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>age_groups</code></strong></p>

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

<tbody>
<tr>
<td>user_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>age_group</td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td>age_group</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>average_acceptance</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Find the average number of accepted friend requests for each age group that sent the requests.

Avg Friend Requests By Age Group

<p>Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.</p>

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

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

<p><code>transactions</code> table</p>

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

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

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>users</code> table</p>

<table>
<thead>
<tr>
<th>Column</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>
<p> 
<strong>Output:</strong></p>

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

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


<p>Which of the following queries will return a list of customers and the total amount they have spent on orders?</p>


Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

Starr Companies Business Intelligence Interview Questions

<p>Starr Insurance Companies is a leading insurance and investment organization, providing commercial property and casualty insurance, including travel and accident coverage, to almost every imaginable business and industry in virtually every part of the world. <br><br>Cornelius Vander Starr established his first insurance company in Shanghai, China in 1919. Today, we are one of the world's fastest growing insurance organizations, capable of writing in 128 countries on 6 continents. <br><br><strong>Why Join Starr Companies?</strong> <br><br>At Starr Companies, our software development team pride ourselves on fostering a culture of excellence where merit, innovation, and collaboration are at the forefront. We believe in empowering our employees to grow professionally and contribute to the success of our global mission. Here's what you can expect working with us: <br></p><ul> <li><b>Merit-Based Environment</b>: We are committed to recognizing and rewarding outstanding performance, ensuring that the best ideas and contributions are always given the opportunity to shine. </li><li><b>Innovative Spirit</b>: Continuous improvement is part of our DNA. We encourage creative problem-solving and the exploration of new technologies to stay ahead in our industry. </li><li><b>Collaborative Teamwork</b>: Our team is our greatest asset. We work together in a supportive atmosphere that values open communication and perspectives. </li><li><b>Professional Growth</b>: We invest in our employees through professional development opportunities, training programs, and a culture that promotes career advancement. </li></ul><strong>Day-to-Day Responsibilities:</strong> <br><ul> <li>Design and build intuitive, efficient user interfaces using the latest stable releases of Angular and Blazor WASM. </li><li>Develop, maintain, and deploy stable, scalable, and secure APIs with .NET 8. </li><li>Employ modern design practices with HTML5 and CSS. </li><li>Focus on building and maintaining automated build and release pipelines, enhancing the deployment process in Azure DevOps. </li><li>Engage in active development by fully leveraging a wide range of Azure services and tools, optimizing performance and scalability through native serverless and PaaS Azure resources. </li><li>Work closely with customers and business stakeholders to comprehensively understand their needs and requirements, and ensure that software applications are aligned and developed to meet those needs. </li><li>Collaborate with cross-functional teams, both within IT and the business, to identify and prioritize software development initiatives. </li><li>Effectively communicate development progress and issues to executive leadership. </li></ul><strong>Skills and Experience:</strong> <br><ul> <li>Bachelor's degree in computer science or a related field. </li><li>Extensive professional experience (5+ years) with the Microsoft stack, particularly with .NET (including .NET 6+) and Angular. </li><li>Solid background in MSSQL & NoSQL encompassing database design, maintenance, and optimization. EF (Entity Framework) code first experience is a must. </li><li>Proficiency in JavaScript and front-end frameworks/libraries. </li><li>Proficiency in designing and implementing state-of-the-art APIs, with a focus on modern standards and best practices in API architecture. </li><li>Competence in source control management using Git. </li><li>Proven ability in writing effective unit tests and refining testing practices leveraging nUnit/xUnit. </li><li>A deep understanding of cloud architectures and DevOps practices. </li><li>Strong understanding of software development life cycle, including requirements gathering, design, development, testing, and deployment. </li><li>Knowledge of software development best practices and methodologies. </li><li>Proficiency in leadership and management abilities. </li><li>Strong analytical and problem-solving skills. </li><li>Self-motivated with the capability to prioritize and execute tasks in a high-pressure environment. </li><li>Strong organizational and time management skills. </li><li>Excellent communication and collaboration skills. </li><li>Additional certifications and relevant training are highly valued. </li></ul><strong><b>Nice-to-Haves:</b></strong> <br><ul> <li>Experience with designing, developing, and maintaining Blazor WASM applications in a production environment. </li><li>In-depth experience with various Azure services, showcasing a comprehensive understanding of the platform. </li><li>Experience in the insurance industry. </li></ul> <br><br>#LI-EP1 <br><br>Starr is an equal opportunity employer, which means we'll consider all suitably qualified applicants regardless of gender identity or expression, ethnic origin, nationality, religion or beliefs, age, sexual orientation, disability status or any other protected characteristic. We recruit and develop our people based on merit and we're committed to creating an inclusive environment for all employees. We offer first class training and development opportunities to all employees. Our aim is to grow our own talent and bring out the best in people.

Starr Insurance Companies is a leading insurance and investment organization, providing commercial property and casualty insurance, including travel and accident coverage, to almost every imaginable business and industry in virtually every part of the world.

Cornelius Vander Starr established his first insurance company in Shanghai, China in 1919. Today, we are one of the world's fastest growing insurance organizations, capable of writing in 128 countries on 6 continents.

Starr Companies is a globally recognized insurance and investment organization with a rich history dating back to 1919. Our commitment to innovation drives us to continuously improve our tools and technologies. We're looking for a Senior Full Stack Software Engineer to play a pivotal role in reshaping our software for underwriters and staff. If you're passionate about creating durable, industry-leading solutions and want to work with a team of dedicated developers, your expertise is needed here.

Why Join Starr Companies?

At Starr Companies, our software development team pride ourselves on fostering a culture of excellence where merit, innovation, and collaboration are at the forefront. We believe in empowering our employees to grow professionally and contribute to the success of our global mission. Here's what you can expect working with us:

Merit-Based Environment : We are committed to recognizing and rewarding outstanding performance, ensuring that the best ideas and contributions are always given the opportunity to shine.
Innovative Spirit : Continuous improvement is part of our DNA. We encourage creative problem-solving and the exploration of new technologies to stay ahead in our industry.
Collaborative Teamwork : Our team is our greatest asset. We work together in a supportive atmosphere that values open communication and perspectives.
Professional Growth : We invest in our employees through professional development opportunities, training programs, and a culture that promotes career advancement.
Day-to-Day Responsibilities:     Design and build intuitive, efficient user interfaces using the latest stable releases of Angular and Blazor WASM.
Develop, maintain, and deploy stable, scalable, and secure APIs with .NET 8.
Employ modern design practices with HTML5 and CSS.
Focus on building and maintaining automated build and release pipelines, enhancing the deployment process in Azure DevOps.
Engage in active development by fully leveraging a wide range of Azure services and tools, optimizing performance and scalability through native serverless and PaaS Azure resources.
Work closely with customers and business stakeholders to comprehensively understand their needs and requirements, and ensure that software applications are aligned and developed to meet those needs.
Collaborate with cross-functional teams, both within IT and the business, to identify and prioritize software development initiatives.
Effectively communicate development progress and issues to executive leadership.
Skills and Experience:     Bachelor's degree in computer science or a related field.
Extensive professional experience (5+ years) with the Microsoft stack, particularly with .NET (including .NET 6+) and Angular.
Solid background in MSSQL & NoSQL encompassing database design, maintenance, and optimization. EF (Entity Framework) code first experience is a must.
Proficiency in JavaScript and front-end frameworks/libraries.
Proficiency in designing and implementing state-of-the-art APIs, with a focus on modern standards and best practices in API architecture.
Competence in source control management using Git.
Proven ability in writing effective unit tests and refining testing practices leveraging nUnit/xUnit.
A deep understanding of cloud architectures and DevOps practices.
Strong understanding of software development life cycle, including requirements gathering, design, development, testing, and deployment.
Knowledge of software development best practices and methodologies.
Proficiency in leadership and management abilities.
Strong analytical and problem-solving skills.
Self-motivated with the capability to prioritize and execute tasks in a high-pressure environment.
Strong organizational and time management skills.
Excellent communication and collaboration skills.
Additional certifications and relevant training are highly valued.
Nice-to-Haves:      Experience with designing, developing, and maintaining Blazor WASM applications in a production environment.
In-depth experience with various Azure services, showcasing a comprehensive understanding of the platform.
Experience in the insurance industry.

#LI-EP1

Starr is an equal opportunity employer, which means we'll consider all suitably qualified applicants regardless of gender identity or expression, ethnic origin, nationality, religion or beliefs, age, sexual orientation, disability status or any other protected characteristic. We recruit and develop our people based on merit and we're committed to creating an inclusive environment for all employees. We offer first class training and development opportunities to all employees. Our aim is to grow our own talent and bring out the best in people.

Starr Companies Business Intelligence Interview Guide

Overview

Starr Companies Business Intelligence Salary

Starr Companies Business Intelligence Interview Process

Starr Companies Business Intelligence Interview Questions

Starr Companies Business Intelligence Jobs