Spectrum Reach is looking for a dynamic Data and Reporting Analyst to support our media team in New York City.
Spectrum Reach (www.spectrumreach.com) grows businesses of all sizes with custom, multiscreen advertising solutions, backed by the power of TV, data, innovation, community experts, and unforgettable creative.
WHAT YOU WILL DO... We are seeking a talented and passionate individual to join our growing Yield and Inventory Management team. You will work closely with Sales, Finance, Ad Operations and Product teams to analyze the current state of our Advanced Advertising and Television business. Areas of focus will include analyzing and forecasting inventory for the Streaming TV advertising business, product KPIs, as well as revenue and sales performance.
This Data and Reporting Analyst is responsible for managing specific data and insights to better assist leadership in maximizing inventory, revenue and margin in various departments or lines of business. They are responsible for creating and producing projections, reports, ad hoc requests, dashboards, etc. in order to provide insights to determine business impact, trends, and opportunities.
Conduct data analysis in support of a variety of analytic solutions
Capture, develop, and document data definitions, business rules, and data quality requirements
Integrate data from multiple sources to produce requested or required data elements
Create and maintain projections, reports, ad hoc requests, dashboards, etc.
Interpret data, analyze results, and provide insights to determine business impact, trends, and opportunities
Develop dashboards and deliverables for leadership and communicate with cross-functional stakeholders
Identify and define data quality improvements
Ensure data integrity of all deliverables by performing quality data audits
Build needs and requirements for report and dashboard automation projects
Perform other duties as requested
WE ARE LOOKING FOR...
2 or more years working in data analysis and reporting or related experience
Bachelor's Degree in business or other related field from a four-year College or University or equivalent experience
Experience with interacting across relevant ad serving platforms (FreeWheel/MRM, Google Ad Manager, etc.)
Experience with maintaining large amounts of data via databases and visualization tools (Tableau, MicroStrategy, etc.) and maintaining data integrity
Highly proficient within Excel; knowledge of SQL a plus
Ability to prioritize and organize effectively
Ability to work independently, as well as in a collaborative and dynamic team environment
Ability to handle multiple projects and priorities at one time
Ability to analyze and interpret data
Ability to quickly identify business problems/opportunities
Ability to communicate orally and in writing in a clear and straightforward manner
Ability to communicate with all levels of management and company personnel
Ability to document, prepare and present data-driven presentations
Must be proficient in Microsoft Office applications (Outlook, Word, PowerPoint)
Job Code : BDA352
For more information on Spectrum's benefits, please click here.|13542 - North Manhattan|00449 - NYC 1633 Broadway