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

Conviva Business Intelligence Interview Guide

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


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

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

Overview

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

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

Conviva Business Intelligence Interview Questions

<strong>Conviva is the first and best place to go to understand and optimize digital customer experiences. Our Operational Data Platform harnesses full-census, comprehensive client-side telemetry-capturing every aspect of customer experience and engagement across all devices and linking them to the performance of underlying services, in real time and at a fraction of the cost of alternative solutions. Trusted by industry leaders like Disney, NBC, and the NFL, Conviva revolutionizes how businesses underst and customer experience and engagement, maximizing satisfaction, conversion, and revenue.ue.</strong><br><br>As Conviva continues to grow, we are actively looking for highly motivated and talented distributed systems engineers at all levels to join our dynamic backend development teams. You will work with some of the best engineers in building our distributed real-time streaming platform for processing, indexing and querying internet scale data. At more senior levels, you will lead technology innovations, collaborating across teams to set technical standards and steer the overall architectural framework.<br><br><strong>What Success Will Look Like: </strong><br><ul><li>Design the next generation real-time big data processing, storage and analytics engine for stateful metrics, emphasizing scalable, reliable and cost-effective solutions for low latency queries across diverse domains. </li><li>Design, build, maintain and improve a range of algorithms and their underlying systems.</li><li>Lead critical technical decisions collaboratively, guiding and training team members to tackle engineering challenges.</li><li>Design and deploy ETL pipelines using various open-source frameworks, ensuring robustness and scalability.</li><li>Foster a positive team culture, promoting code quality, driving initiatives, and ensuring impeccable execution. </li><li>Stay current with industry trends and emerging technologies in distributed database systems and stream processing frameworks. </li></ul><br><br><strong>Who You Are & What You've Done:</strong> <br><ul><li>Solid foundation in computer science, computer engineering or related fields. </li><li>Strong programming skills in C++, Rust, Scala, Java or similar language. </li><li>8+ years of industry experience in software development using modern software development processes, tool chains and infrastructure. </li><li>Proficiency in major distributed stream processing frameworks, such as Akka Streams, Apache Spark, Apache Flink and others. </li><li>Hands-on development experience with query engines or distributed database systems, such as ClickHouse, Apache Druid, Presto, BigQuery and others. </li><li>Experience in performance tuning, analysis over distributed systems. </li><li>Experience building massively scalable data infrastructure using commercial and open-source tools. </li><li>Highly motivated, passionate about technology, eager to learn, and proving ability to learn and master fast pacing innovative technologies. </li><li>Demonstrate effective collaboration within teams while being open to receiving feedback, embracing a learning mindset, and actively supporting others. </li><li>Adaptable to ambiguity and comfortable in a fast-paced work environment </li></ul><br><br><ul><li>Track record of contributing to open-source projects </li></ul><br><br>The expected salary range for this full-time position is $220,000 - $270,000 + equity + benefits. Compensation is determined by numerous factors such as your qualifications, experience, relevant education or training, and work location.<br><br><strong>Privately held, Conviva is headquartered in Silicon Valley, California with offices and people around the globe. For more information, visit us at www.conviva.com. Join us to help extend our leadership position in big data streaming analytics to new audiences and markets! </strong>

<strong>Conviva is the first and best place to go to understand and optimize digital customer experiences. Our Operational Data Platform harnesses full-census, comprehensive client-side telemetry-capturing every aspect of customer experience and engagement across all devices and linking them to the performance of underlying services, in real time and at a fraction of the cost of alternative solutions. Trusted by industry leaders like Disney, NBC, and the NFL, Conviva revolutionizes how businesses understand customer experience and engagement, maximizing satisfaction, conversion, and revenue.</strong><br><br>As Conviva continues to grow, we are actively looking for highly motivated and talented distributed software engineers at all levels to join our dynamic backend development teams. You will work with some of the best engineers in building various portions of a large end to end, distributed real time streaming data processing platform in handling internet scale massive amount data in real time. At more senior levels, you will lead technology innovation, collaborating across teams, setting technical standards, and steering the overall architectural framework.<br><br><strong>What Success Will Look Like: </strong><br><ul><li>Design the next generation real-time big data processing, storage and analytics engine for stateful metrics, emphasizing scalable, reliable and cost-effective solutions for low latency queries across diverse domains. </li><li>Design, build, maintain and improve a range of algorithms and their underlying systems.</li><li>Lead critical technical decisions collaboratively, guiding and training team members to tackle engineering challenges.</li><li>Design and deploy ETL pipelines using various open-source frameworks, ensuring robustness and scalability.</li><li>Foster a positive team culture, promoting code quality, driving initiatives, and ensuring impeccable execution. </li><li>Stay current with industry trends and emerging technologies in distributed database systems and stream processing frameworks. </li></ul><br><br><strong>Who You Are & What You've Done:</strong> <br><ul><li>Solid foundation in computer science, computer engineering or related fields. </li><li>Strong programming skills in C++, Rust, Scala, Java or similar language. </li><li>5-6+ years of industry experience in software development using modern software development processes, tool chains and infrastructure. </li><li>Proficiency in major distributed stream processing frameworks, such as Akka Streams, Apache Spark, Apache Flink and others. </li><li>Hands-on development experience with query engines or distributed database systems, such as ClickHouse, Apache Druid, Presto, BigQuery and others. </li><li>Experience in performance tuning, analysis over distributed systems. </li><li>Experience building massively scalable data infrastructure using commercial and open-source tools. </li><li>Highly motivated, passionate about technology, eager to learn, and proving ability to learn and master fast pacing innovative technologies. </li><li>Demonstrate effective collaboration within teams while being open to receiving feedback, embracing a learning mindset, and actively supporting others. </li><li>Adaptable to ambiguity and comfortable in a fast-paced work environment. </li></ul><br><br><strong>Preferred:</strong><br><ul><li>Experience in a SaaS space</li><li>Track record of contributing to open-source projects</li></ul><br><br>The expected salary range for this full-time position is $160,000 - $200,000 + equity + benefits. Compensation is determined by numerous factors such as your qualifications, experience, relevant education or training, and work location.<br><br><strong>Privately held, Conviva is headquartered in Silicon Valley, California with offices and people around the globe. For more information, visit us at www.conviva.com. Join us to help extend our leadership position in big data streaming analytics to new audiences and markets! </strong>

