Media Analyst

Eicoff is looking for a Media Analyst who is a math-oriented professional with a passion for data and a desire for work-life balance. In this role, you will manage dashboard production, collaborate with Data Engineers, and perform ad-hoc analysis to provide insights on media performance.ResponsibilitiesDashboard Production & Management: 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 usabilityData Engineering Collaboration: 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 dashboardsAd-Hoc Analysis & Querying: You will use SQL to query from our in-house database for quick answers to client questions and perform data QAGrowth into Data Storytelling: 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 strategySkillsA 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. Experience with TV metrics (Linear, DRTV, CTV) is preferred. Internships and entry-level agency roles countExcel: Strong skills are required (Pivot tables, complex formulas, cleaning data)SQL: Basic ability to write queries to select and filter data from a databaseA collaborative spirit, patience in troubleshooting data discrepancies, and a genuine desire to learnFoundational proficiency in Tableau is preferred. We are open to candidates with strong experience in other platforms (Power BI, Looker Studio, Datorama) who are willing to cross-trainGA4: Basic navigation skills in Google Analytics 4 is a plusELT/ETL: Foundational exposure to Extract, Load, Transform tools (specifically Alteryx) is desired, though deep expertise is not requiredBenefitsCompetitive benefits packageCompany OverviewEicoff 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.



Apply To This Job