Senior Digital Media Analyst

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.

We are currently seeking an experienced and talented Data Analyst to join our close-knit team.  The position will utilize various digital data platforms, with a heavy use of Power BI, 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, specifically in PowerBI and Tableau.
• Investigate and troubleshoot technical problems relating to data cleaning and modeling.
• Collaborate with business units and team members to determine root cause and appropriate functional solutions.
• Dig into the details of data using Power Query, interpret and report on the data using Power BI.
• 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!

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
• 1-3 years Experience with Power BI required. The most successful candidate will be one who enjoys spending much of their day working in Power BI.
  • Build basic visuals
  • Leverage Power Query to clean and model large data sets
  • Connect and refresh data sources
  • Work with webservice
• Sharp and reliable analytical skills loving to dig into data, interpret it and report findings
• Intermediate or above Excel knowledge is required.
  • Familiarity with VLOOKUP, INDEX, nested statements, etc.
  • Familiarity with Pivot Tables and Pivot Charts
  • PowerPivot experience is even better
• Required skills:
  • Advanced understanding of Power Query
  • Knowledge of DAX and M languages
  • Intermediate understanding of PowerPoint
• Preferred skills:
  • MySQL, VizQL or any SQL experience
  • ETL experience with cloud based DBMS
• Ability to effectively create dashboard layouts
• Ability to thrive in a fast-paced environment 
• 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