Data Analyst - Yield & Inventory Strategy

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

Benefits offered by this job

Benefits package

Career growth

Equal opportunity employer

Job summary

Spectrum Reach is hiring a Data Analyst to transform advertising data into actionable insights. You will analyze revenue, inventory metrics, and pricing across multiple platforms, delivering practical recommendations to inform business decisions.

You will develop and maintain dashboards in Excel and Power BI, support monthly reporting, and collaborate with cross-functional teams to ensure data accuracy and clarity for stakeholders.

Qualifications

• Bachelor's degree in data analytics, business analytics, finance, economics, statistics, mathematics, or related field.
• 2+ years of data analysis, reporting, or related experience.
• Strong Excel (formulas, pivots, power query, data models) and Access knowledge.
• Excellent written and verbal communication skills.

Responsibilities

• Analyze advertising revenue, inventory performance, sell-through rates, pricing, and business trends.
• Monitor KPIs and flag discrepancies or trends.
• Support year-over-year, budget-to-actual, and goal-based comparisons.
• Create clear, simple visualizations of performance data.

Skills

Excel

Data storytelling

Critical thinking

Attention to detail

Independent work

Team collaboration

Problem solving

Education

Bachelor's degree in data analytics / related field

Tools

SQL

Power BI

Power Query

DAX

Access

Looker

FreeWheel

Job description

Data Analyst

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

Spectrum Reach helps local businesses grow through the best content, insights, products, and people that connect advertisers to their intended audiences across TV, apps, social, and other media platforms. Spectrum Reach operates in multiple states and local markets that can reach over 27 million households by creating scalable advertising and marketing services driven by data insights and award-winning creative services.

As a Data Analyst on the Yield & Inventory Strategy team at Spectrum Reach, you will help analyze advertising revenue, inventory performance, sell-through rates, pricing, and business trends, and turn what you find into clear, practical insights that support business decisions.

This is a great opportunity for an early-career analyst who wants to build a strong foundation in data analysis and reporting. You will work closely with the team's analytical lead, who will provide guidance and hands-on support as you learn our data, tools, and business. We value people who ask good questions, look for better ways to do things, and are eager to grow.

Key Responsibilities

Data Analysis & Business Insights

• Help analyze advertising revenue, inventory utilization, sell-through rates (STR), pricing, and business performance across products and platforms.
• Monitor key performance indicators (KPIs) and flag trends, discrepancies, and anything that doesn't look right.
• Support year-over-year, budget-to-actual, and goal-based performance comparisons.
• Break down business questions into clear, manageable pieces and present findings in a simple, easy-to-follow way.
• Think creatively and bring fresh ideas when a standard approach doesn't fully answer the question.
• Assist with ad hoc analytical requests, sometimes on short timelines.
• Look into data discrepancies and work with team members to make sure reporting is accurate.

Reporting & Dashboard Development

• Help maintain and improve recurring reports and dashboards in 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.
• Pull together and organize data from multiple sources for reporting and analysis.
• Create clear, simple visualizations that make performance data easy to understand.
• Help ensure reports are accurate, timely, and consistent.

Data Management & Process Improvement

• Look for ways to simplify reporting processes and reduce manual work.
• Learn and use tools such as Power Query, Excel data models, and Access to automate data prep and reporting.
• Share ideas for improving how things are done, even if it's "always been done this way."
• Perform data checks and help troubleshoot issues to keep reporting reliable.
• Help document reporting procedures, data sources, and calculations.

Collaboration & Business Support

• Work with team members and cross-functional partners to understand reporting needs.
• Partner with the team's analytical lead to prioritize work and support team goals.
• Explain findings in plain language for both technical and nontechnical audiences.
• Take ownership of your work, raise issues when you see them, and suggest possible solutions.
• Adapt to changing priorities and support special projects as needed.

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.
• Solid working knowledge of Microsoft Excel (formulas, pivot tables, power query, and data models) and Access or similar tools, with a desire to build more advanced skills.
• Strong critical-thinking skills and an interest in taking complex information and making it simple and clear.
• Willingness to think outside the box and try new approaches to solve problems.
• Attention to detail and the ability to stay organized while managing more than one task.
• Excellent written and verbal communication skills.
• Eagerness to learn, ask questions, and take feedback.
• Ability to work independently as your skills develop, and to collaborate with a team.

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.

Here, our employees don't just have jobs, they're building careers. That's why we offer a comprehensive pay and benefits package that rewards employees for their contributions to our success, supporting all aspects of their well-being at every stage of life.

A qualified applicant's criminal history, if any, will be considered in a manner consistent with applicable laws, including local ordinances.

The base pay for this position generally is between $73,200.00 and $82,500.00. The actual compensation offered will carefully consider a wide range of factors, including your skills, qualifications, experience, and location. We comply with local wage minimums and also, certain positions are eligible for additional forms of other incentive-based compensation such as bonuses.

Get To Know Us:

Spectrum is a suite of advanced communications services offered by Charter Communications, Inc. (NASDAQ: CHTR), the leading internet and video provider in the nation and the fastest growing mobile company in our footprint, with services available to more than 70 million homes and businesses across 45 states. Supported by our 100% U.S.-based employees, we are America's Internet Company.

At close of the Cox acquisition, Spectrum announced that over the next 18 months, it will fully return legacy Cox's customer service function to the U.S.

Grow Your Career Here

We're committed to growing a workforce that reflects the customers and communities we serve - providing opportunities for employment and advancement to all team members. Spectrum is an Equal Opportunity Employer, including job seekers with disabilities and veterans. Learn about Life at Spectrum.