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

Cornell University Business Intelligence Interview Guide

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


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

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

Overview

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

Cornell 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>What are the logistic and softmax functions? What is the difference between the two?</p>

<p>What makes them useful for use in logistic regression?</p>


<p>In logistic regression, how is the predicted class determined based on the logistic function?</p>


In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

<p>What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?</p>


What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

<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

Cornell University Business Intelligence Interview Questions

Lead Data Engineer

Prog Analyst Spec

Research Administration Information Services (RAIS)

Cornell University is one of the leading research universities in the world. Established in 1865 as an "institution where any person can find instruction in any study", we pride ourselves on the diversity of our student body, our faculty and staff, and our academic disciplines. The Research & Innovation organization at Cornell plays an important role in making our diverse and groundbreaking research programs come to life. We help our world class research community to find funding, navigate complex regulations, and bring new inventions to the market. Our Information Services team makes this possible by providing research management systems that are easy for the research community to use based on excellent user-experience research and design. They also build the data infrastructure necessary to bring together all of the data needed for reporting on the success of our research efforts.

Cornell University embraces diversity and seeks candidates who will contribute to a climate that supports students, faculty and staff of all identities and backgrounds. We strongly encourage individuals from underrepresented and/or marginalized identities to apply.

The Information Services team is looking for talented and creative individuals to join us in our quest to make it easier for the Cornell research community to manage their research. We consider our environment to be its own research laboratory where team members are encouraged to voice new ideas and try new approaches. We're early adopters in the use of new technologies that can help us to automate development and deployment of the application and data products we build or integrate with. There's no doubt that you'll be able to learn and grow as part of our team. We have opportunities for advancement in our group and within the university. The ability to take classes or pursue a degree through our employee degree program is also available and encouraged. Cornell benefits are hard to beat, including a contribution of 10% of your salary to your retirement plan pre-tax.

The Lead Data Engineer position is a senior member of the Information Services team, responsible for all of our technical decisions, including our technology stack and data architecture. The position reports to the Director of Information services and provides day-to-day technical leadership for the data team.

What You Will Do:
Design and maintain our data infrastructure that gets data to and from the data products we create and the applications and data sources we integrate with
Use tools like Tableau or write code to create data visualizations, dashboards, and applications
Review our tool chain to make sure we're using the best apps and practices
Help lead our data team; implement procedures and work instructions; break down tasks
Work on data projects with project and product management teams - help understand what's possible and figure out the best way to deliver; assist with data analysis and discovery
Prioritize the development backlog with the product team - tell them when you need time to refactor or prioritize "technical debt" items that pose a risk
Infrastructure design, automation, and maintenance in cloud and on-premises hosting environments
Troubleshoot potential data issues reported with production reporting systems and integrations
What You Will Need:     5 or more years working in a data analyst, data engineer, or other data science role
Proven experience in designing and delivering end-to-end data products, including data discovery, cleaning, and integration. Expertise in pipeline creation and automation using various ETL tools, APIs, and hands-on knowledge of front-end data visualization and delivery frameworks
Bachelor's degree or higher
Advanced knowledge of SQL and relational database systems and design
Thorough understanding of popular data warehouse data structures (e.g., star, snowflake)
Thorough understanding of non-traditional/NoSQL data formats and how to work with them (json, xml, csv)
Experience with Tableau
Experience with Python data science ecosystem (Pandas, Jupyter Notebooks, etc.)
Experience with DevOps
Ability to use tools to introspect data sources to understand cardinality, relationships, data quality or potential issues
Meticulous attention to detail and documentation habits
Excellent communication and organization skills
Good team player with an ability to work in a cross-functional team environment
What We Prefer:     Bachelor's degree or higher with a concentration in a quantitative field such as finance, quantitative marketing, engineering, mathematics/statistics
Understanding of finance and accounting concepts and data
What we offer:     The opportunity to work with a dynamic group of people in a stable organization where employee development is promoted.
A broad set of competitive benefits under the Cornell Endowed program, including educational opportunities, access to virtual wellness programs, health care options, 3 weeks of paid vacation, 13 paid holidays, and superior retirement contributions. https://hr.cornell.edu/benefits-pay
The potential to work in Ithaca (with affordable housing and highly ranked public schools) or remotely from a location of your choice within the United States.
The New York Convenience of employer guidelines require New York State individual tax reporting and withholdings for this position. Additional individual state income tax filings may also be required if working temporarily outside New York State.

