Data Analyst (Digital Marketing Experience)

We are a Top-rated US based digital marketing agency looking to add a Data Analyst to our fast-growing team. The ideal candidate should be a natural problem solver and continuous learner who is eager to grow, innovate and find efficient solutions to complex problems.

The Data Analyst will report to the Data Analytics Manager and is responsible for maintaining the data infrastructure (reporting dashboards, data integrations, and data warehousing) for our clients. The Data Analyst also acts as a liaison between the data department and the other departments at the agency, managing internal support requests for troubleshooting or revisions to our clients’ reporting infrastructure. The Data Analyst should have SQL and data strategy expertise, and be able to work autonomously.

Primary Responsibilities
Extracting, transforming, and loading data using Adverity ETL tool
Construct dashboard reports for agency clients using Looker Studio (formerly Google Data Studio)
QA of internal BigQuery database and data aggregation schedules
Using regex or python to transform/clean data
Constructing SQL queries to create additional datasets in BigQuery
Make edits and adjustments to reports/dashboards, requested by other departments
Document data structure and SOPs related to individual projects
Perform regular updates of manual reports
Troubleshoot data discrepancies
Daily QA of data aggregation to maintain proper refreshing cadence

Required Skills
SQL and data strategy expertise
Highly proficient with BigQuery
Highly proficient with Looker Studio (formerly Google Data Studio)
Highly proficient with Google Sheets
Deep understanding of ETL (extract, transform, load)
Exposure to Python and SQL (regex, if/then statements, dataset joins, MySQL)
Basic knowledge of paid media metrics and media platforms (Facebook Ads, Google Analytics, Google Ads, LinkedIn Ads, etc.)

Preferred Skills
1yr experience coding with python and SQL in professional environment
1yr experience supporting data needs of marketing teams
1yr experience reporting on paid media metrics and media platforms

Please include the words “Ignite” and “Data Analyst” in the subject line of your response/application, and include your resume or CV in your response.