The Hhs Technology Group Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Hhs Technology Group Business Intelligence Interview Guide

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


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

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

Overview

Hhs Technology Group 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.

Hhs Technology Group 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

Hhs Technology Group Business Intelligence Interview Questions

<p><strong>WHO WE ARE: </strong> </p><p>At HHS Tech Group (HTG), our work matters, and each of us makes a difference in the lives of people every day. </p><p>HTG is a leader in developing and delivering innovative, purpose-built modular software and technology solutions to clients in the commercial and government sectors. </p><p><strong>WHAT WE DO: </strong> </p><p>HHS Tech Group creates innovative, purpose-built technology products and solutions, resulting in value and positive, quantifiable impact for our clients and those they serve. </p><p>Our people bring our software to life through collaborative relationships with our clients, working as a team, and helping to solve complex problems that create positive personal and community impact for the people our clients serve. </p><p>Each day, our software products and our people are making a difference. </p><p><strong>OUR PEOPLE MATTER MOST: </strong> </p><p>Improving the lives of others and making an impact daily is no simple task. We are dedicated to our team's professional and personal growth and well-being. Some key rewards and benefits include: </p><ul><li> Generously sponsored Medical Insurance </li><li> Fully paid premiums on dental, vision, life, and disability insurance. </li><li> Generous 401k matching program (100% match up to 6%) </li><li> Tuition and Certification reimbursement </li><li> Open PTO policy </li> <br></ul><p><strong>Join us!</strong> </p><p><strong>WHO WE ARE HIRING: </strong><strong>Data Analyst </strong> </p><p> </p><p><strong>WHAT YOU WILL DO:</strong> </p><p>The Data Analyst specializes in designing, developing, maintaining, and executing ETL/data conversion routines for large, enterprise-scale systems, and should have very strong SQL Server skills. The work is performed in a complex software environment on an SOA platform to include a mix of Commercial Off The Shelf (COTS) software solutions, state systems and external government and carrier entities. </p><p>The Data Analyst will: </p><ul><li>Design and develop ETL/data conversion routines in accordance with the architectural specifications, then tests, maintains, and executes the created processes </li><li>Works with the Business analyst to elicit and analyze data conversion requirements and schedule </li><li>Performs data mapping between current data elements and system standard conversion elements </li><li>Creates validation programs designed to check data in data files and edit data field content and ensure correctness in relation to other data in file </li><li>Executes validation program against conversion data; finds solutions to correct data errors </li><li>Develop and perform standard queries and searches to identify data inconsistencies, missing data and resolve as needed </li><li>Adhere to data naming, data definitions and modeling standards established by the Data Architect and customer requirements </li><br> </ul><p> </p><p><strong>MINIMUM QUALIFICATIONS:</strong> </p><p> </p><ul><li> Experience leading complex data conversion and migration efforts </li><li> Experience developing documentation related to data management, conversion, and migration (plan, approach, mappings, reports) </li><li> Analytical skills: data analysis, data quality<strong>, </strong>complex data mapping </li><li> Excellent verbal and written communication, client facing experience. </li><li> Experience with MMIS </li><li> Excellent knowledge of Excel </li><li> Expertise with XML, SQL, Data Modeling Language (DML), and Data Definition Language (DDL) </li><li> Knowledge of reporting tools like Tableau, Sisense, Domo </li><li> Knowledge of MMIS domain </li><li> Knowledge of Medical Provider Management domain </li> <br></ul><p><strong>DESIRED SKILLS:</strong> </p><ul><li>State Government initiatives in Health and Human Services (HHS), Medicaid, MMIS, Provider Management); strongly desired. </li><li>Ability to multi-task, take initiative, assume accountability, work independently, and self-manage duties and responsibilities, as well as intuitively having the ability to pivot focus between tasks according to priorities to achieve maximum efficiency. </li><li>Experience with Apache AirFlow </li><li>Working with HIPAA and Secure Data transfers (TLS 1.2+ standards) </li><li>Understand data s3 Data encryption standards for HIPAA data (AES 256 +) </li> </ul>

Hhs Technology Group Business Intelligence Interview Guide

Overview

Hhs Technology Group Business Intelligence Salary

Hhs Technology Group Business Intelligence Interview Process

Hhs Technology Group Business Intelligence Interview Questions

Hhs Technology Group Business Intelligence Jobs