The E15 group Business Intelligence interview guide, interview questions, salary data, and interview experiences.

E15 group Business Intelligence Interview Guide

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


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

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

Overview

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

E15 group 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>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

<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

E15 group Business Intelligence Interview Questions

<h3>Job Description</h3><div>Job Description<div><div> E15 Group <p></p><p><b>Position Title: Senior Business Analyst, Data Engineering</b></p><p><b>Salary: $105,000 - 115,000</b></p><p>At E15, we are the spark that ignites. Our team delivers next-generation insights based on data, not hunches, to drive business in healthcare, campus, corporate, sports, entertainment, hospitality, and retail industries to help companies make forward-looking decisions to benefit their business and their guests. For more information on what we are about as a company, check us out by following the link below: www.e15group.com</p><div><div><div><b>Job Summary</b></div><div><p>At E15, our Data Engineering team is at the forefront of delivering cutting-edge data reporting solutions to both internal and external clients. As a Senior Business Analyst, you will play a pivotal role in bridging the gap between business needs and technical execution. Your mission: to transform complex business requirements into actionable technical specifications, ensuring that our data assets consistently exceed user expectations.</p><p></p><p><b>Who You Are:</b></p><ul><li>A strategic thinker with strong business acumen who can understand and anticipate client needs.</li><li>A natural communicator, fluent in both business and technical languages, who can clearly articulate requirements to technical teams.</li><li>A self-starter with a passion for data, excited to collaborate with developers, data scientists, and engineers to deliver exceptional data products.</li></ul><p></p><p><b>Your Impact:</b> As part of a highly motivated and innovative data services team, you’ll collaborate with Business Intelligence Developers, Data Scientists, Data Engineers, and software developers to build and deliver industry-leading BI products. Your work will directly impact how our clients-from across the broader E15 and Compass organizations-leverage data to drive decision-making and innovation.</p><p></p><p><b>What You’ll Do:</b></p><ul><li>Own the intake process: You’ll work closely with our Business Analytics, Business Intelligence, and Data Science teams to gather, refine, and document business requirements, ensuring clarity and alignment with client needs.</li><li>Be the voice of the client: Ensure delivered data assets meet client expectations by maintaining open communication, documenting feedback, and adapting to evolving requirements.</li><li>Manage our project catalog: You’ll be responsible for maintaining and updating the project asset catalog (Secoda.co), ensuring that all data products are accurately cataloged and documented.</li><li>Collaborate with SMEs: Engage with subject matter experts across E15 and Compass to gain a deep understanding of our business and ensure that data products align with organizational objectives.</li><li>Document data assets: Assess and document the data currently produced by clients, ensuring quality, consistency, and availability are up to standard.</li><li>Craft technical specs: Write detailed technical requirements for our developer teams to turn business needs into actionable solutions.</li><li>Present and receive feedback: Showcase new data products and features to stakeholders, ensuring their input is integrated into future iterations.</li><li>Work in an agile environment: You’ll collaborate with project managers and technical teams throughout the software development lifecycle, ensuring projects are delivered on time and meet the highest quality standards.</li></ul><p></p><p><b>What We’re Looking For:</b></p><ul><li>Experience: 5+ years of experience in reporting and business analysis, with a track record of translating business needs into technical requirements.</li><li>SQL Skills: Intermediate level SQL proficiency to help interpret data and communicate with technical teams.</li><li>Presentation Skills: Comfortable presenting data products and technical solutions to non-technical stakeholders, turning complex data insights into understandable business value.</li><li>Attention to Detail: You’re meticulous when it comes to documenting requirements and ensuring data quality.</li><li>Interpersonal Skills: Strong soft skills that allow you to build relationships and collaborate effectively across technical and non-technical teams.</li></ul><p></p><p>If you’re passionate about data, have a keen eye for detail, and thrive in a fast-paced, collaborative environment, we’d love to have you on our team. Join us in shaping the future of data reporting at E15!</p></div></div></div><p><b>Apply to E15 today!</b></p><p><em>E15 is a member of Compass Group USA</em></p><p><b>Click here to Learn More about the Compass Story</b></p><p> </p><p><b>Compass Group is an equal opportunity employer.  At Compass, we are committed to treating all Applicants and Associates fairly based on their abilities, achievements, and experience without regard to race, national origin, sex, age, disability, veteran status, sexual orientation, gender identity, or any other classification protected by law. We will consider for employment all qualified applicants, including those with a criminal history (including relevant driving history), in a manner consistent with all applicable federal, state, and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance, the San Francisco Fair Chance Ordinance, and the New York Fair Chance Act. </b></p><p> </p><p><b>Associates at E15</b><b> </b><b>are offered many fantastic benefits.</b></p><ul><li>Medical</li><li>Dental</li><li>Vision</li><li>Life Insurance/ AD</li><li>Disability Insurance</li><li>Retirement Plan</li><li>Paid Time Off</li><li>Holiday Time Off (varies by site/state)</li><li>Associate Shopping Program</li><li>Health and Wellness Programs</li><li>Discount Marketplace</li><li>Identity Theft Protection</li><li>Pet Insurance</li><li>Commuter Benefits</li><li>Employee Assistance Program</li><li>Flexible Spending Accounts (FSAs)</li></ul><p> </p><p>Associates may also be eligible for paid and/or unpaid time off benefits in accordance with applicable federal, state, and local laws. For positions in Washington State, Maryland, or to be performed Remotely, click here for paid time off benefits information.</p><p> </p><p><b>Req ID:  1367724</b></p><p><b>E15 Group </b></p><p><b>Margaret Lovette </b></p><p><b><span class="long-word">[[req_classification]]</span> </b></p></div><br><br></div></div>

E15 group Business Intelligence Interview Guide

Overview

E15 group Business Intelligence Salary

E15 group Business Intelligence Interview Process

E15 group Business Intelligence Interview Questions

E15 group Business Intelligence Jobs