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

Indeed Business Intelligence Interview Guide

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


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

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

Overview

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

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

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

Indeed Business Intelligence Interview Questions

<p>Our Mission <br><br>Scroll down for a complete overview of what this job will require Are you the right candidate for this opportunity <br><br>As the world’s number 1 job site*, our mission is to help people get jobs. We strive to cultivate an inclusive and accessible workplace where all people feel comfortable being themselves. We're looking to grow our teams with more people who share our enthusiasm for innovation and creating the best experience for job seekers. <br><br>(*comScore Total Visits, September 2023) <br><br>Day to Day <br><br>The Hired Signal team’s mission is to help people get jobs by collecting, innovating with, and promoting the use of hire and hire-related outcome data. We leverage Indeed’s data and advanced Machine Learning (ML) techniques to innovate in this area and push the boundaries of data pipelines and Artificial Intelligence (AI) at Indeed. Our data pipelines examine billions of data points daily, power research, product, and strategic recommendations to support the Indeed mission. On a daily basis you would work on developing scalable and efficient software solutions to aid data preprocessing, model training, and deployment, integrating Machine Learning models into production systems while guiding the team on the same. Collaboration with cross-functional teams fosters effective communication with data scientists. <br><br>Responsibilities <br><br>Define, design, and build systems/technologies to optimize hiring data collection, analysis, and innovation.
Assume a pivotal role on the team, possessing comprehensive knowledge of not only our own products but also the interactions between our products and other teams’ products and services
Architect new solutions and validate new ideas by either building on top of existing solutions or by prototyping new products
Participate in code and design reviews across multiple teams to maintain high-quality standards
Assess performance and enhance current code to utilize hardware resources efficiently.
Mentor and grow other software engineers, data scientists, and ML engineers across teams
Communicate concisely and persuasively with product managers, data scientists, and other engineers in a cross-functional team <br><br>Skills/Competencies <br><br>Bachelors in Computer Science, Mathematics, or related fields
7+ years of experience as a Software Engineer, addressing intricate issues of scale
Solid sense of ownership and accountability as a key contributor in technical and product domains
Full stack experience, emphasis on building data and machine learning pipelines, and in building or working on large scale systems, including familiarity with Dagster/Airflow, Python, Spark (Scala), AWS Sagemaker, React
Solid knowledge of data structures, algorithms, data engineering, machine learning, and Computer Fundamentals <br><br>Education Requirement: Bachelors in Computer Science, Mathematics, or related fields <br><br>Salary Range Transparency <br><br>US Remote - $143,000 - 207,000 USD <br><br>Austin Metro Area - $143,000 - 207,000 USD <br><br>New York City Metro Area - $184,000 - 266,000 USD <br><br>Seattle Metro Area - $184,000 - 266,000 USD <br><br>San Francisco Metro Area - $196,000 - 284,000 USD <br><br>Salary Range Disclaimer <br><br>The base salary range represents the low and high end of the Indeed salary range for this position in the given work location. Actual salaries will vary depending on factors including but not limited to location, experience, and performance. The range(s) listed is just one component of Indeed's total compensation package for employees. Other rewards may include quarterly bonuses, Restricted Stock Units (RSUs), a Paid Time Off policy, and many region-specific benefits. <br><br>Benefits - Health, Work/Life Harmony, & Wellbeing <br><br>We care about what you care about. We have a multitude of benefits to support Indeedians, as well as their pets, kids, and partners including medical, dental, vision, disability and life insurance. Indeedians are able to enroll in our company’s 401k plan, as well as an equity-based incentive program. Indeedians will also receive open paid time off, 12 paid holidays a year and up to 26 weeks of paid parental leave. For more information, select your country and learn more about our employee benefits, program, & perks at https://benefits.indeed.jobs! <br><br>Equal Opportunities and Accommodations Statement <br><br>Indeed is deeply committed to building a workplace and global community where inclusion is not only valued, but prioritized. We’re proud to be an Equal Employment and Affirmative Action employer seeking to create a welcoming and diverse environment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity or expression, family status, marital status, sexual orientation, religious creed, national origin, genetics, neuro-diversity, disability, age, status as a protected veteran, or any other non-merit based or legally protected grounds. <br><br>Indeed is dedicated to providing reasonable accommodations to qualified individuals with known disabilities to participate in the employment application process. To request an accommodation, an applicant should contact Talent Attraction Accommodations at 1-855-567-7767, or by email at accommodations@indeed.com. In the request for an accommodation, please inform us of the nature of your request and your contact information. If you are requesting accommodation for an interview, please reach out at least one week in advance of your interview. <br><br>For more information about our commitment to Equal Employment Opportunity and Affirmative Action, please review our Equal Employment Opportunity and Affirmative Action Statement of Policy (https://drive.google.com/file/d/1vnn08de0zsnII-4yvsTIR9VWKj8dePpN/view). <br><br>Inclusion & Belonging <br><br>Inclusion and belonging are fundamental to our hiring practices and company culture, forming an integral part of our vision for a better world of work. At Indeed, we’re committed to the wellbeing of our employees and on a mission to make this the best place to work and thrive. We believe that fostering a diverse and inclusive environment where every employee feels respected and accepted benefits everyone, fueling innovation and creativity. <br><br>We value diverse experiences, including those who have had prior contact with the criminal legal system. We are committed to providing individuals with criminal records, including formerly incarcerated individuals, a fair chance at employment. <br><br>Those with military experience are encouraged to apply. Equivalent expertise demonstrated through a combination of work experience, training, military experience, or education is welcome. <br><br>Indeed’s Employee Recruiting Privacy Policy <br><br>Like other employers Indeed uses our own technologies to help us find and attract top talent from around the world. In addition to our site’s user and privacy policy found at https://www.indeed.com/legal, we also want to make you aware of our recruitment specific privacy policy found at https://www.indeed.com/legal/indeed-jobs. <br><br>Agency Disclaimer <br><br>Indeed does not pay placement fees for unsolicited resumes or referrals from non-candidates, including search firms, staffing agencies, professional recruiters, fee-based referral services, and recruiting agencies (each individually, an "Agency"), subject to local laws. An Agency seeking a placement fee must obtain advance written approval from Indeed's internal Talent Acquisition team and execute a fee agreement with Indeed for each job opening before making a referral or submitting a resume for that opening. <br><br>The deadline to apply to this position is 9/30/24. Job postings may be extended at the hiring team’s discretion based on applicant volume. <br><br>#INDSWE <br><br>Reference ID: 44487 <br><br>Reference ID: 44487 <br><br>Job Type: Full-time <br><br>Pay: $143,000.00 - $207,000.00 per year <br><br>Benefits:
* 401(k)
* 401(k) matching
* Dental insurance
* Flexible schedule
* Flexible spending account
* Health insurance
* Health savings account
* Life insurance
* Paid time off
* Parental leave
* Professional development assistance
* Tuition reimbursement
* Vision insurance
Schedule:
* Monday to Friday <br><br>People with a criminal record are encouraged to apply <br><br>Work Location: Remote
Remote working/work at home options are available for this role.</p>

Indeed Business Intelligence Interview Guide

Overview

Indeed Business Intelligence Salary

Indeed Business Intelligence Interview Process

Indeed Business Intelligence Interview Questions

Indeed Business Intelligence Jobs