Data Analyst

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 to join the Yield & Inventory Strategy team in New York, NY. The role focuses on analyzing advertising revenue and inventory performance, then translating results into practical business insights to support reporting, dashboarding, and data-driven decision-making.

Key Responsibilities

• Analyze advertising revenue, inventory utilization, sell-through rates (STR), pricing, and related business performance across products and platforms.
• Track key performance indicators (KPIs), flag trends and discrepancies, and investigate anything that appears inconsistent.
• Support year-over-year, budget-to-actual, and goal-based performance comparisons.
• Break down business questions into manageable components and communicate findings in a clear, easy-to-follow format.
• Use creative approaches when standard methods do not fully address the question.
• Assist with ad hoc analytical requests, including those with short timelines.
• Investigate data discrepancies and collaborate with team members to ensure reporting accuracy.
• Maintain and improve recurring reports and dashboards using Excel, Power BI, and other reporting tools.
• Support weekly and monthly reporting across business segments, including sports, regional sports networks, news, and other advertising products.
• Collect and organize data from multiple sources for reporting and analysis.
• Create clear, simple visualizations to make performance data easier to interpret.
• Ensure reports are accurate, timely, and consistent, and identify opportunities to simplify reporting processes and reduce manual work.
• Apply automation and data preparation using tools such as Power Query, Excel data models, and Access.
• Perform data checks, troubleshoot reporting issues, and help maintain reliable reporting outputs.
• Document reporting procedures, data sources, and calculations.
• Partner with analytical leadership and cross-functional teams to understand reporting needs and align priorities.
• Explain results in plain language to both technical and nontechnical audiences.
• Take ownership of work, raise concerns when needed, suggest solutions, and adapt to changing priorities and special projects.

Required Qualifications

• Bachelor’s degree in data Analytics, Business Analytics, Finance, Economics, Statistics, Mathematics, or a related field, or equivalent practical experience.
• 2+ years of experience in data analysis, reporting, or a related area.
• Strong working knowledge of Microsoft Excel (formulas, pivot tables, Power Query, and data models) and Access or similar tools, with interest in building advanced capabilities.
• Critical-thinking skills with the ability to simplify complex information.
• Willingness to think beyond standard approaches to solve problems.
• Attention to detail and ability to manage multiple tasks while staying organized.
• Excellent written and verbal communication skills.
• Eagerness to learn, ask questions, and incorporate feedback.
• Ability to work independently as skills develop and to collaborate effectively with a team.

Technologies

• Microsoft Excel
• Power BI
• Power Query
• Access
• SQL
• DAX

Preferred Qualifications

• Work experience in media, advertising, telecommunications, or a related industry.
• Familiarity with SQL, DAX, or basic data modeling.
• Experience with advertising platforms such as FreeWheel or Looker.

Compensation and Benefits

• Base pay generally between $73,200.00 and $82,500.00 per year.
• Comprehensive pay and benefits package.
• Rewards employees for contributions to the company’s success.
• Support for well-being at every stage of life.
• Eligible for additional incentive-based compensation, such as bonuses (for certain positions).

Work Authorization

This role requires the ability to work lawfully in the U.S. without employment-based immigration sponsorship, now or in the future.