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

Caltech Business Intelligence Interview Guide

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


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

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

Overview

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

Caltech 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 the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

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

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

<p><code>employees</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>

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</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>

<tr>
<td><code>team</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>manager</code></td>
<td>VARCHAR</td>
</tr>

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


Manager Team Sizes

<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

Caltech Business Intelligence Interview Questions

<p>Caltech is a world-renowned science and engineering institute that marshals some of the world's brightest minds and most innovative tools to address fundamental scientific questions. We thrive on finding and cultivating talented people who are passionate about what they do. Join us and be a part of the diverse Caltech community. Job Summary Senior Software Engineer on the CliMA project, responsible for a wide array of tasks within the software stack, currently focused on the atmosphere and land models and numerical methods. Essential Job Duties Reviews and critiques code of other staff; maintains code health using automated unit tests and continuous integration and profiling tools. Develops, implements, and validates mathematical algorithms for climate models, including numerical methods for atmosphere and land models. Develops strategy to improve computational efficiency and usability of climate models. Develops and implements innovative application programming interfaces that maximize performance and accessibility of climate models. Develops technical solutions for numerical methods and machine learning in climate models. Basic Qualifications BS or equivalent degree in a quantitative field such as computer science, applied mathematics, physics, engineering, or Earth Science. Experience developing large software projects in a distributed fashion, e.g., contributing to an open-source project with distributed contributors. Experience working with high-performance computing systems, including many core processors and accelerators. Experience with at least two programming languages (e.g., C/C++, Fortran, C#, Objective C, Python, Julia, and Matlab/Octave). Preferred Qualifications Graduate degree in computer science or a science or engineering field. Experience working with high-performance computing systems, including multicore processors and GPU or other accelerators. Experience in either physics, computational fluid dynamics, or machine learning. Experience working in multi-disciplinary teams and interacting cross-functionally with a wide variety of people. Required Documents Curriculum Vitae Hiring Range $115,000 to $157,500 per year The salary of the finalist(s) selected for this role will be set based on a variety of factors, including but not limited to, internal equity, experience, education, specialty and training. As one of the largest employers in Pasadena, CA, Caltech is committed to providing comprehensive benefits to eligible employees and their eligible dependents. Our benefits package includes competitive compensation, health, dental, and vision insurance, retirement savings plans, generous paid time off (vacation, holidays, sick time, parental leave, bereavement, etc.), tuition reimbursement, and more. Non-benefit eligible employees will have access to some benefits such as onsite counseling and sick time. Learn more about our benefits and staff perks. EEO Statement We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, or national origin, disability status, protected veteran status, or any other characteristic protected by law. Caltech is a VEVRAA Federal Contractor. To read more Equal Employment Opportunity (EEO) go to eeoc_self_print_poster.pdf. Disability Accommodations If you would like to request an accommodation in completing this application, interviewing, or otherwise participating in the employee selection process, please direct your inquiries to Caltech Recruiting at employmentcaltech.edu.</p>

Caltech is a world-renowned science and engineering institute that marshals some of the world's brightest minds and most innovative tools to address fundamental scientific questions. We thrive on finding and cultivating talented people who are passionate about what they do. Join us and be a part of the diverse Caltech community.<br><br><strong>Job Summary</strong><br> <br>The Software Accelerator is a new program that supports the development of software for science and engineering campus-wide, enabling research groups to pursue new scientific and technological advances that would not otherwise be feasible. The Research Software Engineers (RSEs) will primarily develop software but will also assist the Schmidt Academy for Software Engineering (details at https://sase.caltech.edu) in campus-wide training and mentoring entry-level engineers in best-practices in software engineering.<br> <br><strong>Job Duties:</strong><br> <br>As a Senior Research Software Engineer, you will:<br> <ul> <li>Develop software for one or more research projects per year.</li> <li>Enhance and maintain the capabilities of existing software developed either in research groups or within the Academy.</li> <li>Contribute towards short software engineering bootcamps given during the year.</li> <li>Provide technical expertise and guidance in applying the best industry standards for code health, scalability, and robustness.</li> <li>Conceptualize and devise innovative ideas and technical designs for high-profile software projects in diverse science and engineering disciplines.</li> <li>Assist Senior Engineers in providing mentoring of Schmidt Scholars in Software Engineering and SASE graduate student fellows as they work on projects in different research groups.</li> </ul> <br><strong> Basic Qualifications</strong><br> <ul> <li>Bachelor's degree in computer science or a science or engineering field.</li> <li>5 years of professional experience with software engineering.</li> <li>2 years of experience mentoring junior software engineers.</li> <li>Strong programming skills in multiple languages such as Python, C/C, Julia, or JavaScript.</li> <li>Proficiency working with Git version control.</li> <li>Experience with all phases of the software lifecycle, from requirements gathering and design, to operations and maintenance.</li> <li>Strong interpersonal skills.</li> </ul> <br><strong> Preferred Qualifications</strong><br> <ul> <li>Master's degree in computer science or a science or engineering field.</li> <li>Expertise working with high-performance computing systems, GPU programming, machine learning, and/or full-stack.</li> <li>Experience teaching best practices in software engineering.</li> <li>Ability to work with multi-disciplinary teams and to interact cross-functionally with a wide variety of people.</li> </ul> <br><strong> Required Documents</strong><br> <ul> <li>Resume</li> <li>Cover Letter</li> </ul>

Caltech Business Intelligence Interview Guide

Overview

Caltech Business Intelligence Salary

Caltech Business Intelligence Interview Process

Caltech Business Intelligence Interview Questions

Caltech Business Intelligence Jobs