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

Pureintegration Business Intelligence Interview Guide

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


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

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

Overview

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

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

<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

Pureintegration Business Intelligence Interview Questions

<p><strong>Company Description</strong></p><p>pureIntegration is a technology consulting firm with 20+ years of experience servicing Fortune 100 clients headquartered in the DC area. We serve clients in the fastest growing industry of communications, media, and entertainment.</p><p><br></p><p><strong>Job Description</strong></p><p>We are looking for a <strong>Senior</strong> <strong>Data Process Consultant/Senior Data Architect/Engineer (AWS) </strong>to join our team in engaging with customers in the Media and Entertainment industry to define data processes that drive customer insights and client revenue growth. The ideal candidate will demonstrate both strong hands-on data engineering experience and best practices as well as the ability and desire to lead engagements involving multiple client workstreams to understand complex data processes and define recommended improvements in coordination with strategic goals.</p><p><br></p><p>In this role, you’ll have the opportunity to play a key role in delivering data and automation-centric customer engagements, collaborating with both management and engineering-level customer resources as well as coordinating activities performed by a consulting project team. You will have the opportunity to gain an understanding of complex advertising and customer segmentation data, and therefore experience with advertising targeting use cases is a plus.</p><p><br></p><p><strong><em>The technology stack that you’ll be working with includes AWS (S3, Athena, etc), Databricks, Snowflake, Looker, and more.</em></strong></p><p><br></p><p>This is an on-site, full-time position based in our Philadelphia office. The annual base salary is <strong><em>$175,000 - $185,000.</em></strong> Candidates will be paid within this range based on their work experience and skills. Candidates are also eligible for our full list of benefits linked <a>here</a><u>.</u></p><p><br></p><p><strong>Responsibilities</strong>:</p><ul><li>Serve as a customer point of contact driving engagement and documentation of customer “as-is” processes and architecture related to in-scope project use cases. This includes data, its sources, structure and tooling, outputs, interaction between teams, and flow to produce outcomes supporting given use cases.</li><li>Drive cross-team workshops as necessary in support of use case objectives and successful outcomes; lead and participate as required in client priority needs during the term of engagements.</li><li>Demonstrate leadership in collaboration across client teams in an execution role responsible for:</li><li>Analysis of current state processes, tooling, and data flows to define inefficiencies and identify and document areas for improvement.</li><li>Ensure data quality, consistency, and lineage of source system data for each use case.</li><li>Provide actionable recommendations for automation improvement of data processes and workflows.</li><li>Produce and provide a rationale for prioritization of recommendations for process and improvement.</li><li>Deliver best practice recommendations for automation and data process improvement through familiarity with data use for AI, data lakes/lake house type concepts, data federation, and other concepts driving client process transformation and improvement road development.</li><li>Bring existing expertise and evaluate net new tooling where relevant to include in recommended client improvements.</li><li>Lead consulting team execution of specific customer data-producing use cases both to deliver necessary customer data outcomes as the result of project delivery requirements, as well as to gain a deeper customer's current state understanding.</li><li>Ensure compliance with regulatory, legal, and corporate data management is considered during use case development.</li><li>Update business, functional, and technical specifications for client requirements documents based on use case execution.</li><li>Lead hands-on development, POC, or demonstration of improvement recommendations; lead transition of these to production as needed.</li><li>Ensure actions taken in the execution of client projects are consistent with client business and organizational goals and defined for the project.</li><li>Provide weekly status reporting and client presentations using client-preferred templates and tools.</li><li>Provide guidance and mentoring for more junior team members.</li></ul><p><br></p><p><strong>Qualifications</strong></p><p><strong>Requirements</strong>: Bachelor's Degree in Data Science, Computer Science, Information Systems, or Equivalent with enterprise client experience.</p><ul><li>At least 7+ years’ experience as a Data Architect or Engineer, with demonstratable experience in business process, data process, and data management with enterprise IT data systems.</li><li>Prior consulting experience in large enterprise IT or data process transformation project execution.</li><li>Strong communication and presentation skills with both client executives and individual contributors.</li><li>Willingness to work full-time in an office in the Philadelphia metro area.</li><li>Ability to collaborate and mediate between differing viewpoints to gain common buy-in on direction.</li><li>Hands-on automation expertise with an understanding of data flows, ETL, data modeling, streaming, and other concepts.</li><li>Experience in AWS-based data architectures, including technologies such as step functions, Lambda, Managed Airflow, S3, Dynamo DB, DataSync, dbt, etc.</li><li>Experience working in Agile environments.</li><li>Experience and comfort in interacting and presenting with both technical and business stakeholders.</li><li>Experience in preparing data discovery findings and solution architectures, as well as the ability to navigate and present to stakeholders.</li><li>Previous experience with data usage for entertainment and media industry advertisement segmentation and targeting is desireable.</li></ul><p><br></p><p><strong>Preferred Skills</strong>:</p><ul><li>Experience with the software development life cycle best practices.</li><li>Experience with Databricks and Snowflake.</li><li>Experience with BI tools such as Looker, PowerBI or Tableau.</li><li>Experience with functional languages such as Python, Go, etc.</li><li>A passion for learning and adapting to new technologies.</li><li>Ability to multi-task and work under pressure of delivery timelines and client expectations.</li><li>Ability to see the big picture, not just the piece you are working on.</li></ul><p><br></p><p><strong>Additional Information</strong></p><p><em>pureIntegration is an Equal Opportunity Employer (EOE), qualified applicants are considered for employment without regard to age, race, color, religion, sex, national origin, sexual orientation, disability, or veteran status. All your information will be kept confidential according to EEO guidelines. Additionally, the Wage Transparency Omnibus Amendment Act of 2023 grants you rights regarding transparency in wage information. To learn more, please refer to this <a>link</a>.</em></p><p><br></p><p><strong>Disability Accommodation for Applicants to pureIntegration</strong></p><p>pureIntegration provides reasonable accommodation for qualified individuals with disabilities and disabled veterans in job application procedures. For reasonable accommodation requests, please contact us by email at HR@pureintegration.com or by mail to: pureIntegration, Human Resources Department, 1801 Robert Fulton Dr, Suite 450, Reston, VA 20191. Please indicate the position you are applying for.</p><ul><li><a>Know Your Rights: Workplace Discrimination is Illegal (dol.gov)</a></li><li><a>Right to Work (English and Spanish).pdf</a></li><li><a>E-Verify Participation Notice (English and Spanish).pdf</a></li></ul><p><br></p><p><strong>pureIntegration </strong>would love to hear from you - your career journey starts here!</p>

Pureintegration Business Intelligence Interview Guide

Overview

Pureintegration Business Intelligence Salary

Pureintegration Business Intelligence Interview Process

Pureintegration Business Intelligence Interview Questions

Pureintegration Business Intelligence Jobs