Prepare for and practice interview questions from Zeta Global.

Zeta Global Interview Questions

Zeta Global Interview Guides

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 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 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?

Zeta Global Salaries by Position

WHO WE ARE Zeta Global (NYSE: ZETA) is the AI-Powered Marketing Cloud that leverages advanced artificial intelligence (AI) and trillions of consumer signals to make it easier for marketers to acquire, grow, and retain customers more efficiently. Through the Zeta Marketing Platform (ZMP), our vision is to make sophisticated marketing simple by unifying identity, intelligence, and omnichannel activation into a single platform - powered by one of the industry's largest proprietary databases and AI. Our enterprise customers across multiple verticals are empowered to personalize experiences with consumers at an individual level across every channel, delivering better results for marketing programs. Zeta was founded in 2007 by David A. Steinberg and John Sculley and is headquartered in New York City with offices around the world. THE ROLE At Zeta Global, we are spearheading innovations in data-driven marketing, leveraging advanced machine learning and AI to deliver unparalleled insights and performance. We are seeking a visionary Senior Product Manager to lead our Machine Learning Operations initiatives, focusing on developing retail-specific models and a user-friendly Model Workbench that empowers marketers to harness the power of Machine Learning without the need for deep technical expertise. Job Description: <ul> <li>Machine Learning Operations Leadership: Spearhead the development and maintenance of robust ML Ops processes to streamline model deployment, monitoring, and management. </li> <li>Retail Model Innovation: Design and refine machine learning models tailored to the retail industry, enhancing our predictive capabilities and market understanding. </li> <li>Model Workbench Development: Lead the creation of a Model Workbench platform that enables marketers to easily interact with and utilize machine learning models, incorporating user-friendly interfaces and tools. </li> <li>Customer-Centric Product Development: Ensure all product development is guided by a deep understanding of customer needs and market demands, delivering solutions that are both intuitive and powerful. </li> <li>Agentic Infrastructure Integration: Work towards integrating traditional ML with advanced generative models, focusing on explainability, actionable recommendations, and recursive training based on user interactions. </li></ul>Requirements: <ul> <li>Experience in Product Management: Proven track record of successful product management, ideally in a technology-focused environment. </li> <li>Expertise in Machine Learning: Strong understanding of ML Ops practices, with experience in developing and managing Machine Learning models, particularly for retail applications. </li> <li>Technical Proficiency: Comfortable working with both traditional and generative machine learning technologies, with a keen insight into model explainability and user interaction. </li> <li>Strategic Thinking: Ability to think strategically about product development, integrating customer insights and market trends into actionable product features. </li> <li>Communication Skills: Excellent communication skills with the ability to collaborate effectively across cross-functional teams and articulate product visions clearly to both technical and non-technical stakeholders. </li><li>Background in Retail Analytics: Direct experience or a strong understanding of the retail industry's data analytics needs. </li> <li>Familiarity with Agentic Infrastructure: Knowledge of combining traditional ML models with generative models to enhance user interaction and model training. </li> </ul>This is a hybrid role based out of our San Francisco office. BENEFITS & PERKS <ul><li>Unlimited PTO </li> <li>Excellent medical, dental, and vision coverage </li> <li>Employee Equity and Stock Purchase Plan </li> <li>Employee Discounts, Virtual Wellness Classes, and Pet Insurance </li> </ul> And more!! COMPENSATION RANGE The compensation range for this role is $140,000 - $170,000 depending on location and experience. PEOPLE & CULTURE AT ZETA Zeta considers applicants for employment without regard to, and does not discriminate on the basis of an individual's sex, race, color, religion, age, disability, status as a veteran, or national or ethnic origin; nor does Zeta discriminate on the basis of sexual orientation, gender identity or expression. We're committed to building a workplace culture of trust and belonging, so everyone feels invited to bring their whole selves to work. We provide a forum for employees to celebrate, support and advocate for one another. Learn more about our commitment to diversity, equity and inclusion here: https://zetaglobal.com/blog/a-look-into-zetas-ergs/ ZETA IN THE NEWS! https://zetaglobal.com/press/?cat=press-releases

