Description
Key Skills: Python, SQL, Excel, Power BI, Tableau, Data Analysis, Project Management, Statistical Analysis, VBA, R
Good to Have Skills: AI and automation exposure including prompt engineering and AI workflows, experience with SPSS, Google Sheets proficiency, VB Script knowledge, familiarity with project planning tools like ROSCO or Monday.com, brand tracking and quality indexing methodologies, media valuation techniques, and deep knowledge of advertising industry sponsorship models.
Roles & Responsibilities:
- Analyze information independently to turn results into compelling stories that provide added value and ROI insights for clients.
- Create detailed ROI reports and dashboards that demonstrate the monetary value of sponsorships based on audience size and advertising rates.
- Conduct market research including survey analysis and trend forecasting to help brands understand emerging behaviors and demographics.
- Manage complex client analytical projects serving as a liaison between Sales and Operations to ensure solutions meet client needs.
- Define scope perform cost calculations and conduct feasibility checks for projects ensuring they meet budget expectations and profitability goals.
- Use project planning tools to track project progress and coordinate with diverse media services teams to meet service level agreements.
- Drive the automation of standardized repeatable business processes to improve efficiency and effectiveness using technical skills.
- Design and implement AI workflows and utilize prompt engineering to enhance data processing speed and analytical capabilities.
- Oversee methodologies for media value determination including brand tracking and quality indexing for accurate valuation calculations.
Experience Required: 3-6 years of experience with strong analytical mindset, excellent communication and presentation skills, deep knowledge of media and sponsorship within advertising industry, schedule flexibility to work in shifts for USA market clients, and ability to collaborate with international colleagues