Senior Digital Media Analyst

Company Description

Martin Retail Group isn’t your typical “ad agency.” We are LOCAL retail marketing specialists who provide strategic turnkey solutions for global blue chip brands like Cadillac, GMC, Buick, Chevrolet, and Planet Fitness. Founded in 1977 in Birmingham, Alabama, we more have more than 350 team members across the United States. MRG is also partners with Leo Burnett Detroit and a member of the Publicis Worldwide global network.

Job Description

We are currently seeking an experienced and talented Data Analyst to join our close-knit team.  The position will utilize various digital data platforms to gather, analyze and report out 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 collaborate with the Martin Retail field organization across the U.S.

Responsibilities:

• Provide support for existing applications and services provided by the Reporting Team.
• Investigate and troubleshoot problems. Collaborate with business units and team members to determine root cause and appropriate functional solutions.
• Dig into the details of data, interpret and report on the data
• Generates and distribute ad hoc digital reports utilizing sharp analytical skills
• Support the Digital Team & Field Team with various requests and questions
• Aid the Ad Ops, Campaign Management and Buying teams to problem solve potential issues where data analysis is needed
• Absorb information from all teams and clients to be a well-rounded communicator to steward projects and communicate status updates

To apply, please submit your resume and cover letter, with your salary requirements. 

Thank you for your interest in Martin Retail Group!

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)
• Minimum of 3+ years’ experience in data analysis (digital media experience is a plus)
• Ability to deliver quality work in tight turnaround times
• Interpersonal skills to work with a variety of people in different internal departments and external vendors and clients across the US
• Proficiency in Excel, Work and PowerPoint
• Outstanding organizational and communication skills including presentations
• Great work ethic and detail oriented
• Strong team orientation

Skills and abilities we’re seeking: 

• Prefer three to five years background in data collection, analysis, and reporting
• Sharp and reliable analytical skills loving to dig into data, interpret it and report findings
• Intermediate or above Excel knowledge is a must and the most successful candidate will be one who enjoys spending much of their day working in Excel
  • Familiarity with VLOOKUP, INDEX, nested statements, etc.
  • Familiarity with Pivot Tables and Pivot Charts
  • PowerPivot experience is even better
• 1-3 years Experience with Power BI
  • Building basic visuals
  • Connecting and refreshing data sources
  • Working with webservice
• Experience in Power Query and SQL preferred
• Knowledge of DAX
• Ability to effectively create dashboard layouts
• Working knowledge of PowerPoint needed
• Ability to work in a fast-paced environment in which to 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

Additional Information

Publicis Groupe is an Equal Opportunity Employer.