WHO WE ARE Zeta Global (NYSE: ZETA) is the AI-Powered Marketing Cloud that leverages advanced artificial intelligence (AI) and trillions of consumer signals to make it easier for marketers to acquire, grow, and retain customers more efficiently. Through the Zeta Marketing Platform (ZMP), our vision is to make sophisticated marketing simple by unifying identity, intelligence, and omnichannel activation into a single platform - powered by one of the industry's largest proprietary databases and AI. Our enterprise customers across multiple verticals are empowered to personalize experiences with consumers at an individual level across every channel, delivering better results for marketing programs. Zeta was founded in 2007 by David A. Steinberg and John Sculley and is headquartered in New York City with offices around the world. THE ROLE At Zeta Global, we are dedicated to maximizing the impact of marketing through data-driven insights. We are seeking a Senior Product Manager to lead the integration and centralization of third-party data insights across our core platforms. This role is crucial for enhancing the accessibility and utility of our Data Cloud product, ensuring that insights are seamlessly embedded into all facets of our digital marketing tools. Job Description: <ul> <li>Data Integration: Spearhead initiatives to integrate third-party insights into first party activations modules of our platform, including campaign building, marketing automation, and audience creation. </li> <li>Centralization of Insights: Develop strategies to centralize data reports and insights, making them easily accessible and interpretable within the core platform. </li> <li>Insight Distribution: Ensure that key insights are effectively distributed at valuable points in the user journey, enhancing decision-making and marketing effectiveness. </li> <li>Platform Consolidation: Work towards consolidating sections of the platform to include inline insights, thereby enhancing user experience and platform efficiency. </li> <li>Cross-functional Collaboration: Collaborate with offshore teams to align them with best practices in data management and integration. Foster a culture of patience and continuous improvement. </li> <li>Stakeholder Engagement: Engage with internal and external stakeholders to gather requirements, feedback, and align the product development with business goals. </li></ul>Requirements: <ul> <li>Experience in Product Management: Proven track record of managing and successfully rolling out digital products, especially those involving complex data integrations. </li> <li>Technical Proficiency: Strong understanding of data architecture, APIs, and systems integration. Experience with marketing technologies is highly preferred. </li> <li>Strategic Thinking: Ability to devise strategic solutions that merge technical possibilities with business objectives. </li> <li>Communication Skills: Excellent communication abilities with a knack for explaining complex data concepts in clear terms to diverse audiences. </li> <li>Leadership and Collaboration: Experienced in leading cross-functional teams and working with offshore development teams. Must be adept at navigating cultural differences and aligning dispersed teams with company objectives. </li><li>Background in Data Science or Analytics: A strong grasp of data analytics and its application in marketing to drive decision-making and product enhancements. </li> <li>Experience in Digital Marketing: Understanding of digital marketing workflows including campaign management, audience segmentation, and marketing automation. </li> </ul>This is a hybrid role based out of our New York office. BENEFITS & PERKS <ul><li>Unlimited PTO </li> <li>Excellent medical, dental, and vision coverage </li> <li>Employee Equity and Stock Purchase Plan </li> <li>Employee Discounts, Virtual Wellness Classes, and Pet Insurance </li> </ul> And more!! COMPENSATION RANGE The compensation range for this role is $140,000 - $170,000 depending on location and experience. PEOPLE & CULTURE AT ZETA Zeta considers applicants for employment without regard to, and does not discriminate on the basis of an individual's sex, race, color, religion, age, disability, status as a veteran, or national or ethnic origin; nor does Zeta discriminate on the basis of sexual orientation, gender identity or expression. We're committed to building a workplace culture of trust and belonging, so everyone feels invited to bring their whole selves to work. We provide a forum for employees to celebrate, support and advocate for one another. Learn more about our commitment to diversity, equity and inclusion here: https://zetaglobal.com/blog/a-look-into-zetas-ergs/ ZETA IN THE NEWS! https://zetaglobal.com/press/?cat=press-releases

