The Evil Geniuses Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Evil Geniuses Business Intelligence Interview Guide

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


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

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

Overview

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

Evil Geniuses 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>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>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

Evil Geniuses Business Intelligence Interview Questions

<h3>141 W Jackson Blvd. Suite 500 Chicago, IL 60604</h3><p>Headquartered in the historic Chicago Board of Trade, PEAK6 Capital Management is a proprietary options trading firm that has been defining the industry for more than 25 years. While many firms have come and gone, PEAK6 Capital Management has consistently delivered liquidity to the options market. We thrive due to our firm’s special blend of financial acumen, ability to manage risk, and cutting-edge technology.</p><p>PEAK6 Capital Management was brought to life through insatiable curiosity, entrepreneurial spirit, and the desire to win. We offer incredible opportunities for smart, passionate team players to solve complex problems and take calculated risks. We were among the first firms to develop sophisticated proprietary technology in our trading business. Today, we continue to leverage our technical ingenuity and operational excellence across several investment areas, spanning early-to-mid stage growth capital, operational control, trading, and eSports. Throughout the years, we've built and operated several financial technology firms and we continue to evolve.</p><p><b>ABOUT THIS ROLE</b></p><p>As an Engineering Manager, you will have the opportunity to lead a cross-functional team that is creating high-quality, trusted data for our trading business. This team collaborates directly with traders to identify, develop, and validate new signals as well as sourcing commodity datasets from vendors. You’ll report to our Director, Engineering. This role can be based out of our Chicago or New York City offices.</p><p><b>You’ll be responsible for:</b></p><ol><li>Working hand in hand with Product Managers to help write User Stories and fuel discovery for the team.</li><li>Setting team expectations including performance metrics and holding members accountable to those expectations while making adjustments as necessary.</li><li>Encouraging the team to continuously invest in their delivery process to remove friction and increase developer experience.</li><li>Collaborating with staff engineers and architects to define technical standards and direction.</li><li>Identifying and removing bottlenecks as well as connecting engineers across teams.</li><li>Primary driver of career development of team members including mentoring junior engineers, aligning opportunities to engineers to make cases for promotions and continuously giving feedback.</li><li>Supporting team’s current delivery of working software, while balancing time by also collaborating with product managers and traders to prepare the backlog of upcoming projects.</li></ol><p><b>YOUR EXPERIENCE</b></p><ol><li>Bachelors or Masters Degree in Computer Science, Engineering, or related field.</li><li>Strong technical credentials, with at least 3-5 years’ experience managing software development teams, ideally with some hands-on architectural or distributed systems experience.</li><li>Technical hands-on coding background, preferably with Java, Python, or GoLang.</li><li>Excellent written and verbal communication skills with the ability to present complex technical information in a clear and concise manner to a variety of audiences, including executives and non-technical leaders.</li><li>Understanding of agile practices and ability to enforce them in variable team size settings.</li><li>Familiarity with a wide range of engineering practices such as iterative development, continuous integration and delivery, or resilience engineering.</li><li>Curiosity and eagerness to explore both quantitative and qualitative data to drive continuous improvement at the team and organization levels.</li></ol><p><b>Does our Engineering DNA Match yours?</b></p><ol><li>We collaborate in cross-functional, agile teams to learn and develop innovative technology.</li><li>We like to develop impactful features fast so we can share directly with our end-users and iterate quickly.</li><li>We’re focused on well-defined software delivery and continuous learning.</li><li>People are everything and our support for each other is abundant.</li><li>We are motivated by solving business problems and encourage entrepreneurial thinking from everyone in the organization.</li><li>Whether you’re new to our tech stack or an expert, we encourage each team member to experiment with new technologies and take ownership of projects.</li><li>We love to have fun and dedicate time to exploring new technologies and ideas through Tech Days and Hackathons.</li></ol><p><b>OUR REWARDS</b></p><p>We offer a robust package of employee perks and benefits, including healthcare benefits (medical, dental and vision, EAP), competitive PTO, 401k match, parental leave, and HSA contribution match. We also provide our employees with a paid subscription to the Calm app and offer generous external learning and tuition reimbursement benefits. As a hybrid workforce, we offer our employees the ability to work remotely up to two days a week. <i>The base pay offered may vary depending on job-related knowledge, skills, experience, and office location. This position also may be eligible for a discretionary annual bonus in addition to a range of health & wellness benefits.</i></p><p>PEAK6 is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, and gender identity), national origin, age, disability, veteran status, marital status, or any other protected characteristic.</p><p>PEAK6 is committed to creating an inclusive and accessible workplace for all candidates, including those with disabilities. We are dedicated to ensuring equal employment opportunities and providing reasonable accommodations to qualified individuals with disabilities. If you require reasonable accommodations to participate in the application or interview process, please contact our HR department at hrpeak6@peak6.com. We will work with you to provide the necessary accommodations to ensure your full participation in our hiring process.</p>
#J-18808-Ljbffr

Evil Geniuses Business Intelligence Interview Guide

Overview

Evil Geniuses Business Intelligence Salary

Evil Geniuses Business Intelligence Interview Process

Evil Geniuses Business Intelligence Interview Questions

Evil Geniuses Business Intelligence Jobs