13 дней назад
Data Analyst - Digital Media Sales, NBCU Local
62 000 - 72 000$
Мэтч & Сопровод
Для мэтча с этой вакансией нужен Plus
Описание вакансии
Текст:
TL;DR
Data Analyst - Digital Media Sales, NBCU Local (Python/Excel/Tableau): Building and maintaining automated and ad-hoc reporting and analytics solutions for digital media sales with an accent on data workflows, business intelligence, and reporting accuracy. Focus on developing Python automation, troubleshooting client-facing dashboards, and supporting inventory, sales, finance, and account management teams.
Location: Fully remote within the United States; unrestricted U.S. work authorization required. Eastern Time business-hours support is required.
Salary: $62,000–$72,000 yearly
Company
is a media and entertainment company operating film, television, streaming, news, theme park, and consumer product brands.
What you will do
- Develop and maintain complex Excel spreadsheets for analysis, reporting, and data reconciliation.
- Maintain and enhance Python code supporting reporting, automation, and data workflows.
- Manage Tableau and other business intelligence tools for reporting and analytics.
- Troubleshoot reporting errors and data discrepancies in the client-facing DOMO Dashboard.
- Automate custom reports and develop ad-hoc analyses for inventory, account management, sales, finance, and other stakeholders.
- Create documentation and standard operating procedures for consistent data processes and knowledge sharing.
Requirements
- Bachelor’s degree or equivalent experience.
- At least 2 years of experience in data analytics, business intelligence, data operations, or a related analytical role.
- Advanced Excel skills, including INDEX/MATCH, XLOOKUP, pivot tables, complex formulas, and reconciliation techniques.
- Proficiency in Python and pandas for data cleaning, manipulation, transformation, and analysis.
- Working knowledge of Tableau, including LOD expressions, calculated fields, and parameters, plus familiarity with DOMO, Git/GitHub, and Jira.
- Must be authorized to work unrestricted in the United States and able to support Eastern Time business hours.
Nice to have
- Experience with digital advertising platforms such as FreeWheel, Google Ad Manager, or Operative.
- Knowledge of digital advertising metrics and concepts, including impressions, video completion rates, CPMs, pacing, inventory, and audience targeting.
- Experience with automated data pipelines, scheduled reporting, relational data concepts, troubleshooting, and root-cause analysis.
Culture & Benefits
- Fully remote position performed from a non- worksite, most commonly an employee’s residence.
- Medical, dental, and vision insurance.
- 401(k), paid leave, tuition reimbursement, discounts, and other benefits.
- External candidates may be asked to attend an in-person interview at an location.
Будьте осторожны: если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого - это мошенники. Обязательно жмите "Пожаловаться" или пишите в поддержку. Подробнее в гайде →