Agency :
PivotRootsJob Description :
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 solutionsKey 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.
Contract Type : Permanent
Here at Havas across the group we pride ourselves on being committed to offering equal opportunities to all potential employees and have zero tolerance for discrimination. We are an equal opportunity employer and welcome applicants irrespective of age, sex, race, ethnicity, disability and other factors that have no bearing on an individual’s ability to perform their job.
Contract Type :
PermanentHere at Havas across the group we pride ourselves on being committed to offering equal opportunities to all potential employees and have zero tolerance for discrimination. We are an equal opportunity employer and welcome applicants irrespective of age, sex, race, ethnicity, disability and other factors that have no bearing on an individual’s ability to perform their job.
Skills Required
- Bachelor's degree in Engineering, Data Science, Statistics, or a related field
- 0-2 years of experience in data analytics
- Proficiency in SQL
- Proficiency with data visualization tools such as Looker, Tableau, or Power BI
- Basic understanding of digital marketing platforms and metrics, including Google Ads, Meta Ads, and DV360
What We Do
Fearless. Fast. Smart. Focused. We are on a relentless quest to be Chicago's most creative company by reinvigorating iconic American brands through cultural relevance. We are passionate makers, digital disruptors, artists who don't color inside the lines. We work smarter. Push harder. Break things. Make things. And we're always looking forward.
Why Work With Us
Our agency gets out of bed in the morning to undertake what we call 'meaningful disruption' in an industry that is in need of serious transformation. We are not looking for the same, boring solutions that are chock-full of brand and marketing rhetoric but seek people that want to change the advertising game.






