Data Analyst

iHeartMedia is hiring a Data Analyst to provide analytics and reporting for complex, multi-platform, multi-market campaigns. The role connects ad delivery metrics with campaign KPIs, prepares and visualizes campaign data, and delivers insights that support revenue and sales efforts.

Responsibilities:

• Notebook development and troubleshooting
• Data validation
• Running queries on AWS and BiqQuery
• Collect and analyze the relationship between campaigns, sales, and consumer data
• Work on a wide range of client accounts at the same time, often juggling various projects and deadlines
• Produce standardized and customized data sets
• Create data visualizations
• Work collaboratively with sales on media analytics

Requirements:

• Skilled in Python including Pandas, importing/exporting, filtering, and merging data
• Skilled in SQL
• Skilled in Excel
• Strong analytical and problem-solving skills
• Knowledge of data visualization tools
• Collaborative work style
• Strong communication skills – able to give and receive feedback effectively
• Ability to plan and organize, set priorities, and multitask in a fast-paced environment
• 4+ years of media analytics and data preparation or commensurate educational experience
• Minimum 1 year experience in AWS and Linux OS
• College degree required
• Looker Studio preferred