Job Alerts
Search Opportunities
Toggle Menu
Don’t miss out
on a great job.
Stay connected with us through job alerts!

Data Analyst

Job ID: 2020-26181
Location:
530 Fifth Ave, New York, NY

New York Interconnect (NYI) - Through a strategic partnership between Altice USA, Charter Communications and Comcast, the New York Interconnect is among the largest single market advertising platforms in the United States.  We provide advertisers with the ability to reach more than 6.2 million households in the New York DMA using a variety of advanced advertising products, including the ability to place ads on more than 85 cable networks as well as planning and campaign measurement.

The Data Analyst is responsible for providing overall support to the New York Interconnect for Addressable TV campaigns via SQL programming queries against outlined objectives, as well as provide research insights and analysis to support the Ad Sales team.

 Responsibilities

  • Write SQL scripts to derive HH counts and create tables based on set-top box and attribute data for use in the creation of audience segments. The segments are used in targeting TV households for Addressable TV Tune-in campaigns.
  • Write SQL scripts to extract data for use in the creation of custom attribution analyses for TV Tune-In campaigns
  • Utilize Alteryx to run quarterly workflow for MVPD sub count submission
  • Update and maintain Domo and Excel dashboards for the Sales team
  • Generate campaign reports for Addressable ad campaigns using Alteryx workflows and Excel
  • Generate Media Delivery reports for Addressable campaigns according to agency templates
  • Generate affidavits for Linear Addressable campaigns
  • Perform quality-check of other analyst’s code for various projects
  • Troubleshoot data/system quality control issues for addressable campaign reporting
  • Work with Campaign Operations, Sales, and Marketing on a regular basis
  • Bachelor’s Degree in Computer Science, Statistics, Mathematics, or related discipline
  • Minimum of 1 year hands-on experience performing SQL queries in a business setting
  • Ability to explain complex technical ideas to multiple audiences verbally and in writing
  • Ability to work with a massive amount of data
  • Ability to work well under pressure and manage multiple projects simultaneously
  • Proficient in advanced Excel skills (e.g. formulas, pivot tables, V-lookup), Word and PowerPoint
  • Ability to extract sales stories from quantitative research tools/software
  • Ability to work independently and resolve problems
  • Excellent organizational, interpersonal and communication skills
  • Detail oriented with strong follow-through and multitasking skills
  • Interest in media research a plus

Altice USA is an Equal Opportunity Employer committed to recruiting, hiring and promoting qualified people of all backgrounds regardless of gender, race, color, creed, national origin, religion, age, marital status, pregnancy, physical or mental disability, sexual orientation, gender identity, military or veteran status, or any other basis protected by federal, state, or local law.

Altice USA, Inc. collects personal information about its applicants for employment that may include personal identifiers, professional or employment related information, photos, education information and/or protected classifications under federal and state law. This information is collected for employment purposes, including identification, work authorization, FCRA-compliant background screening, human resource administration and compliance with federal, state and local law.

Share This Page