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

Brandeis University Business Intelligence Interview Guide

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


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

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

Overview

Brandeis University 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.

Brandeis University 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

Brandeis University Business Intelligence Interview Questions

Brandeis University – a distinguished top-tier private research university recognized for its academic excellence and leading-edge research – has an exciting opportunity for a talented and motivated Reporting & Data Analyst.
Position Summary:
The Reporting & Data Analyst in the Fundraising Division at Brandeis University Institutional Advancement is responsible for providing advanced data analysis, reporting, and actionable insights to support the university's fundraising goals and strategic initiatives. This role involves working closely with development officers, campaign managers, and other stakeholders to ensure data-driven decision-making and effective fundraising strategies. The ideal candidate will have strong analytical skills, extensive experience with data visualization tools such as Salesforce CRMA and Tableau, and a deep understanding of fundraising metrics and processes.
To apply, please submit your cover letter and resume/CV.
Position Responsibilities:
Data Analysis & Reporting: (25%)    Leverage Salesforce CRMA and/or Tableau to develop and maintain well architected visual solutions to track fundraising performance, donor engagement, and campaign effectiveness.
Create actionable insights that allow fundraising leadership to identify trends, patterns, and opportunities for fundraising improvement in support of the strategic plan.
Develop and maintain reusable dashboard and report templates with accessible UI/UX.

Data Management: (25%)    Ensure the accuracy and integrity of fundraising data by performing regular data audits, identifying gaps in the data and opportunities for improvement.
Collaborate with IT and data management teams to improve data collection, cleansing, storage, and retrieval processes.
Manage the integration of data from various sources, including CRM systems, financial databases, and external data providers.
Ensure that SFDC Local is being populated with the correct objects and fields and monitor the Sync for errors.

Stakeholder Collaboration: (30%)    Work closely with development officers, campaign managers, and other stakeholders to understand their reporting needs and provide customized solutions.
Present findings and insights to senior leadership and fundraising teams in a clear and compelling manner.
Train and support fundraising staff in the use of data analytics tools and best practices.

Process Improvement: (20%)    Identify and implement process improvements to enhance the efficiency and effectiveness of reporting and data analysis activities.
Stay up-to-date with industry trends and best practices in fundraising analytics and data visualization.

Qualifications:
Bachelor’s degree in Data Analytics, Statistics, Information Systems, Business Administration, or a related field. Advanced degree preferred.
3-5 years of experience in data analysis, reporting, or a related role, preferably in a fundraising or non-profit environment.
Proficiency in data visualization tools (e.g., Tableau, Salesforce CRMA), SQL and SAQL, and statistical analysis software (e.g., R, Python).
Proficiency with Salesforce Sales Cloud.
Strong knowledge of fundraising metrics, donor lifecycle management, and campaign performance indicators preferred.
Excellent analytical and problem-solving skills, with the ability to interpret complex data and provide actionable insights.
Strong communication and presentation skills, with the ability to convey technical information to non-technical audiences.
Experience with CRM systems (e.g., Salesforce, Ascend) and database management.
Ability to work independently and as part of a team, managing multiple projects and deadlines effectively.
Preferred Qualifications:
Advanced degree in a related field.
Experience working in a higher education setting.
Knowledge of SQL and other database query languages.
Certification in data analytics or related disciplines.
About Brandeis:
Brandeis is dedicated to first-rate undergraduate education while making groundbreaking scientific discoveries, advancing artistic and creative expression, and tackling some of society’s most pressing economic, human rights, and health policy issues. Brandeis offers a culture of learning and mentorship essential to a 21st-century liberal arts education where close relationships with professors and research opportunities enable students at all levels to collaborate with faculty members and peers across the institution. Established as a nonsectarian university in 1948 by members of the American Jewish community, our visionary founders shared a commitment to social justice and to making the world a better place. Our founders’ pioneering spirit and intellectual pursuits continue today at Brandeis – from helping to solve a national public health crisis through work at its Opioid Policy Research Collaborative, to the biological discoveries that, in 2017, earned two faculty members a Nobel Prize in Physiology or Medicine.
We aspire to further such important endeavors and are looking to grow our team with individuals who share our passion and commitment. In preparation for its next ambitious campaign, the Division of Institutional Advancement (IA) seeks to strengthen the bonds with the university’s many constituencies. By working together, we will secure the financial resources necessary to continue the legacy of excellence in teaching, research, and scholarship at Brandeis.
Located nine miles west of downtown Boston, a global hub for higher education and innovation, Brandeis University is accessible via major highways (I-90 and I-95) and the MBTA Brandeis/Roberts commuter rail stop.

#J-18808-Ljbffr

<p>The position requires extensive experience with conducting an independent research project comprising of: data collection, data analysis, experimental design, reviewing papers, working with Drosophila, molecular biology techniques, applications in ge Research Scientist, Research, Scientist, Diversity, Technology, Education</p>

Brandeis University Business Intelligence Interview Guide

Overview

Brandeis University Business Intelligence Salary

Brandeis University Business Intelligence Interview Process

Brandeis University Business Intelligence Interview Questions

Brandeis University Business Intelligence Jobs