Agency: PivotRoots
We are looking for a skilled Data Analyst to support performance marketing and campaign analysis across multiple media platforms. This role is responsible for managing end-to-end data pipelines, from requirements gathering to dashboard delivery. You will work with data from multiple paid media platforms, CRM systems, and other digital sources using tools like Google BigQuery, Data Fetch Tools, and Data Visualisation Tools (Looker Studio, Power BI). You will collaborate closely with Account POCs, Data Engineering, and clients to deliver accurate and actionable reporting solutions.
Key Responsibilities:
•Analyze marketing campaigns across various digital media platforms (Google Ads, Meta, YouTube, Programmatic, etc.) to assess performance and identify improvement areas.
•Support the stakeholder requirements gathering process by validating stakeholder requirement forms and ensuring data source access.
•Develop and maintain dashboards and reports tracking key performance indicators (KPIs), including CAC, ROAS, LTV, and conversion metrics.
•Ensure data quality and consistency across platforms, managing large and complex datasets.
•Translate insights into clear, actionable recommendations and present findings to both technical and non-technical stakeholders.
•Document processes and maintain standard conventions for data transfers, tables, and dashboards.
Qualifications:
•Bachelor's degree in Engineering, Data Science, Statistics, or a related field.
•0–2 years of experience in data analytics; experienced candidates preferred.
•Proficiency in SQL and Data Visualization Tools (e.g., Looker, Tableau, Power BI).
•Basic understanding of digital marketing platforms (Google Ads, Meta Ads, DV360, etc.) and their metrics.
•Strong Excel and Analytical skills.
•Excellent communication skills and ability to tell a compelling story through data.
•Attention to detail and a structured approach to problem-solving.
Contract Type: Permanent
