The Pima County Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Pima County Business Intelligence Interview Guide

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


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

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

Overview

Pima County 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.

Pima County 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>Let’s say you’re working for a social media company trying to grow your user base. You know that people tend to use the same social network as their peers, so you want to target all your growth and marketing efforts on specific age groups so as to take advantage of network effects.</p>

<p>You wish to begin with the age group that is currently generating the most connections (fastest growing).</p>

<p>Write a SQL query to find the average number of accepted friend requests for each age group and order the results in descending order.</p>

<p><em>Note: The average number of accepted friend requests is calculated as the total number of friend requests sent by an age group that was accepted divided by the number of members in said age group.</em></p>

<p><em>We can assume the tables hold valid data in that there are no duplicate friend requests, friend requests are only accepted once, and user A can only accept a friend request from User B after B sends A a friend request.</em></p>

<p><em>The result should be rounded to two decimal places.</em></p>

<h3>Example:</h3>

<p><strong>Input:</strong></p>

<p><strong><code>friend_requests</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>receiver_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>sent_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>requests_accepted</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>accepter_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>accepted_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>age_groups</code></strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>user_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>age_group</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>age_group</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>average_acceptance</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Find the average number of accepted friend requests for each age group that sent the requests.

Avg Friend Requests By Age Group

<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

Pima County Business Intelligence Interview Questions

<div><p><strong>OPEN UNTIL FILLED</strong></p><p><strong>Salary Grade: 13</strong></p></div><div><p><strong><u>Pay Range</u><br/>Hiring Range: $57,607 - $69,128 Annually<br/>Full Range: $57,607 - $80,649 Annually</strong><br/><br/></p></div><p><strong><em>Salary offers are based on the candidate's equivalent experience and internal equity with other employees within the same job classification.</em></strong></p><p>Pima County's Department of Transportation is looking for a skilled, motivated professional to join their Mobility, Innovation & Technology (MIT) Division in the Analytics section. This team is responsible for implementing and managing the technology and application needs of the department from a functional & analytical perspective. The MIT division supports the department in diverse ways such as reporting through web applications, process automation, system integrations & data maintenance for improved accuracy. The ideal candidate will demonstrate the ability to prioritize tasks and meet deadlines while emphasizing accuracy and attention to detail. We are looking for a self-motivated, enthusiastic, dependable, innovative contributor with a positive attitude to join our team.</p><p>This is an in-office position at located 201 N Stone, Tucson, AZ, and cannot be remote.</p><p><em><strong>The first review of applications will be on 11/22/2024.</strong></em></p><p>As defined under the Americans with Disabilities Act, this classification may include any of the following tasks, knowledge, skills, and other characteristics. This list is ILLUSTRATIVE ONLY and is not a comprehensive listing of all functions and tasks performed by incumbents of this class. Work assignments may vary depending on the department’s need and will be communicated to the applicant or incumbent by the supervisor.</p><ul><li>Acts as the subject matter expert on reporting tools and data analysis; makes recommendations on process changes;</li><li>Provides data analysis and reporting solutions support for various departments;</li><li>Works on data analysis tasks within one or more functional areas independently or as part of a team;</li><li>Collaborates with internal and external stakeholders to gather and validate requirements;</li><li>Develops and writes business requirements for identified data analysis and reporting solutions;</li><li>Creates and maintains a variety of reports, data queries, scripts, workflows, and automated tasks using structured query language and various database management tools;</li><li>Identifies and analyzes commonly used queries and reports to determine if currently available solutions are applicable;</li><li>Researches reporting problems and assists in the creation of models to help analyze reporting needs;</li><li>Develops, executes, and documents user test plans;</li><li>Coordinates and performs quality control testing of new or updated software and processes; helps resolve issues based on test results;</li><li>Verifies that collected data meets required quality standards;</li><li>May maintain the quality of metadata repository/data dictionary by adding, modifying, and deleting data;</li><li>Creates data quality tickets and ensures they are resolved in a timely manner;</li><li>Assists in the development and presentation of end-user training materials;</li><li>May train and assist clients in the use of business intelligence solutions.</li></ul><p><strong>Bachelor's degree from an accredited college, university, or technical trade school with a major in computer science, computer engineering, management information systems (MIS), or a closely related field as determined by the department head at the time of recruitment.</strong></p><p><strong>(Relevant experience and/or education from an accredited college, university, or technical trade school may be substituted.)</strong></p><p><strong><u>Qualifying education and experience must be clearly documented in the "Education" and "Work Experience" sections of the application. Do not substitute a resume for your application or write "see resume" on your application.</u></strong></p><p><strong><u>Preferred Qualifications</u>:</strong></p><ol><li>Minimum one (1) year experience understanding & analyzing business processes to make recommendations to maximize and prioritize efficiencies.</li><li>Minimum two (2) years of experience with customer service in a functional capacity to bridge communication gaps across diverse groups. For example, between business units or across diverse teams.</li><li>Experience supporting ERP systems or Asset Management applications, preferably in a Transportation or Public Works setting.</li><li>Experience working with large data sets, data mining, data analysis, or reconciling multiple systems.</li><li>Experience using Python, SQL, or other industry-standard programming languages in support of creative problem-solving to inform decision-making.</li><li>UAS Remote Pilot Certificate and experience flying in support of business needs.</li></ol><p><strong><u>Selection Procedure</u>:</strong></p><p><strong>Pima County Human Resources Department reserves the right to admit to the selection process only those candidates that meet the minimum/desired qualifications. All applications will be assessed based on an evaluation of the listed education and experience. Candidates meeting the minimum/desired qualifications may be further evaluated/scored against any advertised Preferred Qualifications. The hiring authority will interview and select the successful candidate from a referral list provided by Human Resources. Additional assessments/testing may be required as part of the selection process.</strong></p><p><u>Licenses and Certificates</u>: <strong>Valid driver license is required at time of application. Valid AZ driver license is required at time of appointment. The successful applicant will be subject to a 39-month DOT Motor Vehicle Record review to determine applicant’s suitability to operate county vehicles in accordance with Pima County administrative procedures. Failure to obtain and maintain the required licenses and certifications shall be grounds for termination. Any offer of employment resulting from this recruitment is contingent upon Fleet Services’ review and approval of the candidate’s driving record.</strong></p><p><u>Special Notice Item</u>: The County requires pre-employment background checks. Successful candidates will receive a post-offer, pre-employment background screening to include verification of work history, education, and criminal conviction history. A prior criminal conviction will not automatically disqualify a candidate from employment with the County.</p><p><u>Physical/Sensory Requirements</u>: Physical and sensory abilities will be determined by position.</p><p><u>Working Conditions</u>: Working conditions will be determined by position.</p><p><u>EEO Information</u>: <strong>Pima County Government is an Equal Employment Opportunity employer. We are committed to an inclusive and diverse workforce and will not discriminate in employment opportunities or practices on the basis of race, color, religion, national origin, age, disability, gender, sexual orientation, kinship, political interest, or any other characteristic protected by law.</strong></p>
#J-18808-Ljbffr

Pima County Business Intelligence Interview Guide

Overview

Pima County Business Intelligence Salary

Pima County Business Intelligence Interview Process

Pima County Business Intelligence Interview Questions

Pima County Business Intelligence Jobs