Agency :
PivotRootsJob Description :
PivotRoots Havas CSA are looking for a skilled Data Analyst to support performance marketing and campaign analysis across multiple media platforms. This role will focus on measuring campaign effectiveness using data from CRM systems, advertising platforms (e.g., Google Ads and Meta), and advanced analytics tools, including Google Ads Data Hub (ADH). The candidate will work closely with marketing and data teams to deliver actionable insights and drive data-informed decisions.Key Responsibilities:
- Analyze marketing campaigns across various digital media platforms (Google Ads, Meta, YouTube, programmatic, etc.) to assess performance and identify improvement areas.
- Leverage Google Ads Data Hub (ADH) to perform granular campaign analysis and derive privacy-safe insights.
- 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.
Qualifications:
- Bachelor’s degree in Engineering, Data Science, Statistics, or a related field.
- 2+ years of experience in data analytics.
- Strong experience working with Google Ads Data Hub (ADH) or media platforms (Google Ads, Meta Ads Manager, DV360, etc.).
- Proficiency in SQL and data visualization tools (e.g., Looker, Tableau, Power BI).
- Solid understanding of digital marketing metrics, attribution models, and media effectiveness.
- Strong Excel and analytical skills; experience with Python or R is a plus.
- Excellent communication skills and ability to tell a compelling story through data.
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
- At least 2 years of experience in data analytics
- Experience with Google Ads Data Hub or media platforms such as Google Ads, Meta Ads Manager, and DV360
- Proficiency in SQL
- Experience with data visualization tools such as Looker, Tableau, or Power BI
- Understanding of digital marketing metrics, attribution models, and media effectiveness
- Strong Microsoft Excel and analytical skills
- Excellent communication skills and ability to present data-driven insights
- Experience with Python or R
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.







