20 May Data Analyst (10 Week Intern)
Posted at 01:23h in Open Career by lucca
Who You Are
- You have a true love for data. You have no problem tearing apart a problem and living inside a spreadsheet or data set to find the answer to any question.
- You have advanced knowledge of SQL, Excel, and Google Data Studio/Data Visualization tools, and enjoy working with SQL on a day-to-day basis.
- Experience with Marketing APIs, BigQuery or other cloud data warehouse tools (AWS, Snowflake, Databricks), ETL tools (such as Rivery, Looker, Supermetrics), and/or Python is a plus.
- You have a bachelor's degree in a relevant field and at least 1 year of experience working with marketing data and/or paid advertising campaigns, preferably in a fast-paced agency environment or team structure.
What You'll Do
- Maintain customized dashboards in Google Sheets and Excel on a daily/weekly cadence.
- Use Advanced Excel, SQL, and Google Data Studio/Visualization Tools to generate pivot tables and other visualizations summarizing thousands of lines of data.
- Translate performance media metrics into clear, digestible reports for client advertising campaigns.
- Communicate insights effectively through Google Slides or PowerPoint decks.
Strategy
- Learn our clients businesses and align media strategy with their business goals.
- Analyze advertising trends within a single project and across multiple projects to guide media buying strategy.
- Apply your background in paid media and/or digital advertising, including understanding concepts like LTV, ROAS, and Incremental Revenue.
- Engage in discussions with clients to build trust and gain stakeholder buy-in on media strategy and results.
