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

Georgetown University Business Intelligence Interview Guide

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


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

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

Overview

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

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

Georgetown University Business Intelligence Interview Questions

Located in a historic neighborhood in the nation's capital, Georgetown offers rigorous academic programs, a global perspective, exciting ways to take advantage of Washington, D.C., and a commitment to social justice. Our community is a tight knit group of remarkable individuals interested in intellectual inquiry and making a difference in the world.<br><br><b>Requirements</b><br><br>The primary role of the <b>MDI Data Scientist </b>will be to support research at the McCourt School of Public Policy and the School of Health related to Medicaid.<br><br>MDI is seeking a highly-skilled, professional in Data Science to join our dynamic and growing team. This position will be part of the technical team of Health Service researches and Data Analysts. The Team is seeking to add a Data Scientist to expand our technical and analytical capability supporting research with large claims datasets. Duties include, but are not strictly limited to the following:<br><ul><li>Collaborate with research team members in designing and implementing studies, analyzing data, and publishing results from research projects.</li><li>Develop and manage database structuring and data management strategies as required for efficiency and compliance.</li><li>Assume primary responsibility for writing statistical design, methods, and analysis for research assignments.</li><li>Develop machine learning models to compliment the statistical design.</li><li>Assume primary responsibility for documentation and archiving of dataset</li><li>Contribute to writing statistical methods and results sections of reports and publications.</li><li>Support publication of research products as well as related projects online on the web and/or other channels.</li></ul><br><br><b>Work Interactions</b><br><br>The new hire will report to Maria Alva, Assistant Professor in the School of Health.<br><br><b>Requirements and Qualifications</b><br><ul><li>Bachelor's degree in biostatistics, statistics, data science, econometrics or similar quantitative methods field</li><li>Minimum 3 years of experience in data analysis using statistical packages, STATA, Excel</li><li>Experience with Python, R, SQL and other programming languages - for example, Java</li><li>Experience designing and implement relational databases - for example, Postgres or a similar database management system</li><li>Experience with or willingness to learn Tableau</li><li>Experience in research protocols, quality assurance, and data privacy practices</li><li>Proven analytical and problem-solving skills</li><li>Ability to communicate with non-technical staff and all members of the project team</li><li>Ability to work both independently and in the team</li></ul><br><br><b>Work Mode Designation</b><br><br>This position has been designated as <b>Hybrid 3 day</b>. Please note that work mode designations are regularly reviewed in order to meet the evolving needs of the University. Such review may necessitate a change to a position's mode of work designation. Complete details about Georgetown University's mode of work designations for staff positions can be found on the Department of Human Resources website: https://hr.georgetown.edu/mode-of-work-designation.<br><br><b>Pay Range: </b><br><br>The projected salary or hourly pay range for this position which represents the full range of anticipated compensation is:<br>$54,616.00 - $100,493.33<br><br>Compensation is determined by a number of factors including, but not limited to, the candidate's individual qualifications, experience, education, skills, and certifications, as well as the University's business needs and external factors.<br><br><b>Current Georgetown Employees:</b><br><br>If you currently work at Georgetown University, please exit this website and login to GMS (gms.georgetown.edu) using your Net ID and password. Then select the Career worklet on your GMS Home dashboard to view Jobs at Georgetown.<br><br><b>Submission Guidelines:</b><br><br>Please note that in order to be considered an applicant for any position at Georgetown University you must submit a resume for each position of interest for which you believe you are qualified. Documents are not kept on file for future positions.<br><br><b>Need Assistance:</b><br><br>If you are a qualified individual with a disability and need a reasonable accommodation for any part of the application and hiring process, please click here for more information, or contact the Office of Institutional Diversity, Equity, and Affirmative Action (IDEAA) at 202-687-4798 or ideaa@georgetown.edu.<br><br>Need some assistance with the application process? Please call 202-687-2500. For more information about the suite of benefits, professional development and community involvement opportunities that make up Georgetown's commitment to its employees, please visit the Georgetown Works website.<br><br>EEO Statement:<br><br>Georgetown University is an Equal Opportunity/Affirmative Action Employer fully dedicated to achieving a diverse faculty and staff. All qualified applicants are encouraged to apply and will receive consideration for employment without regard to race, color, religion, national origin, age, sex (including pregnancy, gender identity and expression, and sexual orientation), disability status, protected veteran status, or any other characteristic protected by law.<br><br>Benefits:<br><br>Georgetown University offers a comprehensive and competitive benefit package that includes medical, dental, vision, disability and life insurance, retirement savings, tuition assistance, work-life balance benefits, employee discounts and an array of voluntary insurance options. You can learn more about benefits and eligibility on the Department of Human Resources website.

Georgetown University Business Intelligence Interview Guide

Overview

Georgetown University Business Intelligence Salary

Georgetown University Business Intelligence Interview Process

Georgetown University Business Intelligence Interview Questions

Georgetown University Business Intelligence Jobs