Data Analyst, Revenue & Inventory Strategy

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

Job summary

Spectrum Reach is seeking a Data Analyst to join the Yield & Inventory Strategy team. You will analyze advertising revenue, inventory performance, sell-through rates, and pricing to deliver actionable insights for business decisions.

Ideal candidates have 2+ years in data analysis, strong Excel and Power BI skills, and the ability to present findings clearly to technical and nontechnical audiences. Experience with data modeling and collaborating with cross-functional teams is a plus.

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.

Responsibilities

• Analyze advertising revenue, inventory utilization, sell-through rates, pricing, and business performance across products and platforms.
• Monitor KPIs, 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 ensure reporting is accurate.
• 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.
• Work with team members and cross-functional partners to understand reporting needs.
• Explain findings in plain language for both technical and nontechnical audiences.

Skills

Excel

Pivot tables

Power Query

Data analysis

Communication

Education

Bachelor’s degree or equivalent in data analytics, finance, economics, statistics, mathematics, or related field

Tools

Power BI

Access

SQL (basics)

DAX

Looker

Job description

Spectrum Reach is seeking a Data Analyst to join the Yield & Inventory Strategy team. You will analyze advertising revenue, inventory performance, sell-through rates, and pricing to deliver actionable insights for business decisions.

Ideal candidates have 2+ years in data analysis, strong Excel and Power BI skills, and the ability to present findings clearly to technical and nontechnical audiences. Experience with data modeling and collaborating with cross-functional teams is a plus.