Eicoff is a company focusing on media performance insights, seeking a Media Analyst who is math-oriented and data-driven. The role involves managing dashboard production, collaborating with Data Engineers, and transitioning into data storytelling to provide compelling insights for clients.
Responsibilities
- Your primary responsibility is ensuring the accurate and timely delivery of weekly performance reports
- You will manage data visualization dashboards (primarily in Tableau) for Eicoff’s clients, ensuring data integrity and usability
- You will act as a translator between the media teams and our Data Engineers
- You will help write the specs that tell the engineers what data needs to be pulled from our Snowflake database to populate your dashboards
- You will use SQL to query from our in-house database for quick answers to client questions and perform data QA
- While your initial focus will be on the 'what' (reporting), you will undergo training to master the 'why' (insights)
- You will learn to interpret media metrics to tell compelling stories that drive strategy
Skills
- A Bachelor's degree in a quantitative field is required (e.g., Mathematics, Finance, Economics, Statistics, or similar)
- 1 to 3 years of experience in a media, advertising, or marketing environment
- Excel: Strong skills are required (Pivot tables, complex formulas, cleaning data)
- SQL: Basic ability to write queries to select and filter data from a database
- A collaborative spirit, patience in troubleshooting data discrepancies, and a genuine desire to learn
- Experience with TV metrics (Linear, DRTV, CTV) is preferred
- Foundational proficiency in Tableau is preferred
- GA4: Basic navigation skills in Google Analytics 4 is a plus
- ELT/ETL: Foundational exposure to Extract, Load, Transform tools (specifically Alteryx) is desired, though deep expertise is not required
Benefits
- Competitive benefits package
Company Overview
- Eicoff is a marketing and advertising company that offers digital video and radio advertising services. It was founded in 1959, and is headquartered in Chicago, Illinois, USA, with a workforce of 51-200 employees. Its website is http://eicoff.com.