Advertising Data Insights Analyst

Spectrum, LLC; New York (NY); Vor Ort; USD 73.000 - 83.000; Vollzeit

Zusammenfassung

Spectrum Reach is seeking a Data Analyst to join the Yield & Inventory Strategy team. You will analyze advertising revenue, inventory performance, and pricing trends to deliver practical insights that guide business decisions.

You will work with the analytics lead, learning our data and tools while delivering clear analyses. Ideal candidates are early-career analysts who value questions, efficiency, and growth, with strong Excel/Power Query and a willingness to learn SQL and data modeling as

Qualifikationen

• Bachelor’s degree or equivalent in data analytics or related field.
• 2+ years in data analysis, reporting, or related area.
• Strong Excel and Access skills, incl. Power Query and data models.
• Analytical thinker with ability to simplify complex data.
• Ability to work independently and with a team.

Aufgaben

• Analyze advertising revenue, inventory utilization, sell-through rates, pricing and business performance.
• Monitor KPIs, flag trends and discrepancies, and support performance comparisons.
• Create clear visualizations in Excel and Power BI for reports.
• Pull data from multiple sources and ensure reporting accuracy.
• Collaborate with cross-functional partners to understand needs and priorities.
• Support ad hoc analytical requests and document procedures.

Kenntnisse

Data analysis

Excel

Communication

Attention to detail

Independent work

Team collaboration

Ausbildung

Bachelor’s degree in data analytics or related field

Tools

Access

Power Query

Data modeling

SQL

Power BI

Jobbeschreibung

Spectrum Reach is seeking a Data Analyst to join the Yield & Inventory Strategy team. You will analyze advertising revenue, inventory performance, and pricing trends to deliver practical insights that guide business decisions.

You will work with the analytics lead, learning our data and tools while delivering clear analyses. Ideal candidates are early-career analysts who value questions, efficiency, and growth, with strong Excel/Power Query and a willingness to learn SQL and data modeling as