Media Analyst

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