Prepare for and practice interview questions from Condé Nast.

Condé Nast Interview Questions

Condé Nast 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

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

Condé Nast Salaries by Position

Conde Nast is a global media company producing the highest quality content with a footprint of more than 1 billion consumers in 32 territories through print, digital, video and social platforms. The company's portfolio includes many of the world's most respected and influential media properties including Vogue, Vanity Fair, Glamour, Self, GQ, The New Yorker, Conde Nast Traveler/Traveller, Allure, AD, Bon Appetit and Wired, among others. Job Description Location: New York, NY Senior Business Intelligence Engineer wanted by Advance Magazine Publishers Inc. d/b/a Conde Nast in New York, New York. Promote and grow Business Intelligence (BI) footprint at Conde Nast. Liaise with Data Engineering team to architect solutions. Work with Business stakeholders to promote the benefits of the platform and try to solve business problems. Teach, train, and help grow the skill set of BI developers on the team. Recommend enhancements to the BI Data Warehousing for performance improvement; and establish and maintain communication with internal business partners. Requires: Master's degree in Computer Science, Data Science, Information Technology, or closely related and 1 year in the job offered or as Senior BI Developer using Qlik Sense and nprinting, or Bachelor's degree in same fields, or closely related and 5 years post-baccalaureate progressive experience in the field, which includes 1 year in the job offered or as a Senior BI Developer using Qlik Sense and nprinting, or any suitable combination of education, training or experience. Salary $157,768 per year. Send resume: HR, Attn. Naomi Castillo, 34th floor, Advance Magazine Publishers Inc. dba Conde Nast, 1 World Trade Center, New York, NY 10007or apply online athttps://www.condenast.com/careers. Refer to job code: R-16800 What happens next? If you are interested in this opportunity, please apply below, and we will review your application as soon as possible. You can update your resume or upload a cover letter at any time by accessing your candidate profile. Conde Nast is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, age, familial status and other legally protected characteristics.

Cond Nast is a global media company producing the highest quality content with a footprint of more than 1 billion consumers in 32 territories through print, digital, video and social platforms. The company's portfolio includes many of the world's most respected and influential media properties including Vogue, Vanity Fair, Glamour, Self, GQ, The New Yorker, Cond Nast Traveler/Traveller, Allure, AD, Bon Apptit and Wired, among others. Job Description Location: New York, NY About the company: Cond Nast is a global media company, home to iconic brands including Vogue, GQ, Glamour, AD, Vanity Fair and Wired, among many others. Our award-winning content reaches 84 million consumers in print, 367 million in digital and 379 million across social platforms, and generates more than 1 billion video views each month. We are headquartered in London and New York, and operate in 31 markets worldwide, including China, France, Germany, India, Italy, Japan, Mexico & Latin America, Spain,Taiwan, the U.K. and the U.S., with local licence partners across the globe. About the role: Cond Nast Data Products Team is seeking an experienced Customer Data Platform Product Manager to lead the development of our customer data platform that supports consumer revenue teams in the US. The role owns the running of the customer data platform and will partner and collaborate with Consumer Revenue Teams in the US. The person will also train various teams on platform utilization and manage best practice communication and guidelines. This is an important role in Cond Nast's data products team and will support the data capabilities across the company's business groups, with a focus on enabling its customer centric approach and multi channel campaign orchestration. In addition to ROI-driven digital marketing acumen, the ideal candidate needs to have an understanding of customer facing businesses and to be data fluent. Our focus is to jump start our data-driven activities in both digital marketing and eCommerce, leveraging on our wide customer data points, to ensure our interactions with customers through our marketing channels are consistent and personalized. Responsibilities: <ul> <li>Own ActionIQ customer data platform development for US brands, be an evangelist for its value proposition, promote new features, communicate to internal stakeholders </li><li>Own segment QA for any new data sets or use cases for marketing campaigns </li><li>Train marketing teams to use the platform and be first point of contact for platform usage questions </li><li>Serve as a liaison between the Consumer Marketing and Data Engineering to ensure that all requirements are documented, understood and delivered </li><li>Create and communicate platform implementation documentation and customer data best practice guides and distribute to US marketing teams; partner with US Consumer Marketing team on overall best practice and customer journey strategy. </li><li>Contribute to the creation of a robust segmentation and testing strategy aimed at personalizing the consumer experience (consumer teams will own the customer journey strategy and segmentation criteria) </li><li>Ensure testing and optimization plans are in place to drive demonstrable impact on revenue performance goals </li><li>Work with Business Intelligence, Data Engineering, Data Science and other cross functional teams to define requirements for data and analytics solutions </li><li>Ensure that business goals are met and allow us to reveal powerful usage insights and drive strategic decision-making for customers and the industry </li><li>Understand consumer privacy regulations like CCPA and work with legal, engineering and marketing teams to ensure that consent and permissions are updated in the platform when needed </li><li>Build a relationship with CDP provider/ActionIQ ensuring constant learning and best practices are available for sharing with US teams </li></ul>Key Experiences/Achievements/Requirements: <ul> <li>You are a thought leader, passionate about technology who can dive into the details, creative in coming up with new solutions and able to execute on delivering uniquely challenging projects. </li><li>Experience leading projects across large matrix organizations, ideally in the implementation of ActionIQ Customer Data Platform. </li><li>Minimum 5 years experience in data driven CRM teams, digital marketing or CRM analytics </li><li>Cultivate a continuous learning environment within the team and analytics community through persistent development of new skills and sharing of knowledge through mentorships and contributions to the open source community </li><li>Not afraid to take a deep dive into metrics and data whether it's to diagnose a problem, evaluate a solution or propose a new KPI. You have experience using analytics tools and querying data tables with basic SQL. </li><li>Experience with project management software like Jira or Confluence </li><li>You have a good understanding of CDPs and related technologies, such as data management platforms, data lakes, and marketing automation tools. </li><li>Organized, collaborative, and structured approach to managing project ambiguity, complexity, and interdependencies across global systems/teams </li><li>Must have a 'can do' attitude with an entrepreneurial mindset and be comfortable working in a fast paced, unstructured environment </li><li>Ability to collaborate with business unit leadership as well as individual members of the team with strong empathy, and ability to creatively problem solve </li><li>Can manage multiple stakeholders and have clear understanding of converting data to business value </li><li>Excellent communication and project management skills, have the ability to manage timelines across multiple teams and more importantly, always manage expectations. You are highly analytical and able to demonstrate past examples where you have utilized customer insight to inform strategy changes. </li><li>Experience in a digital subscriptions-led business and/or in publishing would be a plus. </li></ul> The expected base salary range for this position is from $101,000 - $130,000. Salary offers are based on a wide range of factors including but not limited to relevant skills, training, experience, and education. #LI-RK1 What happens next? If you are interested in this opportunity, please apply below, and we will review your application as soon as possible. You can update your resume or upload a cover letter at any time by accessing your candidate profile. Cond Nast is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, age, familial status and other legally protected characteristics.

Condé Nast Interview Questions

Condé Nast Interview Guides

Condé Nast Interview Questions

Condé Nast Salaries by Position

Condé Nast Opening Jobs