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

Lucid Motors Business Intelligence Interview Guide

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


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

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

Overview

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

Lucid Motors 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

Lucid Motors Business Intelligence Interview Questions

<p>Leading the future in luxury electric and mobility</p><p>At Lucid, we set out to introduce the most captivating, luxury electric vehicles that elevate the human experience and transcend the perceived limitations of space, performance, and intelligence. Vehicles that are intuitive, liberating, and designed for the future of mobility.</p><p>We plan to lead in this new era of luxury electric by returning to the fundamentals of great design - where every decision we make is in service of the individual and environment. Because when you are no longer bound by convention, you are free to define your own experience.</p><p>Come work alongside some of the most accomplished minds in the industry. Beyond providing competitive salaries, we're providing a community for innovators who want to make an immediate and significant impact. If you are driven to create a better, more sustainable future, then this is the right place for you.</p><p>As the manager of a team, you will be responsible for technical engineering and people management for displays, mechanisms and switches for the Air and Gravity programs at Lucid. You will report to the interior engineering management team and work along side engineering, procurement, quality etc. to successfully develop, track and launch various interior parts and assemblies. You will be developing overall part and design strategies with engineers to carry out effective cost, design and build requirements.</p><p>The Interior Electronics and Mechanisms group is responsible for parts such as: Displays, Display Assemblies, Electromechanical Mechanisms, Air Vents, switches, and Overhead Console.</p><p>Role</p><p>* Support engineering development of parts in mechanical, electrical and kinematic mechanisms</p><p>* Review and lead detailed Gantt charts of multiple design projects</p><p>* Support growth of the engineering team through implemented processes, controls and education</p><p>* Utilize Jira to communicate engineering tasks and progress</p><p>* Utilize various communication pages and documentation to publish critical information</p><p>* Provide regular progress updates to management and the executive staff</p><p>* Support cost breakdown review of parts and work cross functionally to establish should costs, and targets, and help connect teams and suppliers</p><p>* Provide technical guidance to solve engineering challenges with electronics and mechanical systems</p><p>Qualifications</p><p>* 6+ years of work experience in automotive or consumer electronics</p><p>* 2+ years of leadership experience in automotive or consumer electronics</p><p>* Strong engineering fundamentals in thermal, mechanical, fixation, electronics, kinematic, testing and/or fluid principles</p><p>* Experience in program management in technical fields such as automotive or consumer electronics</p><p>* Exceptional understanding of manufacturing and assembly technologies and process such as injection molding (variety of types) die casting and thixomolding, surface mount technologies, plastic welding, etc..</p><p>* Experience working with electromechanical assemblies and displays</p><p>* Experience with Atlassian Jira, and Confluence</p><p>* Proven CAD experience and understanding; CATIA preferred</p><p>Advantageous</p><p>* Flexibility to work in a fast-paced startup environment</p><p>* Experience in display panel suppliers, manufacturing process and process flow for LCD and OLED</p><p>* Experience designing switches, display assemblies or kinematic mechanisms</p><p>* Experience leading design release and change requests</p><p>* Experience with concept to launch, vehicle development and product launch or consumer product launch</p><p>* Exceptional communication in written and verbal English</p><p>* Exceptional organizational skills and interpersonal skills</p><p>* Ability to develop strategic planning related to project timing, cost and technical requirements</p><p>* Knowledge in cross function development electronics components</p><p>* Capability to communicate effectively in Korean, Chinese and or Japanese</p><p>* A positive attitude with a drive to learn and contribute meaningfully</p><p>Education</p><p>* Bachelor's Degree in Engineering or similar.</p><p>Salary Range: The compensation range for this position is specific to the locations listed below and is the range Lucid reasonably and in good faith expects to pay for the position taking into account the wide variety of factors that are considered in making compensation decisions, including job-related knowledge; skillset; experience, education and training; certifications; and other relevant business and organizational factors.</p><p>Additional Compensation and Benefits: Lucid offers a wide range of competitive benefits, including medical, dental, vision, life insurance, disability insurance, vacation, and 401k. The successful candidate may also be eligible to participate in Lucid's equity program and/or a discretionary annual incentive program, subject to the rules governing such programs. (Cash or equity incentive awards, if any, will depend on various factors, including, without limitation, individual and company performance.)</p><p>Base Pay Range (Annual)</p><p>$156,600-$229,680 USD</p><p>By Submitting your application, you understand and agree that your personal data will be processed in accordance with our Candidate Privacy Notice. If you are a California resident, please refer to our California Candidate Privacy Notice.</p><p>To all recruitment agencies: Lucid Motors does not accept agency resumes. Please do not forward resumes to our careers alias or other Lucid Motors employees. Lucid Motors is not responsible for any fees related to unsolicited resumes.</p>

Lucid Motors Business Intelligence Interview Guide

Overview

Lucid Motors Business Intelligence Salary

Lucid Motors Business Intelligence Interview Process

Lucid Motors Business Intelligence Interview Questions

Lucid Motors Business Intelligence Jobs