Senior Digital Media Analyst

Company DescriptionMartin 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 DescriptionWe 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 skillsSupport the Digital Team & Field Team with various requests and questionsAid the Ad Ops, Campaign Management and Buying teams to problem solve potential issues where data analysis is neededAbsorb information from all teams and clients to be a well-rounded communicator to steward projects and communicate status updatesTo apply, please submit your resume and cover letter, with your salary requirements. Thank you for your interest in Martin Retail Group!QualificationsEducation 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 timesInterpersonal skills to work with a variety of people in different internal departments and external vendors and clients across the USProficiency in Excel, Work and PowerPointOutstanding organizational and communication skills including presentationsGreat work ethic and detail orientedStrong team orientationSkills and abilities we’re seeking: Prefer three to five years background in data collection, analysis, and reporting1-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 visualsLeverage Power Query to clean and model large data setsConnect and refresh data sourcesWork with webserviceSharp and reliable analytical skills loving to dig into data, interpret it and report findingsIntermediate or above Excel knowledge is required.Familiarity with VLOOKUP, INDEX, nested statements, etc.Familiarity with Pivot Tables and Pivot ChartsPowerPivot experience is even betterRequired skills:Advanced understanding of Power QueryKnowledge of DAX and M languagesIntermediate understanding of PowerPointPreferred skills:MySQL, VizQL or any SQL experienceETL experience with cloud based DBMSAbility to effectively create dashboard layoutsAbility to thrive in a fast-paced environment Success with prioritizing tasks and meeting deadlinesStrong communication skills and desire to work in a team atmosphereFamiliarity with digital advertising and its KPIsAdditional Information