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

Consultnet Business Intelligence Interview Guide

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


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

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

Overview

Consultnet 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.

Consultnet 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>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

Consultnet Business Intelligence Interview Questions

<p>Business Analyst/ PM (Remote) <br> 8 month contract possible extension <br> $48.00 to $52.00per hour <br> <br> Job Description<br> <br> Our client is in the Financial and Banking space is looking for a Business Analyst/PM. This individual advocates for the business clients on projects in all phases of the solution development lifecycle for each critical stage. This will include initiation, analysis, development, testing, and post-implementation follow-up. They will need a strong knowledge of software and systems architecture, methods, and terminology. This individual is responsible for the planning, executing and managing projects and programs through out the company, as well as the ability to research and analyze data. They will make sure that all the tickets are being sent to the right department <br><br>Required Skills <br> </p><ul> <li> 6 years as a Business Analyst </li> <li> PM tools Jira and Confluence experience </li> <li> Lucid- (Figma is a plus) </li> <li> Strong skills with Microsoft office (Excel, Word, PowerPoint, Outlook, ect) </li> <li> Agile Experience </li> <li> 2 years of experience managing projects fast paced Environment </li> <li> 2 Business/Systems Analysis </li> </ul> Education <ul> <li> Bachelor's Degree or 5 years working experience. </li> </ul> <br> Bonus/Soft skills <ul> <li> Finance and banking background </li> <li> PMI, ACP or equivalent </li> <li> Strong work ethic and self-motivation </li> </ul> <br> <br>Welcome to ConsultNet and the family of companies, Tekne, SaltClick, TechBridge, and OmniMedia. As a premier national provider of technology talent and solutions, our expertise spans across project services, contract-to-hire, direct placement, and managed services both onshore and nearshore.<br> <br> Celebrating more than 25 years of partnership with a diverse client base, we've crafted rewarding opportunities for our consultants, fostering high-performing teams that deliver impactful results.<br> <br> Over the last few years thousands of consultants have found their calling with us in roles that have made a meaningful impact on their lives, enhanced their career, challenged them, and propelled them towards achieving their personal and professional goals. At the ConsultNet family of companies, we believe effective communication is crucial in aligning the right job with your unique skills and professional aspirations. To us, it's all about the personal approach we take and the values we uphold.<br> <br> Our comprehensive service offerings cover a wide range of technology positions across key markets nationwide. Client more at www.consultnet.com .<br> <br> We champion equality and inclusivity, proudly supporting an Equal Opportunity Employer policy. We welcome applicants regardless of Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other status protected by law.

<p>Sr. Data Engineer Salt Lake City, UT 90days contract that is likely to extend through q1 and q2 of next year Contract Rate: $65.00 - $75.00 per hour Our client is in search for a Data Engineer to join their team on a long-term contract. You will be r esponsible for developing and deploying enterprise grade platforms that enable data-driven solutions. In addition you will automate and maintain scalable infrastructure. You will also ensure delivery of a highly available and scalable systems and monitor all systems and applications and ensure optimal performance as well as research and test new tools and applications. Required Skills: 5 years of Data Engineering experience 3 years of CI/CD tools experience 3 years of Python experience Expertise with ETL, Unix/Linux, scheduling and orchestration tools pache Kafk JSON DO/Git experience PI experience Bonus Skills: utomated Testing experience BDD - Behavior Driven Development Experience with Big Data Distribution systems Experience within the financial services and solutions space Welcome to ConsultNet and the family of companies, Tekne, SaltClick, TechBridge, and OmniMedia. As a premier national provider of technology talent and solutions, our expertise spans across project services, contract-to-hire, direct placement, and managed services both onshore and nearshore. Celebrating more than 25 years of partnership with a diverse client base, we've crafted rewarding opportunities for our consultants, fostering high-performing teams that deliver impactful results. Over the last few years thousands of consultants have found their calling with us in roles that have made a meaningful impact on their lives, enhanced their career, challenged them, and propelled them towards achieving their personal and professional goals. At the ConsultNet family of companies, we believe effective communication is crucial in aligning the right job with your unique skills and professional aspirations. To us, it's all about the personal approach we take and the values we uphold. Our comprehensive service offerings cover a wide range of technology positions across key markets nationwide. Client more at www.consultnet.com . We champion equality and inclusivity, proudly supporting an Equal Opportunity Employer policy. We welcome applicants regardless of Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other status protected by law.</p>

