Data Analyst - Yield & Inventory Strategy

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

Job summary

Charter Communications, Inc. is seeking a Data Analyst on the Yield & Inventory Strategy team to analyze advertising revenue, inventory performance, and pricing while turning insights into actionable recommendations.

This role supports multiple reporting channels and cross-functional partners across media products in a fast-paced environment. You will develop and maintain reports, explore data discrepancies, and help the team make data-driven decisions.

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 a related area.
• Strong knowledge of Excel (formulas, pivot tables, power query, data models) and Access or similar tools.
• Strong critical-thinking skills and ability to simplify complex info.
• Willingness to think outside the box and learn new approaches.
• Attention to detail and ability to stay organized with multiple tasks.
• Excellent written and verbal communication skills.
• Ability to work independently as skills develop, and to collaborate with a team.

Responsibilities

• Help analyze advertising revenue, inventory utilization, sell-through rates, pricing, and performance.
• Monitor KPIs and flag trends, discrepancies, and issues in reporting.
• Support year-over-year, budget-to-actual, and goal-based comparisons.
• Break down questions into clear pieces and present findings simply.
• Assist with ad hoc analyses and tight timelines.
• Look into data discrepancies and ensure reporting accuracy.
• Create and maintain dashboards and recurring reports in Excel and Power BI.
• Pull data from multiple sources for reporting and analysis.
• Document reporting procedures, data sources, and calculations.

Skills

Data analysis

Problem solving

Communication

Attention to detail

Time management

Independent work

Team collaboration

Adaptability

Curiosity

Education

Bachelor's degree in data analytics / related field

Tools

Microsoft Excel

Power BI

Access

Power Query

Data modeling

SQL (preferred)

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.

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.