Data Analyst - Yield & Inventory Strategy

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

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.

BDA352 2026-85728 BDA352 2026

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, the leading broadband and video company in the nation and the fastest growing mobile provider in its footprint, with services available to more than 70 million homes and small to large businesses across 45 states. When you join our team, you’ll be keeping customers connected to Seamless Connectivity and Entertainment with Spectrum Internet®, Mobile, TV and Voice products. Watch this video to learn more.

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.