For full consideration, please attach a cover letter and resume with your application.

Visa sponsorship not available for this position.

Familiarize yourself with Cornell's COVID-19 workplace guidance as well as the university's COVID-19 services and information.

University Job Title:
Prog Analyst Spec
Job Family:
Information Technology
Level:
G
Pay Rate Type:
Salary
Pay Range:
$108,296.00 - $132,362.00
Remote Option Availability:
Hybrid
Company:
Endowed
Contact Name:
Kristie Devine

Job Titles and Pay Ranges:

Non-Union Positions

Noted pay ranges reflect the potential pay opportunity for each job profile. The hiring rate of pay for the successful candidate will be determined considering the following criteria:    Prior relevant work or industry experience
Education level to the extent education is relevant to the position
Unique applicable skills
Academic Discipline

To learn more about Cornell's non-union staff job titles and pay ranges, see Career Navigator.

Union Positions

The hiring rate of pay for the successful candidate will be determined in accordance with the rates in the respective collective bargaining agreement. To learn more about Cornell's union wages, see Union Pay Rates.

Current Employees:

If you currently work at Cornell University, please exit this website and log in to Workday using your Net ID and password. Select the Career icon on your  Home  dashboard to view jobs at Cornell.

Online Submission Guidelines :

Most positions at Cornell will require you to apply online and submit both a resume/CV and cover letter. You can upload documents either by "dragging and dropping" them into the dropbox or by using the "upload" icon on the application page. For more detailed instructions on how to apply to a job at Cornell, visit How We Hire on the HR website.

Employment Assistance:

For general questions about the position or the application process, please contact the Recruiter listed in the job posting or email mycareer@cornell.edu.

If you require an accommodation for a disability in order to complete an employment application or to participate in the recruiting process, you are encouraged to contact Cornell University's Office of Institutional Equity and Title IX at voice (607) 255-2242, or email at equity@cornell.edu.

Applicants that do not have internet access are encouraged to visit your local library, or local Department of Labor. You may also request an appointment to use a dedicated workstation in the Office of Talent Attraction and Recruitment, at the Ithaca campus, by emailing mycareer@cornell.edu.

Notice to Applicants:

Please read the required Notice to Applicants statement by  clicking here . This notice contains important information about applying for a position at Cornell as well as some of your rights and responsibilities as an applicant.

EEO Statement:

Diversity and Inclusion are a part of Cornell University's heritage. We are a recognized employer and educator valuing AA/EEO, and we do not tolerate discrimination based on any protected characteristic, including race, ethnic or national origin, citizenship and immigration status, color, sex/gender, pregnancy or pregnancy-related conditions, age, creed, religion, actual or perceived disability (including persons associated with such a person), arrest and/or conviction record, military or veteran status, sexual orientation, gender expression and/or identity, an individual's genetic information, domestic violence victim status, familial status, marital status, or any other characteristic protected by applicable federal, state, or local law. We also recognize a lawful preference in employment practices for Native Americans living on or near Indian reservations in accordance with applicable law.

Cornell University embraces diversity and seeks candidates who will contribute to a climate that supports students, faculty, and staff to all identities and backgrounds. We encourage individuals from underrepresented and/or marginalized identities to apply.
2024-12-11

Cornell University Business Intelligence Interview Guide

Overview

Cornell University Business Intelligence Salary

Cornell University Business Intelligence Interview Process

Cornell University Business Intelligence Interview Questions

Cornell University Business Intelligence Jobs