WHO WE ARE Zeta Global (NYSE: ZETA) is the AI-Powered Marketing Cloud that leverages advanced artificial intelligence (AI) and trillions of consumer signals to make it easier for marketers to acquire, grow, and retain customers more efficiently. Through the Zeta Marketing Platform (ZMP), our vision is to make sophisticated marketing simple by unifying identity, intelligence, and omnichannel activation into a single platform - powered by one of the industry's largest proprietary databases and AI. Our enterprise customers across multiple verticals are empowered to personalize experiences with consumers at an individual level across every channel, delivering better results for marketing programs. Zeta was founded in 2007 by David A. Steinberg and John Sculley and is headquartered in New York City with offices around the world. THE ROLE Staff Software Engineer wanted in San Francisco, CA to Architect, develop and own the Company's Marketing Platform <ul> <li>Collaborate with engineers, product managers and executives to develop a roadmap </li><li>Build the next generation comprehensive, multichannel marketing solution that unifies and unlocks data across digital touch points, driving return on marketing investment </li><li>Design and develop the Platform Work on technology that enables access to core of CRM and Data Cloud efforts. Use knowledge of distributed systems and cloud architecture. </li><li>Use knowledge of distributed systems and cloud architecture. Balance production features. Support, feature delivery, and retirement of technical debt. </li><li>Build self-healing services with robust error handling. </li><li>Design and operate resilient distributed systems that run across hundreds of compute nodes in multiple data centers. </li><li>Drive and deliver thin slices of end-to-end functionality on a regular cadence with data-driven feedback loops. </li><li>Use programming skills with specific focus on parallel and multithreaded programming. Use multi-tenant architectures (IaaS, PaaS, SaaS), RESTful web-services, Microservices, Big Data technologies (e.g. HBase, Spark, Elasticsearch) in building real-time data pipelines and streaming applications (e.g. Kafka, Amazon Kinesis) that scale horizontally. </li><li>Use knowledge of NoSQL databases such as Aerospike, data warehouses such as Snowflake/ ClickHouse/Redshift on one or more of the Clouds like AWS, Azure or GCP. </li><li>Use graph Database as well as big data formats (Parquet, ORC). </li></ul>Option to telecommute two days a week. Bachelor's degree in Mechanical Engineering, Computer Engineering or Computer Science plus 5 years of experience in job offered or similar occupation Salary expectations: $220,320/yr Send resume to: G Avanzato, Zeta Global Corp., 3 Park Avenue, 33rd Floor, New York, NY 10016. BENEFITS & PERKS <ul><li>Unlimited PTO </li> <li>Excellent medical, dental, and vision coverage </li> <li>Employee Equity and Stock Purchase Plan </li> <li>Employee Discounts, Virtual Wellness Classes, and Pet Insurance </li> </ul> And more!! PEOPLE & CULTURE AT ZETA Zeta considers applicants for employment without regard to, and does not discriminate on the basis of an individual's sex, race, color, religion, age, disability, status as a veteran, or national or ethnic origin; nor does Zeta discriminate on the basis of sexual orientation, gender identity or expression. We're committed to building a workplace culture of trust and belonging, so everyone feels invited to bring their whole selves to work. We provide a forum for employees to celebrate, support and advocate for one another. Learn more about our commitment to diversity, equity and inclusion here: https://zetaglobal.com/blog/a-look-into-zetas-ergs/ ZETA IN THE NEWS! https://zetaglobal.com/press/?cat=press-releases

WHO WE ARE Zeta Global (NYSE: ZETA) is the AI-Powered Marketing Cloud that leverages advanced artificial intelligence (AI) and trillions of consumer signals to make it easier for marketers to acquire, grow, and retain customers more efficiently. Through the Zeta Marketing Platform (ZMP), our vision is to make sophisticated marketing simple by unifying identity, intelligence, and omnichannel activation into a single platform - powered by one of the industry's largest proprietary databases and AI. Our enterprise customers across multiple verticals are empowered to personalize experiences with consumers at an individual level across every channel, delivering better results for marketing programs. Zeta was founded in 2007 by David A. Steinberg and John Sculley and is headquartered in New York City with offices around the world. THE ROLE Data Analyst wanted in Boca Raton, FL to build tableau reports that are accurate, modular, and easy to maintain. <ul><li>Help locate potential problems and opportunities that the sales and operations team can use to improve performance</li><li>Write performant SQL queries from large datasets.</li><li>Perform statistical analysis on the performance of offers, marketing campaigns, and websites</li><li>Provide advice on ways to increase revenue or decrease costs.</li><li>Write technical and explanatory documentation on data operations.</li><li>Assist data and operation analysts in writing ad hoc queries.</li><li>Anticipate reporting requests that are related to each other and include dimensions that are related in reporting.</li><li>Use experience with large (TB) complex data sets and relational databases</li><li>Use advanced SQL (CTE, window functions, cube aggregations); tableau and similar BI tools; Python and programming experience; Git; Spark; CI/CD;NoSQL; Data Warehouse (Snowflake, Redshift, Big Query) and Prefect.</li><li>Use graph Database as well as big data formats (Parquet, ORC).</li></ul> Option to telecommute three days a week. Bachelor's degree in Engineering Management or Computer Science plus 2 years of experience in the job offered or similar occupation Salary expectations: $105,000/yr Send resume to: G Avanzato, Zeta Global Corp., 3 Park Avenue, 33rd Floor, New York, NY 10016. BENEFITS & PERKS <ul><li>Unlimited PTO </li><li>Excellent medical, dental, and vision coverage </li><li>Employee Equity and Stock Purchase Plan </li><li>Employee Discounts, Virtual Wellness Classes, and Pet Insurance </li></ul> And more!! PEOPLE & CULTURE AT ZETA Zeta considers applicants for employment without regard to, and does not discriminate on the basis of an individual's sex, race, color, religion, age, disability, status as a veteran, or national or ethnic origin; nor does Zeta discriminate on the basis of sexual orientation, gender identity or expression. We're committed to building a workplace culture of trust and belonging, so everyone feels invited to bring their whole selves to work. We provide a forum for employees to celebrate, support and advocate for one another. Learn more about our commitment to diversity, equity and inclusion here: https://zetaglobal.com/blog/a-look-into-zetas-ergs/ ZETA IN THE NEWS! https://zetaglobal.com/press/?cat=press-releases

