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

City Of Austin Business Intelligence Interview Guide

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


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

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

Overview

City Of Austin 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 Of Austin 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 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

<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

City Of Austin Business Intelligence Interview Questions

Minimum Qualifications <br><strong>Education and/or Equivalent Experience:</strong><ul> <li>Graduation with a Bachelor's degree from an accredited college or university with major coursework in Business Administration, Public Administration, Social Sciences or related field, to include six (6) semester hours involving or related to statistics and one (1) year of experience in a research field.</li></ul>Or<ul><li>Master's Degree in Business Administration, Public Administration, Social Sciences or related field.</li></ul><strong>Licenses and Certifications Required:</strong><ul><li>None</li></ul> Notes to Applicants <br>The Research Analyst position serves as technical support for Austin 3-1-1's CRM system. The main focus for this position will be to assist in the implementation of major projects. The Research Analyst will work closely with Austin 3-1-1 IT Application Analysts team to complete the following functions:<ul> <li>Manage CRM user accounts and licenses. Identify and stop date accounts for staff who no longer need access. Will be responsible for creating new user accounts in new solution. * Identify and configure CRM user roles and security levels for all user accounts.</li> <li>Assist with database testing of configuration done by IT Application Analyst.</li> <li>Assist with service request testing of configuration done by IT Application Analyst.</li> <li>Documentation of processes related to configuration and business practices.</li> <li>Creation of basic reports for analysis during migration of data from CSR to new CRM solution.</li> <li>Assist with testing of Mobile App configuration done by IT Application Analyst.</li> <li>Assist with testing of configuration for any intake platforms done by IT Application Analyst.</li></ul> <br><strong>Employment Application:</strong> <ul> <li>The City of Austin employment application is an official document; incomplete applications will not be considered.</li> <li><strong>Please be sure to detail on the application all current and previous employment that you wish to be considered as part of your qualifications.</strong></li> <li>The Employment Record should be complete with job titles, employment dates, job duties, functions, and responsibilities for each position held.</li> <li>Rsums will not be accepted and statements such as "see rsum" will not be accepted. You may use "N/A" for fields that are not applicable.</li> <li>Please note that Austin Energy may close the job posting at any time after 7 days from the date of the initial advertisement. Once the job posting has closed, applications cannot be changed.</li> <li><strong>This position requires experience in customer/consumer service for utility/construction or related services. Please include all your relevant work experience that meets this requirement.</strong></li> </ul><br><strong>Assessments:</strong><br><br>Your skill level in some of the competency areas for this job may be assessed through skills testing.<br><br><strong>If you are selected as a top candidate:</strong><ul> <li>Verification of your education (which may include high school graduation or GED , undergraduate and/or graduate degrees) will be required. You must provide proof of education from an accredited organization/institution.</li> <li>If you are identified as a top candidate and are in the military or a veteran, you will need to provide a copy of your DD-214 prior to confirming a start date.</li> <li>This position requires a criminal background investigation.</li> </ul><br><strong>Work Schedule:</strong><ul> <li>This position is categorized as Essential Personnel with the City of Austin. Essential staff are required to work during emergencies or bad weather if they are scheduled to work and, in some cases, when they are not scheduled. Essential employees ensure the continuance of key operations for the City of Austin.</li> <li>Work hours may include after hours, holidays, and weekends.</li> <li>Shifts may change according to departmental needs.</li> <li>Employee may be required to work additional hours outside of regular work schedule</li> </ul><br>Preferred Qualifications <br><strong>Preferred Experience:</strong><ul> <li>Technical support experience in a customer relationship system, including identifying, configuring and testing possible solutions.</li> <li>Experience in creating and updating documentation for business processes and system configuration.</li> <li>Experience in creating basic data reports in support of operational and project analysis.</li> <li>Experience in supporting technical projects with documentation, tasks completion, note taking, etc.</li></ul><br>Duties, Functions and Responsibilities <br><strong>Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned.</strong><br> <li>Gathers data to meet specific project objectives by using various informational sources.</li> <li>Assists in planning design instrumentation and research methodology for gathering data.</li> <li>Collects information and establishes a database to catalogue, update and retrieve data.</li> <li>Analyzes data to determine trend, discrepancies or other specific departmental business issues.</li> <li>Coordinates meetings with targeted audiences to identify or clarify departmental issues, which may include committees, consultants, citizen's groups, etc.</li> <li>Authors or edits technical reports to provide a summary of findings.</li> <li>Manages data using statistical analysis processes and project management techniques.</li> <li>Conducts presentations and designs ancillary visual graphics to enhance reporting.</li> <br><br><strong>Responsibilities - Supervisor and/or Leadership Exercised:</strong><ul><li>None.</li></ul> Knowledge, Skills and Abilities <br><strong>Must possess required knowledge, skills, abilities, and experience and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed.</strong><ul> <li>Knowledge of statistical methodology.</li> <li>Knowledge of city practice, policy and procedures.</li> <li>Skill in oral and written communication.</li> <li>Skill in handling multiple tasks and prioritizing.</li> <li>Skill in using computers and related software.</li> <li>Skill in data analysis and problem solving.</li> <li>Skill in planning and organizing.</li> <li>Ability to establish databases to maintain or track data.</li> <li>Ability to conduct presentations.</li> <li>Ability to author technical documents.</li> <li>Ability to identify variables and utilizing various resources to gather data.</li> <li>Ability to work with frequent interruptions and changes in priorities.</li> <li>Ability to establish and maintain good working relationships with other city employees and the public.</li> </ul> Criminal Background Investigation This position has been approved for a Criminal Background Investigation. EEO/ADA <br>The City of Austin is committed to compliance with the Americans with Disabilities Act. If you require reasonable accommodation during the application process or have a question regarding an essential job function, please call (512) 974-3210 or Texas Relay by dialing 7-1-1.<br><br>The City of Austin will not discriminate against any applicant or employee based on race, creed, color, national origin, sex, gender identity, age, religion, veteran status, disability, or sexual orientation. In addition, the City will not discriminate in employment decisions on the basis of an individual's AIDS , AIDS Related Complex, or HIV status; nor will the City discriminate against individuals who are perceived to be at risk of HIV infection, or who associate with individuals who are believed to be at risk.

<p>TPW Data & Technology Minimum Qualifications Education and/or Equivalent Experience: Graduation with a Bachelors degree from an accredited college or university with major course work in a field related to the job plus four (4) years of experience. Data Analyst, IT, Transportation, Systems Analyst, Software Developer, Field Technician</p>

City Of Austin Business Intelligence Interview Guide

Overview

City Of Austin Business Intelligence Salary

City Of Austin Business Intelligence Interview Process

City Of Austin Business Intelligence Interview Questions

City Of Austin Business Intelligence Jobs