Data Analyst - Digital Media Sales, NBCU Local (Digital Advertising)

Location: Fully remote, with a preference for candidates based in the New York City metropolitan area; must be able to regularly support Eastern Time business hours. Unrestricted work authorization to work in the United States is required. External candidates may be required to attend an in-person interview at an hirify.global location.

Salary: $62,000–$72,000 per year.

Company

hirify.global is a media and entertainment company producing and distributing film, television, streaming, news, sports, and digital content through brands including NBC, Telemundo, Peacock, and NBC Local Stations.

What you will do

• Create, maintain, troubleshoot, and implement automated and ad-hoc reporting and analytical solutions.
• Develop complex Excel spreadsheets with advanced formulas and functions for data analysis and reporting.
• Maintain and enhance Python code supporting reporting, automation, and data workflows.
• Manage Tableau and other Business Intelligence tools, and troubleshoot reporting errors and data discrepancies in the client-facing DOMO Dashboard.
• Automate custom stakeholder reports and develop additional reports and analyses for evolving business needs.
• Create and maintain documentation and SOPs for consistent data processes, knowledge sharing, and operational continuity.

Requirements

• Bachelor’s degree or equivalent experience.
• 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, nested and complex formulas, and data reconciliation techniques.
• Proficiency in Python, including extensive experience with pandas for data cleaning, manipulation, transformation, and analysis.
• Deep working knowledge of Tableau, including Level of Detail expressions, calculated fields, and parameters.
• Familiarity with DOMO, including Magic ETL, Beast Mode, Dataflows, Views, and calculated fields.
• Familiarity with Git and GitHub for version control and collaborative development workflows.
• Familiarity with Jira or a similar ticketing or project management platform.
• Ability to regularly support Eastern Time business hours, unrestricted United States work authorization, and age 18 or older.

Nice to have

• Experience with digital advertising platforms such as FreeWheel, Google Ad Manager, Operative, or similar systems.
• Familiarity with digital advertising concepts including impressions, video completion rates, CPMs, pacing, inventory, and audience targeting.
• Experience developing or maintaining automated data pipelines and scheduled reporting processes.
• Strong troubleshooting, investigation, and root-cause analysis skills.
• Familiarity with relational data concepts.
• Curiosity and willingness to continuously learn new tools and technologies.
• Self-motivation and the ability to manage priorities and work independently.

Culture & Benefits

• Fully remote position with a preference for candidates in the New York City metropolitan area.
• Company-sponsored medical, dental, and vision insurance.
• 401(k), paid leave, tuition reimbursement, discounts, and other benefits.
• Inclusive culture focused on developing talent and supporting communities.