Senior Analyst

About the Company

Martin Retail Group is a leading force in local retail marketing, specializing in strategic, turn-key solutions for global automotive brands. Since our founding in 1977, we've grown to 400+ team members across the United States, representing thousands of dealerships and placing over $1B of media annually – all focused on helping our clients sell more cars and trucks. We pride ourselves on being more than a traditional "ad agency," delivering targeted results. We're also backed by the incredible resources of Publicis Groupe, offering unparalleled world-class technology and capabilities.

About the Role

We are currently seeking an experienced and talented Senior Data Analyst to join our close-knit team. The position will utilize various digital data platforms to gather, analyze, and report on various projects. Projects will include developing reports, identifying and explaining trends, finding solutions, and communicating results for our premier automotive clients, internal digital teams, and collaboration with the Martin Retail field organization across the U.S.

Responsibilities

• Dig into the details of data, interpret, and report on the data
• Generate and distribute ad hoc digital reports utilizing sharp analytical skills
• Support the Digital Team & Field Team with various requests and questions
• Absorb information from all teams and clients to be a well-rounded communicator to steward projects and communicate status updates
• Create basic visuals and dashboards in Power BI and Tableau
• Export dashboards, combine them by market into PowerPoints
• Break out monthly insights by market, ensure vendor has delivered all markets
• Assist reporting team with QA and other daily tasks responding to client needs timely
• Distribute and upload monthly reporting upon completion

Qualifications

Education we’re seeking: Four-year degree in the area of Computer Science, Data Science, or a similar discipline (with a focus in Advertising, Marketing preferred).

Skills

• Prefer five+ years background in data collection, analysis, and reporting
• Sharp and reliable analytical skills with a love for digging into data, interpreting it, and reporting findings
• Intermediate or above Excel knowledge is a must; the most successful candidate will enjoy spending much of their day working in Excel
• Familiarity with VLOOKUP, INDEX, nested statements, Pivot Tables, and Pivot Charts
• PowerPivot experience is a plus
• Experience with Power BI
• Experience in Power Query and SQL preferred
• Working knowledge of PowerPoint needed
• Knowledge of DAX
• Ability to effectively create dashboard layouts
• Ability to work in a fast-paced environment and thrive
• Success with prioritizing tasks and meeting deadlines
• Strong communication skills and desire to work in a team atmosphere
• Familiarity with digital advertising and its KPIs

Benefits

Publicis Groupe provides robust and inclusive benefit programs and policies to support the evolving and diverse needs of our talent and enable every person to grow and thrive. Our benefits package includes:

• Medical coverage
• Dental and vision
• Disability insurance
• 401K
• Parental and family care leave
• Family forming assistance
• Tuition reimbursement
• Flexible time off

Pay

Compensation Range: USD $40,280.00 - USD $48,355.00/Annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position.