The State of south carolina Business Intelligence interview guide, interview questions, salary data, and interview experiences.

State of south carolina Business Intelligence Interview Guide

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


Getting ready for an Business Intelligence interview at State of south carolina? The State of south carolina Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

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

Overview

State of south carolina 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.

State of south carolina 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>Suppose your company needs to cut costs due to an economic downturn. During a coffee break, you hear a rumor that a lot of money goes to employees who don’t do their work, and you decide to find out if the rumor is true.</p>

<p>Given two tables: <code>employees</code> and <code>projects</code>, find the sum of the salaries of all the employees who didn’t complete any of their projects.</p>

<p>Clarification:</p>

<p>We will consider a project unfinished if it has no end date (its <code>End_dt</code> is <code>NULL</code>).</p>

<p>Given this, we’ll say an employee didn’t finish any of their projects when:</p>

<ul>
<li>They were assigned at least one project.</li>
<li>None of their projects have an <code>End_dt</code>.</li>
</ul>

<p><strong>Example:</strong></p>

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

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>id</th>
<th>salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>projects</code> table</p>

<table>
<thead>
<tr>
<th>employee_id</th>
<th>project_id</th>
<th>Start_dt</th>
<th>End_dt</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>INTEGER</td>
<td>DATETIME</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>total_slack_salary</th>
</tr>
</thead>

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


Find the total salary of slacking employees.

Slacking Employees Salaries

State of south carolina Business Intelligence Interview Questions