WHO WE ARE Zeta Global (NYSE: ZETA) is the AI-Powered Marketing Cloud that leverages advanced artificial intelligence (AI) and trillions of consumer signals to make it easier for marketers to acquire, grow, and retain customers more efficiently. Through the Zeta Marketing Platform (ZMP), our vision is to make sophisticated marketing simple by unifying identity, intelligence, and omnichannel activation into a single platform - powered by one of the industry's largest proprietary databases and AI. Our enterprise customers across multiple verticals are empowered to personalize experiences with consumers at an individual level across every channel, delivering better results for marketing programs. Zeta was founded in 2007 by David A. Steinberg and John Sculley and is headquartered in New York City with offices around the world. THE ROLE Data Analyst wanted in Boca Raton, FL to build tableau reports that are accurate, modular, and easy to maintain. <ul> <li>Help locate potential problems and opportunities that the sales and operations team can use to improve performance </li><li>Write performant SQL queries from large datasets. </li><li>Perform statistical analysis on the performance of offers, marketing campaigns, and websites </li><li>Provide advice on ways to increase revenue or decrease costs. </li><li>Write technical and explanatory documentation on data operations. </li><li>Assist data and operation analysts in writing ad hoc queries. </li><li>Anticipate reporting requests that are related to each other and include dimensions that are related in reporting. </li><li>Use experience with large (TB) complex data sets and relational databases </li><li>Use advanced SQL (CTE, window functions, cube aggregations); tableau and similar BI tools; Python and programming experience; Git; Spark; CI/CD;NoSQL; Data Warehouse (Snowflake, Redshift, Big Query) and Prefect. </li><li>Use graph Database as well as big data formats (Parquet, ORC). </li></ul>Option to telecommute three days a week. Bachelor's degree in Engineering Management or Computer Science plus 2 years of experience in the job offered or similar occupation Salary expectations: $105,000/yr Send resume to: G Avanzato, Zeta Global Corp., 3 Park Avenue, 33rd Floor, New York, NY 10016. BENEFITS & PERKS <ul><li>Unlimited PTO </li> <li>Excellent medical, dental, and vision coverage </li> <li>Employee Equity and Stock Purchase Plan </li> <li>Employee Discounts, Virtual Wellness Classes, and Pet Insurance </li> </ul> And more!! PEOPLE & CULTURE AT ZETA Zeta considers applicants for employment without regard to, and does not discriminate on the basis of an individual's sex, race, color, religion, age, disability, status as a veteran, or national or ethnic origin; nor does Zeta discriminate on the basis of sexual orientation, gender identity or expression. We're committed to building a workplace culture of trust and belonging, so everyone feels invited to bring their whole selves to work. We provide a forum for employees to celebrate, support and advocate for one another. Learn more about our commitment to diversity, equity and inclusion here: https://zetaglobal.com/blog/a-look-into-zetas-ergs/ ZETA IN THE NEWS! https://zetaglobal.com/press/?cat=press-releases

Zeta Global Interview Questions

Zeta Global Interview Guides

Zeta Global Interview Questions

Zeta Global Salaries by Position

Zeta Global Opening Jobs