Data Analyst

New York, NY

Condé Nast is home to Wired, Vogue, GQ, The New Yorker, Vanity Fair and more of the world's most celebrated brands. Condé Nast Entertainment (CNE) develops, produces and distributes video content across all of these brands. Our team creates high quality video programming experiences for viewers across every screen, and is led by industry veterans who have built video businesses with billions of monthly views. Since its inception in 2011, CNE has grown rapidly and has an extensive digital distribution network, with more than 37 million subscribers on Youtube and ranks in the top 20 in unique viewers in comScore's Top 100 Properties.

New York, NYData Analyst and Spreadsheet Specialist Manager, Production Management Operations

The Production Management team is seeking a Data Analyst and Spreadsheet Specialist Manager, Production Management Operations, to help us build out, manage, and maintain our data reporting & production systems infrastructure as it relates to Production Management, expense reporting, and cost reporting. They must be well versed in video Production and technology. This person will be collaborative with their counterparts in other departments and will be key in providing the Senior Director and Executive Director, Production, and senior management, with the insights necessary to make the most confident and informed decisions. This data is also shared with other CNE departments and CNE leadership.

This role is based in New York and will report to the Director, Production Management.

PRIMARY RESPONSIBILITIES:

This role will oversee the maintenance, implementation, and socialization of data tools and systems aiding in the collection and dissemination of information related to video production cost tracking and any ancillary production reporting
Maintain, update, and troubleshoot technical issues on existing suite of spreadsheets and databases in Production Management department
Implement new data reporting structures as required to align with department’s fiscal reporting schedules
Build, format, and code multiple relational spreadsheets and databases in Google and Excel for tracking and importing costs and production data from both internal and external source documents
Ensure Production Management Operations deliverables for cost tracking reports meet our weekly reporting deadlines
Ensure the overall accuracy, completeness, and consistency of data
Supervise a Coordinator in the day-to-day maintenance and creation of spreadsheets and oversee their work assignments
Train new team members on production systems, enforcing data collection and warehousing best practices within the Production organization
Work cross-functionally with other departments to ensure our systems, data, & workflows are compatible company-wide, and generate reports based on that data for stakeholders both inside and outside of the Production organization.
Identify strategic opportunities to streamline and optimize production processes to more effectively track, manage, or report on data and status.
Act as day-to-day point-of-contact within the Production Management team for all matters pertaining to database and system needs and initiatives.
Ensuring industry-standard lexicography is used consistently within all production systems, documentation, and reporting.
Responsible for coordinating all documentation and communications around these systems, best practices, and changes.
Create presentations and info graphic reports based on data workflow management

EXPERIENCE & SKILLS REQUIRED:

Bachelor’s Degree preferred, or equivalent work experience is required.
3+ years experience in a data management role in a video production or relative media industry is required
Experience and proficiency in Excel and Google Workspace applications, primarily Google Sheets, with ability to build and code multiple spreadsheets is required
Familiar with the financial aspects of production including budgeting, purchase orders, reconciling financials, and cost reporting is a plus
Strong comfortability working with numbers and discussing money / spend
Intermediate-level fluency in SQL data query language is required, and higher is preferred.
Intermediate-level technical understanding of relational databases is required.
Certification in data management or equivalent computer science is preferred
Possess a keen attention to detail, and superior organizational skills/abilities
Strong interpersonal skills are required - the ideal candidate is a diplomatic problem-solver who brings recommendations and solutions to the table.

The expected base salary range for this position is from $60,000 -$80,000. Salary offers are based on a wide range of factors including but not limited to relevant skills, training, experience, and education. In addition to salary and a generous employee benefits package, successful candidates may also be eligible to receive discretionary bonus compensation.

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

Duties and responsibilities may be adjusted based on years of experience.

Salary is also commensurate with experience

What happens next?

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.