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 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>Write a query to identify the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

<p><strong>Example:</strong></p>

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

<p><code>employees</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>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</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>team</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>manager</code></td>
<td>VARCHAR</td>
</tr>

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


Manager Team Sizes

Zoetis Business Intelligence Interview Questions

<p>Role Description</p><p>Who you are:</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>Core responsibilities:</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>What we need:</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>What you'll do:</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><p>Full time</p><p>Regular</p><p>Colleague</p><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><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 zoetiscolleagueservices@zoetis.com 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.</p>

<p>States considered:</p><p>Principal Scientist, Mathematical and Biological Modeling Data Scientist</p><p>Zoetis is a global animal health company dedicated to nurturing our world and humankind by advancing care for animals. We strive to create an atmosphere where colleagues feel valued and supported, can give their best every day, and are proud of the company where they work. Building on 70+ years of experience, our scientists help pets live longer, healthier lives, and support healthier, more productive livestock. We are committed to discovering and developing solutions that span a continuum of care to predict, prevent, detect, and treat disease in animals while championing a more sustainable future and creating a healthier world for all.</p><p>As the leader in animal health, Zoetis is looking to recruit a Mathematical and Biological Modeling Data Scientist into its world-class Veterinary Medicine Research and Development organization (VMRD). The candidate will join the In Silico Research team within Automation & Data Sciences (ADS) to execute the development and implementation of various modeling and digital twin projects. This role will build upon ADS's industry leading In Silico Research group and help define the next generation of therapeutic, vaccine, and/or diagnostic evaluation and testing methods at Zoetis.</p><p>The successful candidate will have a proven track record in data science applications within the bio/pharmaceutical industry, with special emphasis on mathematical modeling, digital twin simulations, and domain transfer. The candidate will have experience implementing differential equation, machine learning and AI models for therapeutic development, comparing results between multiple data and testing domains, and implementing analytics for digital twin applications to provide accurate simulation. Example applications may include in silico drug screening, predictive modeling, bioprocessing simulation, and manufacturing. The candidate will work in a team setting and will share roles and responsibilities with other colleagues. The candidate should display strong communication skills with biologists, chemists, technicians, and data scientists.</p><p>Essential Duties and Responsibilities:</p><p>* Work with teams throughout VMRD to understand and evaluate mathematical modeling and digital twin project opportunities.</p><p>* Evaluate the appropriateness of different datasets and mathematical approaches for a given project.</p><p>* Research and identify external digital twin technologies and methods to best incorporate them internally.</p><p>* Evaluate accuracy and specificity of digital twin and mathematical modeling projects on internal data.</p><p>* Collaborate with colleagues across the organization, including other data scientists, therapeutic/vaccine project and functional teams, biologists, chemists, and our Zoetis Tech & Digital (ZTD) organization.</p><p>Required Experience/ Skills</p><p>* PhD in mathematics, computational biology, biology, or chemistry with an emphasis in modeling, or a related field.</p><p>* Experience in biology, computer science, and mathematical modeling.</p><p>* Digital twin development or mathematical modeling and evaluation, specifically in biological, chemical, or related applications.</p><p>* Implementation of machine learning and AI methods in biologically related projects</p><p>* Programming across multiple programming languages, e.g., Python, R, Julia, C/C++.</p><p>Additional Experience/ Skills</p><p>* Cellular automata, agent-based modelling, finite-state machines, dynamical systems.</p><p>* Graph theory, algorithms, and network analysis</p><p>* Experience in pharmaceutical research such as disease and therapeutic mechanism of action, delivery, or development.</p><p>Job Type</p><p>* Full-time, remote, or on-site in Fort Collins, CO or Kalamazoo, MI.</p><p>* Work hours adjusted to time zones between US Eastern to US Pacific time zones.</p><p>The following base pay range reflects the anticipated base pay for this position if a selected candidate were to be located in (Colorado). Base pay may vary based on location and other factors.</p><p>Base Pay Range: $108,000K - $155,000K</p><p>[This position is eligible for short-term incentive compensation.] [The position is also eligible for long-term incentive.]</p><p>Full time</p><p>Regular</p><p>Colleague</p><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><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 zoetiscolleagueservices@zoetis.com 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.</p>

Zoetis Business Intelligence Interview Guide

Overview

Zoetis Business Intelligence Salary

Zoetis Business Intelligence Interview Process

Zoetis Business Intelligence Interview Questions

Zoetis Business Intelligence Jobs