Analytics Reporting Specialist (Digital Marketing)

We are a Top-rated US based digital marketing agency looking to add a Data Reporting Specialist to our fast-growing team. The Data Specialist will report to the Senior Data Strategist and is responsible for maintaining operations of agency-client daily reporting tools. This will include being responsible for daily QA of internal database and data aggregation schedule, construction of paid media reports, using python to transform/clean data, and constructing queries using MySQL to create additional datasets for specialized reporting cases. The data specialist also acts as a liaison between reporting and the other departments, managing any requests for report updates, troubleshooting, or additions.
Primary Responsibilities

1. 1. Job Description

1. 1. 1. Create client Looker reports
      2. Maintain client Looker reports
      3. Ingest client data
      4. Manage client data in BigQuery

Required Skills
Highly proficient at Google Data Studio

BigQuery
Exposure to Python and SQL (regex, if/then statements, dataset joins, MySQL)
Basic knowledge of paid media metrics and media platforms (Facebook, GA, Google Ads, LinkedIn, etc.)
Preferred Skills
Google Data Studio expert
1yr experience coding with python and SQL in a professional environment
1yr experience reporting on paid media metrics and media platforms