What are the responsibilities and job description for the Analyst position at Publicis Groupe Holdings B.V?
Martin Retail Group, partnering with Leo Burnett, has served the automotive industry for more than 40 years. Based in Birmingham, Alabama with eight regional offices, we are one of the nation’s largest automotive retail advertising and media spot buying agencies in the country. We work hard, innovate, and deliver the best solutions to drive business for our clients while offering employees work-life balance and a family-friendly, enjoyable environment.
Overview
An Analyst plays a key role in supporting our media team by collecting, analyzing, and interpreting data to drive performance insights. This person will be responsible for developing and maintaining reports, providing data-driven recommendations, and ensuring the accuracy and efficiency of our reporting processes. They will need to be highly proficient in Microsoft Office (Excel, PowerPoint, Word) and have strong knowledge of Power BI and Power Query. The ideal candidate is a problem solver with a keen eye for trends and an eagerness to learn new tools and technologies.
Responsibilities
- Gather, analyze, and interpret media performance data to support media planners and buyers.
- Develop and maintain reports, dashboards, and data visualizations using Microsoft Excel, Power BI, and Power Query.
- Knowledge of traditional media analytics, and campaign performance reporting.
- Ensure data accuracy and consistency across multiple reporting platforms, including Scarborough, Nielsen, Strata, Prisma, MediaTools, and other media software.
- Experience working with large datasets and automating reporting processes.
- Work with internal teams to streamline data collection, reporting, and analysis processes, as well as presenting findings and insights to the media team in a clear and concise manner.
- Troubleshoot data discrepancies and provide solutions to improve reporting accuracy.
Qualifications
- 1-2 years of experience in data collection, analysis, and reporting, preferably in a media, marketing, or advertising environment.
- Advanced proficiency in Microsoft Office, especially Excel (pivot tables, formulas, Power Query) and PowerPoint.
- Experience with Power BI for dashboard creation and data visualization.
- Problem-solving mindset with the ability to troubleshoot data issues and find effective solutions.
- Ability to learn and adapt to new reporting tools and technologies.
- Strong communication skills with the ability to present data findings in a clear and compelling way.
- Detail-oriented with excellent organizational and time-management skills.
Preferred Qualifications:
- Experience working with advertising, media planning, or media buying data.
- Knowledge of digital marketing metrics, media analytics, and campaign performance reporting.
- Identify trends, insights, and opportunities that inform media strategy and decision-making.
- Strong analytical skills with the ability to translate complex data into meaningful insights.
Additional information
Why Join Us?
- Work with a small but talented and passionate team in a fast-paced ad agency environment.
- Opportunity to drive data-driven decision-making in the automotive advertising space.
- Continuous learning and professional development opportunities.
If you have a passion for data analysis and enjoy turning numbers into insights that shape media strategies, we’d love to hear from you!
Salary : $49,305 - $59,185
