Lead, Video Production Data & Reporting

Advance Magazine Publishers Inc.; World Trade Center (NY); Hybrid; USD 75,000 - 79,000; Full time

Job summary

Condé Nast in New York seeks an Associate Manager, Video Production Data & Reporting to build and maintain data reporting systems for production workflows and cost reporting. They must organize large datasets, code spreadsheets, and deliver reporting for executive oversight. This guild position requires strong data management and advanced Google Sheets/Airtable skills.

The role covers payroll coverage, budgeting support, and maintaining editorial video production data integrity across platforms.

Qualifications

• College Degree, or Certification in data management with equivalent work experience.
• 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.
• Experience and proficiency in Airtable applications.
• Familiar with the financial aspects of production including budgeting, purchase orders, reconciling financials, and cost reporting is a plus.
• Intermediate-level technical understanding of relational databases is required.
• Possess a keen attention to detail, and superior organizational skills/abilities.
• Strong interpersonal skills are required.
• Ideal Candidate must be highly organized, extremely detail-oriented, and efficient.
• Ideal Candidate must work well under pressure to meet deadlines.
• Ideal Candidate must have professional and effective communication skills.

Responsibilities

• Day-to-day responsibilities include ensuring all existing data warehouses and reports are up-to-date, working under the supervision of the Manager, Video Production Data & Reporting to execute reports and to build out new spreadsheets as needed.
• Ensuring industry-standard lexicography is used consistently within all production systems, documentation, and reporting.
• Maintaining all data produced by CN Editorial Video Production organization.
• Adhere to departmental workflows to ensure data integrity and consistency, and enforce standardized data entry processes for all employees across the production management organization
• Build and administer Editorial Video Production folder structure in GDrive
• Maintain and update editorial release archive for Editorial Video Production to ensure that Production Management meets its legal deliverable responsibilities
• Reconcile production management expense transactions
• Provide coverage on payroll and crewing support for on editorial video production projects
• Provides support in maintaining and updating our workflow systems and web platforms e.g. Google sites, Airtable, to meet business requirements for Editorial Video Production Management.
• Assist on other departmental projects as required

Skills

Data management

Attention to detail

Communication skills

Organizational skills

Deadline-driven

Education

Bachelor or Certification in data management

Tools

Excel

Google Sheets

Airtable

Job description

Condé Nast in New York seeks an Associate Manager, Video Production Data & Reporting to build and maintain data reporting systems for production workflows and cost reporting. They must organize large datasets, code spreadsheets, and deliver reporting for executive oversight. This guild position requires strong data management and advanced Google Sheets/Airtable skills.

The role covers payroll coverage, budgeting support, and maintaining editorial video production data integrity across platforms.