Data Analyst: Ad Revenue & Inventory Insights

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

Benefits offered by this job

Comprehensive pay and benefits package

Bonuses eligible

Well-being support

Incentive-based compensation potential

Job summary

Spectrum Reach is seeking an early-career Data Analyst in New York, NY to join the Yield & Inventory Strategy team. You will analyze advertising revenue and inventory performance, translating results into practical business insights for reporting, dashboards, and data-driven decisions.

The role emphasizes improving recurring reports, collaborating with teams, and communicating findings to both technical and non-technical audiences while supporting weekly and monthly reporting across various ad

Qualifications

• Bachelor’s degree in data analytics, finance, economics, statistics, mathematics or related field or equivalent practical experience.
• 2+ years of experience in data analysis, reporting, or related area.
• Strong Excel skills including formulas, pivot tables, Power Query, and data models; experience with Access or similar tools.

Responsibilities

• Analyze advertising revenue, inventory utilization, STR, pricing, and related performance across products and platforms.
• Track KPIs, flag trends, investigate discrepancies, and support comparative analyses (YoY, budget-to-actual).
• Translate findings into clear visuals and actionable insights for reporting and dashboards.
• Create and maintain recurring reports and dashboards using Excel and Power BI; ensure accuracy and timeliness.
• Assist with ad hoc analytical requests and short timelines.
• Document data sources, calculations, and reporting procedures; collaborate with cross-functional teams.

Skills

Data analysis

Critical-thinking

Communication

Independence

Team collaboration

Learning mindset

Education

Bachelor's degree in analytics or related field

Equivalent practical experience

Tools

Excel

Power BI

Power Query

Access

SQL

DAX

Job description

Spectrum Reach is seeking an early-career Data Analyst in New York, NY to join the Yield & Inventory Strategy team. You will analyze advertising revenue and inventory performance, translating results into practical business insights for reporting, dashboards, and data-driven decisions.

The role emphasizes improving recurring reports, collaborating with teams, and communicating findings to both technical and non-technical audiences while supporting weekly and monthly reporting across various ad