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

Lehigh University Business Intelligence Interview Guide

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


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

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

Overview

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

Lehigh 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 show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).</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>products</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>price</code></td>
<td>FLOAT</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>

<tr>
<td><code>sex</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>month</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_customers</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_orders</code></td>
<td>INTEGER</td>
</tr>

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


Monthly Customer Report

<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

Lehigh University Business Intelligence Interview Questions

<strong>Institutional Research Analyst</strong><br><br><b>Job no:</b> 503076<br> <b>Work type:</b> Exempt Staff Full-time<br> <b>Location:</b> Partial Remote, Bethlehem<br> <b>Categories:</b> Information Technology<br><br>Are you a data enthusiast with a passion for higher education? Join Lehigh University, a leading research institution renowned for its academic excellence and vibrant campus community, as an Institutional Research Analyst (Position Number S88910).<br><br>In this pivotal role, you will be at the forefront of data-driven decision-making, playing a crucial part in shaping the university's strategic direction. As an Institutional Research Analyst, you will collect, analyze, and interpret a vast array of institutional data, providing invaluable insights into areas such as student enrollment, retention, graduation rates, faculty productivity, and key performance indicators.<br><br>Key Responsibilities:<br>•Gather, analyze, and interpret complex data from various university systems and external sources<br>•Develop and maintain comprehensive databases and data warehouses<br>•Conduct quantitative analyses and produce reports, dashboards, and data visualizations<br>•Collaborate with stakeholders to identify data needs and provide actionable insights<br>•Ensure data integrity, accuracy, and compliance with relevant policies and regulations<br>•Participate in strategic planning and decision-making processes<br><br>Qualifications:<br>•Bachelor's Degree or the equivalent combination of education and experience; Master's Degree preferred<br>•One to three years of related work experience<br>•Proficiency in data analysis tools (e.g., SQL, Python, R, Tableau, Power BI)<br>•Strong analytical and problem-solving skills<br>•Excellent written and verbal communication abilities<br>•Attention to detail and commitment to data quality<br>•Ability to work independently and as part of a team<br><br>At Lehigh University, you'll be part of a dynamic and inclusive community that values diversity, fosters innovation, and promotes personal and professional growth. We offer a competitive compensation package, comprehensive benefits, and a wealth of opportunities for career advancement and lifelong learning.<br><br>This position is a Grade: 9 - 40, offering an approximate salary of $54,390-$66,190. The duties of this position may allow the employee to work partially remote as deemed appropriate by their supervisor.<br><br>Persons with disabilities who anticipate needing an accommodation for any part of the interview or hiring process may contact Lehigh's Accommodations Specialist <br><br>Lehigh University is an equal opportunity employer and is committed to building a diverse and inclusive environment for all. We actively encourage applications from individuals of diverse backgrounds and experiences. The Lehigh community takes seriously our commitment to antiracism and The Principles of our Equitable Community.<br><br>Successful completion of standard background checks including but not limited to: social security verification, education verification, national criminal background checks, motor vehicle checks, PATCH, FBI fingerprinting, Child Abuse Clearance and credit history based upon the requirements of the position<br><br><strong>Only complete applications will be considered therefore please complete the application in its entirety. Once the posting is removed from the website applications may no longer be allowed to be completed.</strong><br><br><b>Advertised:</b> September 09, 2024 Eastern Daylight Time<br> <b>Applications close:</b>

