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

City Year Business Intelligence Interview Guide

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


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

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

Overview

City Year 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.

City Year 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

City Year Business Intelligence Interview Questions

<b>Application Instructions</b> <br><br>Click Apply to submit your online application. Please attach a resume and thoughtful cover letter on the "My Experience" page in the "Resume/CV" field. <br><br>Active City Year Staff members must login to Workday to apply internally. <br><br>Number of Positions: 1 <br><br>Work Location: 100% On-Site <br><br><b>Position Overview</b> <br>City Year Tulsa is seeking a Data Analyst with experience and/or interest in social impact innovation to join our team, reporting to the Senior Director of Data Strategy and Analytics. The Data Analyst will be collaborative and a critical thinker who enjoys solving complex problems. The Data Analyst collaborates across multiple teams to manage the organization's data stack and tools, analyze complex data sets, identify trends and evidence for informed decision-making, visualize and share insights with site leadership and peers. The Data Analyst will contribute to a data culture that supports powerful service delivery, empowers program teams, and drives positive student, school, and community outcomes. The ideal candidate is looking to grow their skillsets in data engineering, machine learning and predictive analytics, strategy, and demonstrates a desire to grow their leadership abilities. The ideal candidate will excel in a dynamic and collaborative environment. <br><br>About Us <br> <br>City Year is an education-focused, nonprofit organization founded in 1988 that partners with public schools and teachers to help keep students in school and on track to succeed. In 29 communities across the United States and through two international affiliates, this innovative public-private partnership is challenging the educational status quo with tenacity, passion and empathy. We help create environments where young people feel like they belong, so they can fulfill their potential. <br><br>City Year is recognized by Charity Navigator, America's premier charity evaluator, as a four-star rated organization for each of the last eight years, placing it among the top 1% of all organizations rated. City Year is also a five-time winner of Fast Company Social Capitalist Award and has been recognized in leading business and management books including Built to Last and Forces for Good: The Six Practices of High-Impact Nonprofits. <br><br><b>Job Description</b> <br><br><b>Responsibilities</b> <br> <br><ul> <li>Develop and maintain data warehouse and other key data sources, build scripts and models that build a flexible, scalable, and robust data evaluation process </li></ul><ul><li>Create and maintain appropriate data structures that support efficient and sustainable reporting and insight generation; ensure rigor, accuracy, and consistency of data processing, documentation, reporting </li></ul><ul><li>Work closely with internal data team members and partners to understand and maintain focus on the organization's analytical needs, including identifying relevant questions, metrics, and insights </li></ul><ul><li>Proactively explore and analyze data using a variety of tools and methods to answer key questions related to program performance and opportunities </li></ul><ul><li>Prepare differentiated analyses and visualizations to engage multiple audiences, communicate compelling results and outcomes that are accessible and understandable </li></ul><ul><li>Support program data operations by developing self-serve data tools and dashboards </li></ul><ul><li>Other tasks as required, including participation in full-site events and service projects. </li></ul><b>Knowledge, Experience, Skill Requirements</b> <ul> <li>Strong working knowledge of effective and efficient data structures, data pipelines, and cloud-based data warehouses such as Google BigQuery </li></ul><ul><li>Prior experience with data management, data analysis, and modeling </li></ul><ul><li>Practical experience in statistical analysis using tools such as R, SPSS, SAS </li></ul><ul><li>Proficiency in statistical programming languages SQL, R, Python </li></ul><ul><li>Working knowledge of visualization tools such as PowerBI or Tableau </li></ul><ul><li>Ability to identify opportunities for data collection and analysis in alignment with organization's priorities </li></ul><ul><li>Ability to understand and communicate complex (sometimes technical) concepts with simplicity; ability to navigate through layers of ambiguity, think abstractly, and solve complex problems </li></ul><ul><li>Demonstrated ability to work well in a collaborative teams and dynamic environment; ability to take initiative, define and manage multiple projects/workstreams in collaboration with stakeholders </li></ul><ul><li>Ability to self-direct, take initiative, work and learn independently, while also enthusiastically partnering with cross-disciplinary teams </li></ul><ul><li>Minimum 2-4 years of related experience or an equivalent combination of training and experience </li></ul><ul><li>Bachelor's degree in quantitative sciences such as economics, statistics, computer science, public health or related fields such as urban studies, sociology, public policy preferred </li></ul> <br><br><b>Benefits</b> <br><br>Full time employees will be eligible for all benefits including vacation and sick days and organization holidays. You may participate in all benefit programs that City Year establishes and makes available to eligible employees, under (and subject to all provisions of) the plan documents that govern those programs. Currently, City Year offers medical, dental and vision, life, accidental death and dismemberment and disability coverage, Flexible Spending Accounts (FSA), other benefits including 401(k) plan(s) pursuant to the terms and conditions of company policy and the 401(k) plan document. For more information, click here. <br> <br>Employment at City Year is at-will. <br> <br>City Year does not sponsor work authorization visas.

City Year Business Intelligence Interview Guide

Overview

City Year Business Intelligence Salary

City Year Business Intelligence Interview Process

City Year Business Intelligence Interview Questions

City Year Business Intelligence Jobs