Prepare for and practice interview questions from Weber Shandwick.

Weber Shandwick Interview Questions

Weber Shandwick Interview Guides

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

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Weber Shandwick Salaries by Position

Data Engineer, Engineer, Lead, Technology, Business Services

Weber Shandwick is seeking a Data Engineer with 5+ years of experience building and maintaining data pipelines, databases, and processing systems. The ideal candidate will have strong proficiency in Python and have extensive experience developing sophisticated data pipelines using Apache Airflow and Kubernetes for large scale-tasks. The successful candidate will be responsible for developing, testing, and maintaining architectures, including databases and large-scale processing systems. They will also be expected to recommend and implement ways to improve data reliability, efficiency, and quality. This role requires a high level of creativity and attention to detail, as well as excellent communication skills. Key Requirements: <ul><li>5+ years of experience as a Data Engineer using proven, industry-leading cloud platforms, specifically within AWS.</li><li>Proficiency in Python using Pandas Dataframes.</li><li>Experience developing sophisticated data pipelines using Apache Airflow.</li><li>Familiarity with container orchestration systems like Kubernetes and using Kubernetes within Apache Airflow for large scale tasks.</li><li>Experience with UI work using Python frameworks like Streamlit, Flask or similar.</li><li>Excellent written and spoken communication skills.</li><li>Ability to conduct independent work and manage projects from beginning to end.</li></ul> Preferred Qualifications: <ul><li>Relevant AWS certifications.</li><li>Experience with social media data and APIs.</li><li>Working knowledge of BI platforms such as Domo, Tableau, Power BI, Qlik, etc.</li><li>Experience working in an agency.</li></ul> The Weber Shandwick Collective recognizes that your health and wellbeing are a priority. This is why we offer a full suite of benefits including: <ul><li>Medical</li><li>Dental</li><li>Vision</li><li>401k (with employer match)</li><li>Tuition Reimbursement</li><li>Juice Money - $60 monthly reimbursement to be used towards purchases that nourish your health, mind, body, and soul</li><li>MyDays - Flexible holiday schedules </li><li>Short-Term Disability </li><li>Paid Employee Family Leave </li><li>Family Building Benefit</li></ul> NYC Salary range: $115,000 - $140,000 Where an employee or prospective employee is paid within this range will depend on, among other factors, actual ranges for current/former employees in the subject position; market considerations; budgetary considerations; tenure and standing with the company (applicable to current employees); as well as the employee's/applicant's background, pertinent experience, and qualifications. Weber Shandwick is proud to be an Equal Opportunity/Affirmative Action employer. Weber Shandwick recruits qualified applicants without regard to race, color, religion, gender, age, ethnic or national origin, protected veteran status, physical or mental disability, sexual orientation, gender identity, marital status or citizenship status. #LI-JR2 We make our careers website accessible to any and all users. If you need an accommodation to participate in the application process, please contact us at JobAppAccommodation@ipgdxtra.com. This email address is not for general employment inquiries or vendors; rather it is strictly for applicants who require special assistance accessing our employment website. Due to volume, messages sent to this email address that are not related to an accommodation cannot be answered.

Weber Shandwick Interview Questions

Weber Shandwick Interview Guides

Weber Shandwick Interview Questions

Weber Shandwick Salaries by Position

Weber Shandwick Opening Jobs