Media Analyst

Summary: 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. Responsibilities: - Dashboard 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 usability - Data 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 dashboards - Ad-Hoc Analysis & Querying: You will use SQL to query from our in-house database for quick answers to client questions and perform data QA - Growth 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 strategy Required Qualifications: - 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. Experience with TV metrics (Linear, DRTV, CTV) is preferred. Internships and entry-level agency roles count - 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 Preferred Qualifications: - Foundational 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-train - 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 Required Skills: Tableau, SQL, Excel Important Skills: Data Visualization Nice-to-Have Skills: GA4, ELT/ETL, Problem Solving, Collaboration Benefits: Competitive benefits package