Prepare for and practice interview questions from Branch Metrics.

Branch Metrics Interview Questions

Branch Metrics Interview Guides

<p>Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.</p>

<p>Write a query to randomly sample a row from this table.</p>

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

<p><code>big_table</code> table</p>

<table>
<thead>
<tr>
<th>Columns</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>


Write a query to randomly sample a row from a big table.

Random SQL Sample

<p>Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.</p>

<p>How would you assess the validity of the result?</p>


Experiment Validity

<p>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


<p>What is a key disadvantage of the F-test when compared to multiple t-tests?</p>

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Branch Metrics Salaries by Position

<p>At Branch, were transforming how brands and users interact across digital platforms. Our mobile marketing and deep linking solutions are trusted to deliver seamless experiences that increase ROI, decrease wasted spend, and eliminate siloed attributi Data Engineer, Computer Science, Engineer, Data Scientist, Backend Engineer, Technology, Systems</p>

<p>At Branch, we're transforming how brands and users interact across digital platforms. Our mobile marketing and deep linking solutions are trusted to deliver seamless experiences that increase ROI, decrease wasted spend, and eliminate siloed attribution. Our Branch team consists of smart, humble, and collaborative people who value ownership over all. Everything we do is centered around creating a great product, team, and company that lives and breathes our motto: Build Together, Grow Together, Win Together. As a Senior Data Engineer, you will design, build, and manage components of our highly available real-time data platform handling petabytes of data. Our platform is designed to ingest and process billions of events per day, and make the resulting aggregations and insights available within minutes in our analytical data stores. Our customers rely on this data for complex ad hoc "slice and dice" queries to drive their day to day mobile growth strategies. Data is at the core of our business, and we're constantly innovating to make our systems more performant, timely, cost-effective, and capable while maintaining high reliability. You will build on top of our core data infrastructure and pipelines using technologies and tools tailored for massive data sets including Flink, Spark, Kafka, and Druid while working in the AWS cloud environment. If you are interested in building systems that can consume and explore billions of data points a day, work with petabytes of data, and want to push what is possible with data, this is the place for you As a Senior Data Engineer, you'll get to: Architect, build, and own real-time and batch data aggregation systems to deliver quality analytical reports for our internal and external customers. Collaborate with Data Scientists, Backend Engineers, Data & Infrastructure Operations, and Products Managers to deliver new features and capabilities for customers. Develop clean, safe, testable, and cost-efficient solutions. Make well-informed decisions with deep knowledge of both the internal and external impacts on teams and projects. Foresee shortcomings ahead of time and be able to drive to resolution. You'll be a good fit if you have: BS in Computer Science or equivalent. 6 years of Software Engineering or Data Engineering experience with a recent focus on big data. Strong development skills in Java or Scala. Solid background in the fundamentals of computer science, distributed systems, large scale data processing as well as database schema design and data warehousing. Practical experience managing AWS or Google Cloud environments. Experience in containerized deployment or Kubernetes is a big plus Good understanding of a broad spectrum of NoSQL, traditional RDBMS, and analytical/columnar data stores including Postgres, Druid, Vertica, Redshift, Hadoop, Hive, Cassandra, Aerospike, and Redis. Ability to build systems that balance scalability, availability, and latency Strong ability to advocate for the continual deployment and automation tools, monitoring, and self-healing systems that can help improve the lives of our engineers. Great communication skills and you are a team player who has a proven track record of building strong relationships with management, co-workers, and customers. A desire to learn and grow, push yourself and your team, share lessons with others and provide constructive and continuous feedback, and be receptive to feedback from others. This role will be based at our Austin, TX office and follows a Hybrid schedule that will be aligned with our Return to Office guidelines. However, we are also open to full-time remote candidates. This role does not qualify for relocation or visa sponsorship. In accordance with applicable law, the following represents a reasonable estimated compensation range for this role: the estimated pay range for this role, if based in Austin, TX, is $144,000 to $184,000. Please note that this information is provided for those hired in Austin, TX only. Compensation for candidates outside of Austin, TX will be based on the candidate's specific work location. Actual compensation will be determined based on skills, experience, and geographic location and may be more or less than the amount shown above. The salary range provided represents base compensation and does not include potential equity, which is available for qualifying positions. Branch offers a comprehensive benefits package, including medical, dental, 401(k), and other benefits, for qualified employees. For detailed information on the benefits specific to your position, please consult with your recruiter. Branch is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status. If you think you'd be a good fit for this role, we'd love for you to apply At branch, we strive to create an inclusive culture that encourages people from all walks of life to bring their unique, diverse perspectives to work. We aim every day to build an environment that empowers us all to do the best work of our careers, and we can't wait to show you what we have to offer A little bit about us: Branch is the leading provider of engagement and performance mobile SaaS solutions for growth-focused teams, trusted to maximize the value of their evolving digital strategies. The Branch platform provides a seamless experience across paid and organic, on all channels and platforms, online and offline, to eliminate friction and drive valuable action at the moments of highest intent. With Branch, businesses gain accurate mobile measurement and insights into user interactions, enabling them to drive conversions, engagement, and more intelligent marketing spend. Branch is an award-winning employer headquartered in Mountain View, CA. World-class brands like Instacart, Western Union, NBCUniversal, Zocdoc and Sephora acquire users, retain customers and drive more conversions with Branch. Candidate Privacy Information: For more information on the data that Branch will collect through your application, and how we use, share, delete, and retain that information as part of our recruitment and employment efforts, please see our HR Privacy Policy.</p>

Branch Metrics Interview Questions

Branch Metrics Interview Guides

Branch Metrics Interview Questions

Branch Metrics Salaries by Position

Branch Metrics Opening Jobs