<strong>Salary:</strong> $56,210.00 - $104,000.00 Annually<br><br><strong>Location :</strong> Richland County, SC<br><br><strong>Job Type:</strong> FTE - Full-Time<br><br><strong>Job Number:</strong> 170233<br><br><strong>Agency:</strong> Commission for the Blind<br><br><strong>Opening Date:</strong> 12/16/2024<br><br><strong>Closing Date:</strong> 1/3/2025 11:59 PM Eastern<br><br><strong>Class Code::</strong> AM05<br><br><strong>Position Number::</strong> 60026374<br><br><strong>Normal Work Schedule::</strong> Monday - Friday (8:30 - 5:00)<br><br><strong>Pay Band:</strong> Band 7<br><br><strong>Hiring Range - Min.:</strong> $56,210.00<br><br><strong>Hiring Range - Max.:</strong> $104,000.00<br><br><strong>Opening Date:</strong> 12/16/2024<br><br><strong>EEO Statement:</strong> Equal Opportunity Employer<br><br><strong>Agency Specific Application Procedures::</strong> Please apply online. If you need assistance completing your application, please contact 803-898-7297.<br><br><strong>Veteran Preference Statement:</strong> South Carolina is making our Veterans a priority for employment in state agencies and institutions.<br><br><strong>Job Responsibilities</strong><br> <br><strong>** This is a re-advertisement. Previous applicants need not reapply. Your application is still being considered.**</strong><strong>Join Our Team as a Business Analyst!</strong><br><br>Are you an experienced IT professional with a passion for managing technical support operations and ensuring user satisfaction? Do you thrive in a dynamic environment where you can make a significant impact on IT performance? If so, we have an exciting opportunity for you!<br><br><strong>About the Role</strong>: As the Business Analyst , you will serve as a liaison between programmatic staff and IT, providing essential support for the system life cycle management, user assistance, data analysis, and documentation of the AWARE Case Management System (CMS) and other key applications. This role ensures that system configurations and processes meet agency requirements and end-user needs.<br><br>Key Responsibilities:<br><br><strong>System Life Cycle Support </strong>: Assist in managing the system life cycle for AWARE (CMS) and other key applications by participating in analysis, design, testing, implementation, maintenance, and support. Collaborate with IT and programmatic staff to ensure system updates and enhancements align with user needs and agency objectives.<br><strong>User Support and Liaison</strong>: Act as a go-between for programmatic staff and IT, providing support to users by addressing needs within the AWARE (CMS). Facilitate communication to resolve issues of varying complexity, and ensure that technical solutions are effectively communicated to non-technical staff.<br><strong>Data Analysis and Reporting</strong>: Develop and support data reports and dashboards using tools like MS-Power BI, Tableau, and SQL. Provide data insights and analytics to support decision-making and improve agency processes. Generate both regular and ad-hoc reports as required by programmatic and executive staff.<br><strong>Documentation and Policy Development </strong>: Assist in creating, reviewing, and maintaining policies, procedures, documentation, and user manuals to ensure that all system-related materials are up-to-date and meet agency standards. Ensure documentation supports end-user requirements and enhances system usability.<br><strong>Process Analysis and Optimization</strong>: Analyze current processes and work with program staff to design configurations that improve efficiency and effectiveness. Identify and implement opportunities for process improvements that streamline operations and enhance system performance.<br><strong>Backup Training Support</strong>: Serve as a backup trainer for user applications, including AWARE (CMS). Assist in the preparation and delivery of training sessions and materials to ensure users are knowledgeable and proficient in system usage.<br> <strong>Minimum and Additional Requirements</strong><br> <br>A bachelor's degree in computer science or a related area and experience in computer system development and modification. Relevant experience may substitute for the bachelor's degree on a year-for-year basis.<br> <strong>Additional Comments</strong><br> <br>The Commission for the Blind offers great health and retirement benefits with the state, including up to 30 days of earned leave per year, 13 paid holidays, and a flexible work schedule for some positions. Employees at our Columbia Campus also enjoy using the fitness center, Bowling Alley, and Gymnasium. Professional growth opportunities include tuition assistance offered to eligible employees pursuing a degree or obtaining a specialized certification.<br><br>If you are planning to relocate to South Carolina, ask about our relocation expense reimbursement.<br><br>Eligible new hires from out-of-state may receive up to $5,000 in reimbursements for certain expenses, pursuant to Section 8-11-135 of the South Carolina Code of Laws.<br><br>Are you new to South Carolina State Government? If so, you may be eligible for up to a $5,000 sign-on bonus. You must be hired for a Vocational Rehabilitation Counselor position and complete the 12-month probation to become eligible. Please contact us for more information.<br>Are you ready to make a positive impact on your community? Apply today!<br><br><strong><strong><strong>The South Carolina Commission for the Blind provides affirmative action and equal opportunity in employment for all qualified persons regardless of race, color, veteran status, genetic information, sex-including the basis of pregnancy, childbirth, or related medical conditions, national origin, age, religion, disability or any other protected category. </strong> </strong></strong> <br><br><strong>Benefits for State Employees</strong><br><br>The state of South Carolina offers eligible employees generous benefits, including health and dental insurance; retirement and savings plan options; and paid vacation and sick leave. Plus, work-life balance programs such as telecommuting and flexible work schedules are available to employees of some state agencies.<br> <br><strong>Insurance Benefits</strong><br>Eligible employees may enroll in health insurance, which includes prescription coverage and wellness benefits. Other available insurance benefits include dental, vision, term life insurance, long term disability and flexible spending accounts for health and child care expenses.<br> <br><strong>Retirement Benefits</strong><br>State employees are also offered retirement plan options, including defined benefit and defined contribution plans. Additionally, eligible employees may elect to participate in the South Carolina Deferred Compensation Program, which is a voluntary, supplemental retirement savings plan offering 401(k) and 457 plan options.<br> <br><strong>Workplace Benefits</strong><br>State employees may also be eligible for other benefits, including tuition assistance; holiday, annual and sick leave; and discounts on purchases, travel and more.<br> <br><strong>Note:</strong> The benefits above are available to most state employees, with the exception of those in temporary positions. Employees in temporary grant and time-limited positions may be eligible for all, some or none of these benefits as benefits are associated with each position type. For these positions, contact the hiring agency to determine what benefits may be available.<br><br>01 <br> <br> Supplemental questions are considered part of your official application. Any misrepresentation may result in your disqualification from employment. Please complete the State application to include all current and previous work history and education. Your employment history should include volunteer work, military time, and time spent unemployed. A resume will not be accepted nor reviewed to determine if an applicant has met the qualifications for the position. Please ensure there are no gaps in your employment history before submitting your application. I have read and acknowledge the above statement. <ul> <li>Yes</li> <li>No</li> </ul> <br><br>02 <br> <br> Do you have a bachelor's degree in computer science or a related area and experience in computer system development and modification? <ul> <li>Yes</li> <li>No</li> </ul> <br><br>03 <br> <br> How did you hear about this position? Please be specific. <br><br>Required Question

State of south carolina Business Intelligence Interview Guide

Overview

State of south carolina Business Intelligence Salary

State of south carolina Business Intelligence Interview Process

State of south carolina Business Intelligence Interview Questions

State of south carolina Business Intelligence Jobs