AdTechTalent
Ad Ops427 days agoOn-site

Simulmedia

Operations Analyst

ad-opsmedia operationsvideo advertisingdata-drivenMicrosoft ExcelGoogle SheetsSQLVBAMacroscampaign managementreportingTV advertisingstreamingclient success

Key details

Salary

$50K – $60K

Employment type

Full-time

Seniority

Entry

Years experience

0-2

Location

New York, US

Full job description

Simulmedia seeks a junior Operations Analyst to support Video Activation and Client Success teams in executing, analyzing, and optimizing advertising campaigns. Responsibilities include planning data-driven video ad campaigns, assisting media strategy development, managing campaign execution, monitoring inventory and ad placements, coordinating with partners and vendors, resolving operational issues, and compiling post-campaign reports with insights. Candidates should have 0-2 years experience, be recent graduates interested in media or advertising operations, highly organized, analytical, good communicators, and proficient in Excel or Google Sheets. Knowledge of SQL, VBA, or Macros is a plus. The role is full-time, on-site in New York City. Salary range is $50,000 to $60,000. Benefits include fully paid medical, dental, vision, disability, life insurance, flexible PTO, parental leave, reimbursement programs, and a pet-friendly office.

What you'll do

  • Plan compelling data-driven video advertising campaigns to help clients achieve audience-targeting goals
  • Assist in developing media strategies using internal tools
  • Collaborate with internal teams to assemble client proposals
  • Balance multiple campaigns and prioritize tasks to meet deadlines
  • Support the delivery of campaigns by coordinating with partners and ensuring flawless execution
  • Monitor inventory, manage ad placements, and reconcile schedules
  • Traffic creative assets and instructions to network partners
  • Communicate with external vendors to ensure campaign integrity
  • Resolve creative and operational issues as they arise
  • Compile post-campaign reports and offer insights to improve future campaign performance
  • Analyze delivery against campaign goals and KPIs
  • Assemble pacing reports and final wrap-up documents
  • Share data-driven recommendations with internal teams

Requirements

  • 0–2 years of professional experience (internships count)
  • Recent graduate interested in media, advertising, or data operations
  • Highly organized with excellent attention to detail
  • Comfortable working on multiple projects in a fast-paced environment
  • Strong analytical and problem-solving skills
  • Great communicator and team collaborator
  • Proficiency in Microsoft Excel and/or Google Sheets (pivot tables, formulas, formatting)
  • Knowledge of SQL, VBA, or Macros is a plus, but not required
  • Passionate about advertising and curious about TV and streaming tech

Tech stack

Microsoft ExcelGoogle SheetsSQLVBAMacros

Benefits

Fully paid premiums for employee medical, dental, vision, short-term disability, long-term disability and life-insurance coverage for full-time employeesMedical by UnitedHealthcareDental by GuardianVision by EyeMedPre-tax plans for medical flexible spending, dependent care and transit/parkingFlexible paid time off (PTO)Sick time offExtensive holiday scheduleGenerous parental leave policies after a year of servicePhone and Data reimbursement programFully paid Citi Bike membership and helmet stipend with Seamless+ and Lyft PinkPet-friendly officeMonthly happy hours, quarterly team building, plus tons of other fun eventsDedicated workshops for diversity, equity, inclusion and belongingPark Avenue office with 360-degree views and fully stocked kitchens

Apply now

This MVP uses a placeholder application flow. In production, this section can connect to an external apply URL or a native application form.

Continue to applicationBrowse more jobs

Similar jobs

More roles worth a look

Related opportunities based on specialty and working model so candidates can keep momentum.