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

Zoetis Business Intelligence Interview Guide

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


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

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

Overview

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

Zoetis 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 show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).</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>products</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>price</code></td>
<td>FLOAT</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>

<tr>
<td><code>sex</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>month</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_customers</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_orders</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>order_amt</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Monthly Customer Report

<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

Zoetis Business Intelligence Interview Questions

<p><b>Role Description</b> </p><p> </p><p><b>Who you are:</b> </p><p>An experienced Product manager, excited to join a growing organization (under the umbrella of a larger pet health and pharmaceutical company) during a key stage of growth, leading our vision for the post-purchase customer journey, engagement, repeat purchases, and retention. </p><p>You are passionate and knowledgeable about consumer technology products, have a deep empathy for user problems, create impactful GTM and communication plans, lead product development from ideation to launch, and empower our business to build the right products to improve the customer experience and hit our ambitious growth and scaling targets. You have experience with consumer technology products, where digital experiences are a key component of your product. </p><p>You demonstrate leadership, product, technical, and design expertise, and executional excellence in building technical solutions to complex and ambiguous business problems. This is a strategic ownership role, reporting to the Precision Animal Health (PAH) leadership team through the Head of Digital Experience. The role owns the product delivery experience across the full companion portfolio for genetics, and is a strategic and visionary leader on the Product team. </p><p><b>Core responsibilities</b>: </p><p>* Independent ownership of the full consumer lifecycle post-purchase from a Product and Technology perspective; in partnership with key stakeholders across Engineering, Science / R&D, and Marketing, this role is responsible and accountable for the post-purchase lifecycle(key to realizing revenue) </p><p>o Own the process for defining and documenting technical requirements for consumer Engineering products (end-to-end ownership of the Software Development Lifecycle, from research through to test analysis); you are equally at home performing customer research, writing functional specifications, and analyzing A/B test results </p><p>o Controls the deployment and prioritization of Engineering / Technology resources to unlock key business objectives relative to technical cost, complexity, and design goals </p><p>o Effectively aligns and informs Engineering and Design approach, finding common ground in terms of business impact / revenue, technical cost / complexity, and consumer experience </p><p>o Creates product requirements and associated documentation, including business case/ROI modeling and rationale, success metrics, acceptance criteria, testing requirements, exit/release planning, and GTM (go-to-market) support, tracking post-release success metrics and maintaining product backlogs and technical roadmaps </p><p>* Strong technical analytical skillset and experience (you know at least one coding language, like SQL, Python, R, etc.), and live and breathe data-driven testing roadmaps to unlock significant growth; you can perform independent data analysis (writing your own SQL query is a common occurrence) and look beyond data analysis results to see the business opportunity and the ‘so what‘ behind that data, effectively narrating at the right altitude up to the Executive level </p><p>o This role will have exposure to deploying this skillset against competitive / market analysis, customer and digital behavioral analysis, customer segmentation, financial upside modeling, etc. </p><p>o You are able to discuss test results with analytical resources while also understanding how to summarize high-level learnings for more senior audiences </p><p>* You do the above while keeping cross-functional stakeholders updated, informed, and aligned for complex, ambiguous efforts across multiple functions (Marketing, Science, R&D, Engineering, and Operations); you are a natural at project management effectiveness and have manage projects of significant ambiguity and complexity across distinct functions </p><p>* Alongside Marketing and Design, you are a key driver of customer research to identify user lifecycle opportunities, customer pain points, UX/UI optimization, brand resonance, etc. - you are an active participant in defining the strategic objectives of Consumer Research and also able to perform and analyze results </p><p> </p><p><b>What we need:</b> </p><p>* 6+ years of professional experience with Product Management, or Technical Project Management, for Consumer Technology or Animal Health companies, owning end-to-end projects and/or product lifecycles </p><p>o 10+ years in profession experience in consumer business roles of increasing scope, leadership and seniority; or 8+ years of professional experience plus a professional / advanced degree </p><p>* Technical expertise and an understanding of how to harness digital technologies to support a roadmap to influence key metrics around report delivery, engagement, and consumer retention </p><p>* Past experience building strategic and technical product roadmaps, testing plans and experiment roadmaps, to learn about optimization opportunities for conversion funnels and engagement tactics </p><p>* Experience leading customer research, market research, defining and measuring product lifecycle KPIs and metrics </p><p>* Strong analytical skills (SQL and Excel required, Python preferred) with demonstrated capabilities interpreting data and qualitative research and distilling into actionable takeaways </p><p>* Excellent collaborative skills and ability to work cross-functionally with a diverse group of stakeholders </p><p>* A story teller with with excellent verbal and written communication skills and ability to make customers fall in love with our product </p><p><b>What you‘ll do:</b> </p><p>* You will play an integral role in defining product strategy, roadmap, go-to-market strategies, product marketing, and product development informed by customer research, market insights, and product understanding </p><p>* Key partner for Marketing, Science/R&D, and Engineering including key activities and budgets to support the full consumer lifecycle </p><p>* Own experimentations and tests for existing and new products </p><p>* Independently conduct data analysis (using SQL and Excel daily) to identify performance drivers and key insights to assist in prioritization of strategic roadmaps for product lifecycle opportunities. </p><p>* Lead product ideation, strategic planning, tactical initiatives, product vision, product strategy, consumer research and insights, product roadmap, product design, product development, management of day-to-day software lifecycle, and product GTM throughout the product development lifecycle </p>Full time Regular Colleague <p>Any unsolicited resumes sent to Zoetis from a third party, such as an Agency recruiter, including unsolicited resumes sent to a Zoetis mailing address, fax machine or email address, directly to Zoetis employees, or to Zoetis resume database will be considered Zoetis property. Zoetis will NOT pay a fee for any placement resulting from the receipt of an unsolicited resume. </p><p>Zoetis will consider any candidate for whom an Agency has submitted an unsolicited resume to have been referred by the Agency free of any charges or fees. This includes any Agency that is an approved/engaged vendor but does not have the appropriate approvals to be engaged on a search. </p>Zoetis is committed to equal opportunity in the terms and conditions of employment for all employees and job applicants without regard to race, color, religion, sex, sexual orientation, age, gender identity or gender expression, national origin, disability or veteran status or any other protected classification. Disabled individuals are given an equal opportunity to use our online application system. We offer reasonable accommodations as an alternative if requested by an individual with a disability. Please contact Zoetis Colleague Services at to request an accommodation. Zoetis also complies with all applicable national, state and local laws governing nondiscrimination in employment as well as employment eligibility verification requirements of the Immigration and Nationality Act. All applicants must possess or obtain authorization to work in the US for Zoetis. Zoetis retains sole and exclusive discretion to pursue sponsorship for the acquisition or maintenance of nonimmigrant status and employment eligibility, considering factors such as availability of qualified US workers. Individuals requiring sponsorship must disclose this fact. Please note that Zoetis seeks information related to job applications from candidates for jobs in the U.S. solely via the following: (1) our company website at www.Zoetis.com/careers site, or (2) via email to/from addresses using only the Zoetis domain of ‘@zoetis.com‘. In addition, Zoetis does not use Google Hangout for any recruitment related activities. Any solicitation or request for information related to job applications with Zoetis via any other means and/or utilizing email addresses with any other domain should be disregarded. In addition, Zoetis will never ask candidates to make any type of personal financial investment related to gaining employment with Zoetis.

Zoetis Business Intelligence Interview Guide

Overview

Zoetis Business Intelligence Salary

Zoetis Business Intelligence Interview Process

Zoetis Business Intelligence Interview Questions

Zoetis Business Intelligence Jobs