Prepare for and practice interview questions from Business Wire.

Business Wire Interview Questions

Business Wire Interview Guides

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

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

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?

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.

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

Input:

<code>big_table</code> table

<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

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.

How would you assess the validity of the result?

Experiment Validity

Business Wire Salaries by Position

Business Wire, a Berkshire Hathaway company, is the global market leader in press release distribution and regulatory disclosure. We are on a mission to redefine how organizations connect with their audiences - and that's just the beginning! Organizations, large and small, depend on us to accurately publicize market-moving news and multimedia, and generate social engagements that develop interactions with their target audiences. About the Role We are looking for an experienced Principal Software Engineer with a strong cloud engineering design background to lead engineering design and development for an architecture modernization effort for Business Wire's industry leading press release processing system. The project requires a complete rebuild of Business Wire's back office system, including transition from a legacy architecture to a modern, serverless technology stack, a new database platform, new REST API platform, and optimization of the system to ensure its long-term operational reliability. What You'll Do <ul> <ul><li>Develop engineering design and documentation for multiple components of a press release processing system, with emphasis on reliability, performance, and maintainability. </li><li>Provide technical leadership and direct contribution to the code base using modern technology stacks, with emphasis on serverless platforms. </li><li>Lead development of proof of concepts (POCs). </li><li>Contribute to design of development environments, develop usage guidelines, and SDLC best practices. </li><li>Lead and contribute to implementation of CI/CD flows. </li><li> Tackle a wide variety of technical problems throughout the stack and contribute daily to all parts of our product code base. </li><li>Collaborate with product managers, designers, infrastructure teams, and other stakeholders to develop complex systems. </li><li>Perform code reviews to ensure code quality, adherence to coding standards, and maintainability. </li><li>Monitor the correct implementation of engineering designs and address implementation issues. </li><li>Identify and design solutions for performance bottlenecks across the entire application. </li><li>Identify design and operational improvements to existing applications. </li></ul> </ul>What You'll Need <ul> <ul><li>15+ years of relevant hands-on programming experience. </li><li>Technical leadership experience, leading 6-10 engineers on 6+ months long projects. </li><li>Expert level knowledge in modern programming languages and their ecosystems, including Python, Go Lang, Node.js or similar. </li><li>Extensive experience in Cloud platform architectures, at least one of AWS, GCP or Azure. </li><li>Expertise in multiple types of database and data retrieval technologies including Relational, NoSQL, GraphQL and others. </li><li>Excellent communication skills. </li><li>Excellent skills in developing engineering designs and related documentation. </li>Business Wire will not sponsor a new applicant for employment authorization for this position.What We OfferThe base salary range for this position is $215K to $235K/year. Offered salary will be determined by several factors, including but not limited to: applicant's education, experience, knowledge, skills and abilities, as well as internal equity and alignment with geographic market data. Business Wire reserves the right to modify this salary range at any time.Business Wire's total rewards include: <li>Ability to work remotely </li><li>Excellent health benefits that begin on your first day of employment </li><li>$100 monthly fitness allotment, a tuition reimbursement program, and enhanced mental health resources </li><li>401(k) plan with generous company match, and annual profit sharing contribution (subject to company performance) </li><li>PTO, Floating Holidays, Wellness Day Off, Birthday Day Off, and more! </li></ul> </ul> A pre-employment background check will be required after the acceptance of an offer. Business Wire is proud to be an equal opportunity workplace. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. Pursuant to the San Francisco Fair Chance Ordinance and other similar state laws and local ordinances, and its internal policy, Business Wire will also consider for employment qualified applicants with arrest and conviction records.

Business Wire Interview Questions

Business Wire Interview Guides

Business Wire Interview Questions

Business Wire Salaries by Position

Business Wire Opening Jobs