<p>Senior Data Engineer Remote- must work standard EST hours Long term contract/ contract to hire Our client is seeking a Senior Data Engineer to accelerate data sharing between applications, engineers, and data scientists. The successful candidate will demonstrate mature programming and design ability. The Data Engineer role supports data delivery, serving, design, monitoring, and security management for data science, graph, and machine learning engineering teams. Requirements 7 years of relevant experience Demonstrable AWS knowledge - EC2, ECS, Lambda, S3, EMR Strong programming ability in Python or Scala Experience with SQL and relational data 3 years experience in one or more big data technology : S3, HDFS, Spark, Presto, etc. SPARK preferred Experience designing and implementing ETL pipelines to support Data Science and/or Machine Learning. Nice to have Feature Store build experience and Dagster Financial industry experience</p>

Software Engineer C#<br> San Diego, CA<br> Contract<br> $63-$75 an hour<br> <br> Immediate hire with growing company. Will collaborate with other software developers, business analysts and software architects. Provide technical leadership to teammates through coaching and mentorship. Participate and lead technical discussions about technology and infrastructure. Define and execute projects independently, deal well with ambiguous/undefined problems. Software requirements and specification definition. Software design and development. Assay algorithm design and development. Enhance existing code through refactoring. Code Review. Unit and acceptance testing. Root cause analysis and defect resolution. Documentation, participate and/or lead in Agile planning, scrum and retrospectives. Use company design and development processes.<br> <br> Requirements: <br> <ul> <li> Experience working in an integrated team environment </li> <li> Bachelor's degree </li> <li> Min 1 plus years of medical software development experience</li> <li> Strong working knowledge of C#, WPF, WCF preferred, .Net framework, MSSQL, LINQ. Able to hit the ground running </li> <li> Experience with Visual Studio, GitHub, JIRA, Code Review Tools </li> <li> Knowledge of Unit Test frameworks required. Examples: XUnit, NUnit, CodedUI, MSTest </li> <li> Knowledge of UI design and prototyping required </li> <li> Knowledge of multithreaded UI development required </li> <li> Knowledge of Design Patterns required </li> </ul> Bonus Skills: <ul> <li> Medical device experience preferred </li> <li> Knowledge of Entity Framework a plus </li> </ul> <br><br>Welcome to ConsultNet and the family of companies, Tekne, SaltClick, TechBridge, and OmniMedia. As a premier national provider of technology talent and solutions, our expertise spans across project services, contract-to-hire, direct placement, and managed services both onshore and nearshore.<br> <br> Celebrating more than 25 years of partnership with a diverse client base, we've crafted rewarding opportunities for our consultants, fostering high-performing teams that deliver impactful results. <br> <br> Over the last few years thousands of consultants have found their calling with us in roles that have made a meaningful impact on their lives, enhanced their career, challenged them, and propelled them towards achieving their personal and professional goals. At the ConsultNet family of companies, we believe effective communication is crucial in aligning the right job with your unique skills and professional aspirations. To us, it's all about the personal approach we take and the values we uphold. <br> <br> Our comprehensive service offerings cover a wide range of technology positions across key markets nationwide. Client more at www.consultnet.com . <br> <br> We champion equality and inclusivity, proudly supporting an Equal Opportunity Employer policy. We welcome applicants regardless of Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other status protected by law.

Consultnet Business Intelligence Interview Guide

Overview

Consultnet Business Intelligence Salary

Consultnet Business Intelligence Interview Process

Consultnet Business Intelligence Interview Questions

Consultnet Business Intelligence Jobs