AdTechTalent
Ad Ops16 months 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

Ready to take the next step in your career? Click the button below to continue to the application process.

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.