Data Analyst, Revenue & Inventory Insights

Spectrum Reach; New York (NY); On-site; USD 73,000 - 83,000; Full time

Job summary

Spectrum Reach, Yield & Inventory Strategy team, seeks a Data Analyst to analyze advertising revenue, inventory performance, and pricing trends, translating data into practical insights for business decisions.

You will develop and maintain dashboards in Excel and Power BI, pulling data from multiple sources, and supporting cross-functional reporting across sports, regional networks, and other products.

Qualifications

• Bachelor’s degree in data analytics, business analytics, finance, economics, statistics, or related field, or equivalent practical experience.
• 2+ years of experience in data analysis, reporting, or related area.
• Strong Excel skills (formulas, pivot tables, Power Query, and data models) and Access or similar tools.
• Strong critical-thinking and communication skills; detail-oriented.
• Willingness to think creatively and learn new approaches.
• Ability to work independently and with a team; manage multiple tasks.
• Eagerness to learn, ask questions, and take feedback.

Responsibilities

• Data Analysis & Business Insights: analyze advertising revenue, inventory utilization, sell-through rates, pricing, and performance.
• Monitor KPIs, flag trends, discrepancies, and issues; support comparisons.
• Data from multiple sources; present findings clearly to stakeholders.
• Reporting & Dashboard Development: maintain and improve reports in Excel, Power BI, and other tools.
• Prepare weekly/monthly reporting across segments; ensure accuracy and timeliness.
• Data Management & Process Improvement: streamline reporting and automate data prep where possible.
• Collaborate with cross-functional partners; document sources and calculations.

Skills

Excel

Power BI

Data analysis

SQL

Power Query

DAX

Communication

Problem solving

Education

Bachelor’s degree in data analytics or related field

Tools

Power BI

Access

Excel data models

Job description

Spectrum Reach, Yield & Inventory Strategy team, seeks a Data Analyst to analyze advertising revenue, inventory performance, and pricing trends, translating data into practical insights for business decisions.

You will develop and maintain dashboards in Excel and Power BI, pulling data from multiple sources, and supporting cross-functional reporting across sports, regional networks, and other products.