The company is looking to improve reporting for clients and analysts by hiring a Data Analyst to assist with data analysis, advertising strategy, and visualization needs.
Requirements
- Advanced knowledge of SQL
- Advanced knowledge of Excel
- Advanced knowledge of Google Data Studio/Data Visualization tools
- Experience with Marketing APIs
- Experience with BigQuery or other cloud data warehouse tools (AWS, Snowflake, Databricks)
- Experience with ETL tools (such as Rivery, Looker, Supermetrics)
- Experience with Python
Responsibilities
- 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
- Analyze advertising trends within a single project and across multiple projects to guide media buying strategy
- Apply background in paid media and/or digital advertising, including understanding concepts like LTV, ROAS, and Incremental Revenue
Other
- Bachelor’s degree in a relevant field
- At least 1 year of experience working with marketing data and/or paid advertising campaigns
- Ability to communicate effectively to understand what tools will help solve a problem
- Ability to work collaboratively to design a solution that’s scalable, accurate and easy-to-use