<strong>Financial Reporting Analyst</strong><br><br><b>Job no:</b> 503127<br> <b>Work type:</b> Exempt Staff Full-time<br> <b>Location:</b> Partial Remote, Bethlehem<br> <b>Categories:</b> Finance/Accounting<br><br>Unleash Your Financial Prowess at Lehigh University<br><br>Are you a financial mastermind with an unquenchable thirst for excellence? Lehigh University invites you to join our esteemed team as a Financial Analyst (Position Number S86520) in the Controller department. Prepare to embark on a rewarding journey where your expertise will shape the financial landscape of our prestigious institution.<br><br>In this pivotal role, you will coordinate, improve, develop, analyze, and implement complex financial accounting methods that drive our financial planning, reporting, and control strategies. Your analytical acumen and keen attention to detail will propel us towards new heights of financial success.<br><br>Key Responsibilities:<br>•Prepare and reconcile the University's audited financial statements, including the statements of financial position, statement of activities, statement of cash flows and footnotes.<br>•Prepare various monthly reconciliations to ensure accurate financial reporting.<br>•Prepare monthly/quarterly/annual financial report journal entries and other journal entries as assigned.<br>•Prepare Athletics EADA/NCAA Report of Revenue and Expenditures and footnote(s).<br>•Prepare surveys for various external agencies.<br>•Identify and implement opportunities to improve processes, accuracy, and controls.<br>•Collaborate with supervisor to identify needs and priorities of office and to offer ideas on how to automate reporting processes.<br>•Participate in cross-training.<br>•Complete various additional tasks as assigned by manager.<br><br>Qualifications:<br>•Bachelor's degree in Accounting or the equivalent combination of education and experience<br>•Three to five years of related work experience<br>•Exceptional analytical and problem-solving skills with a data-driven mindset.<br>•Proficiency in financial modeling, forecasting, and data analysis tools (e.g., Excel).<br>•Strong communication and interpersonal abilities to effectively collaborate with cross-functional teams.<br>•Proven ability to manage multiple priorities and work under tight deadlines in a fast-paced environment.<br><br>At Lehigh University, we pride ourselves on fostering a dynamic and inclusive environment that empowers our employees to thrive. As a member of our family, you'll be part of a collaborative community that values innovation, diversity, and professional growth. We offer competitive compensation packages, comprehensive benefits, and ample opportunities for personal and professional development.<br><br>But that's not all - Lehigh University is committed to creating a work-life balance that nurtures your well-being. Our idyllic campus nestled in the scenic Lehigh Valley provides a serene setting for your professional and personal pursuits. From state-of-the-art facilities to vibrant cultural experiences, you'll find yourself immersed in an environment that enriches your life in countless ways. The Lehigh community takes seriously our commitment to antiracism and The Principles of our Equitable Community.<br><br>If you're ready to embark on a transformative journey and leave an indelible mark on our institution's financial landscape, we invite you to apply for the Financial Analyst position. Join us in shaping the future of Lehigh University and elevating our financial excellence to unprecedented heights.<br><br>This position is a Grade: 9 - 40, offering an approximate salary of $54,390-$66,190. The duties of this position may allow the employee to work partially remote as deemed appropriate by their supervisor. This position has fiscal or financial responsibilities other than employee expense activity, such as processing or approving transactions; monitoring or preparing budgets; or generating income for University. Some overtime may be required during busy periods such as fiscal year-end. Persons with disabilities who anticipate needing an accommodation for any part of the interview or hiring process may contact Lehigh's Accommodations Specialist. <br><br>To be considered for this exceptional opportunity, please submit your resume and cover letter highlighting your relevant qualifications and experience. We look forward to welcoming you to our esteemed team and witnessing the profound impact you'll have on our financial operations.<br><br>Successful completion of standard background checks including but not limited to: social security verification, education verification, national criminal background checks, motor vehicle checks, PATCH, FBI fingerprinting, Child Abuse Clearance and credit history based upon the requirements of the position.<br><br><strong>Only complete applications will be considered therefore please complete the application in its entirety. Once the posting is removed from the website applications may no longer be allowed to be completed.</strong><br><br><b>Advertised:</b> October 11, 2024 Eastern Daylight Time<br> <b>Applications close:</b>

Lehigh University Business Intelligence Interview Guide

Overview

Lehigh University Business Intelligence Salary

Lehigh University Business Intelligence Interview Process

Lehigh University Business Intelligence Interview Questions

Lehigh University Business Intelligence Jobs