Data Analyst

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.