Data Analyst - Digital Media Sales, NBCU Local

NBCUniversal•New York, NY

5d•Remote

About The Position

NBCU Digital Media Sales Local Inventory & Analytics is seeking a highly analytical, self-motivated Data Analyst to create, maintain, troubleshoot, and implement automated and ad-hoc reporting and analytics solutions. The position works cross-functionally with the Inventory Team, Account Managers, Sales, Finance, and other stakeholders. It is fully remote, with a preference for candidates in the New York City metropolitan area, and requires regular support of Eastern Time business hours.

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 data reconciliation techniques.
Proficiency in Python, with extensive experience using pandas for data cleaning, manipulation, transformation, and analysis.
Deep working knowledge of Tableau, including Level of Detail (LOD) 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.
Familiarity with Jira or a similar ticketing or project management platform.
Ability to regularly support Eastern Time business hours.
Unrestricted authorization to work in the United States.
Must be at least 18 years old.

Nice To Haves

Experience with digital advertising platforms such as FreeWheel, Google Ad Manager, Operative, or similar systems.
Familiarity with digital advertising concepts and terminology, 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 ability to manage priorities and work independently.

Responsibilities

Develop and maintain complex Excel spreadsheets using advanced formulas and functions for data analysis and reporting.
Maintain and enhance the existing Python codebase for reporting, automation, and data workflows.
Manage and maintain business intelligence tools, including Tableau, for reporting and analytics.
Troubleshoot and resolve reporting errors and data discrepancies in the client-facing DOMO Dashboard.
Automate custom stakeholder reports using Python to improve efficiency and scalability.
Develop additional reports and analyses on an ad-hoc basis to support evolving business needs.
Develop and maintain documentation and standard operating procedures for consistent data processes, knowledge sharing, and operational continuity.