<strong>Conviva is the first and best place to go to understand and optimize digital customer experiences. Our Operational Data Platform harnesses full-census, comprehensive client-side telemetry—capturing every aspect of customer experience and engagement across all devices and linking them to the performance of underlying services, in real time and at a fraction of the cost of alternative solutions. Trusted by industry leaders like Disney, NBC, and the NFL, Conviva revolutionizes how businesses understand customer experience and engagement, maximizing satisfaction, conversion, and revenue.<br><br></strong>As a <strong>Senior</strong> <strong>Engineering Manager</strong> at Conviva, you will lead a team of talented data scientists and machine learning engineers and guide them in developing and implementing machine learning models and MLOps solutions. You will thrive in a fast-paced environment where you'll work closely with cross-functional teams to optimize the streaming experience for our customers and their viewers. Leveraging cutting-edge data science techniques, you will play a pivotal role in driving innovation and delivering impactful solutions in the rapidly evolving streaming media industry.<br><br><strong>What Success Will Look Like<br><br></strong><ul><li>Partner with the Product team to develop and refine the vision for innovative machine learning products.</li><li>Communicate and align internal stakeholders with the machine learning product vision, building consensus and securing support for strategic initiatives.</li><li>Lead engineering teams in executing the product roadmap, ensuring that machine learning solutions meet performance criteria and deliver substantial business value.</li><li>Own the machine learning technology roadmap, including planning, execution, and updates, to keep it aligned with industry trends and business objectives.</li><li>Promote the machine learning team's achievements within the company to enhance internal recognition and support, and advocate for the team’s innovations in external forums.</li><li>Attract and hire machine learning talent across the entire lifecycle, from data engineering to model deployment.</li><li>Maintain a thorough understanding of how customers interact with and benefit from machine learning-enhanced products. Work closely with product managers to identify and define new use cases where machine learning can address complex business challenges.<br><br></li></ul><strong>Who You Are & What You've Done<br><br></strong><ul><li>Mastery of the entire machine learning lifecycle, from initial concept through to production deployment. </li><li>Ability to assess and evaluate machine learning solutions using a combination of machine learning, business, and operational metrics.</li><li>Proven experience in leading and managing a team of ML engineers and data scientists, driving their professional growth and delivering impactful projects within tight deadlines.</li><li>Strong written and verbal communication skills, essential for effective interaction and documentation.</li><li>Proven ability to secure stakeholder buy-in and collaborate effectively with cross-functional teams.</li><li>Capability to co-develop product features and roadmaps in partnership with product managers.</li><li>In-depth practical and theoretical knowledge of machine learning and deep learning principles, including the deployment and ongoing enhancement of ML products.</li><li>Familiarity with Python and commonly used ML frameworks.</li><li>Experience in guiding and mentoring machine learning engineers to foster their growth and development.</li><li>Skills in managing complex projects and delivering them efficiently and effectively.</li><li>BS/MS or PhD in a quantitative field such as Data Science, Computer Science, Statistics, or a related discipline.<br><br></li></ul><strong>Preferred<br><br></strong><ul><li>Familiar with common graph algorithms.</li><li>Experience with time series analysis.</li><li>Experience with Ad Tech or ID graph.<br><br></li></ul><em>The expected salary range for this full-time position is $200,000 - $300,000 + equity + benefits. Compensation is determined by numerous factors such as your qualifications, experience, relevant education or training, and work location.<br><br></em><strong>Privately held, Conviva is headquartered in Silicon Valley, California with offices and people around the globe. For more information, visit us at <a>www.conviva.com</a>. Join us to help extend our leadership position in big data streaming analytics to new audiences and markets!</strong>

Conviva Business Intelligence Interview Guide

Overview

Conviva Business Intelligence Salary

Conviva Business Intelligence Interview Process

Conviva Business Intelligence Interview Questions

Conviva Business Intelligence Jobs