Data Analyst (10 Week Intern)

20 May Data Analyst (10 Week Intern)

Posted at 01:23h in Open Career by

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.