Jr. Data Analyst

Analytics Birmingham, Michigan


Description

Shift Digital is looking for a Jr. Data Analyst to join us in our Birmingham, MI office.  We are seeking individuals interested in learning about automotive OEM and dealer operations.

As a Jr. Analyst you will be asked to create reports that provide insight into how a program is performing, identifying common issues & trends, and recommending measurable actions to drive improvement. 

Highlights

  • Produce and deliver weekly reports allowing clients and internal teams to make timely business decisions
  • Identify and communicate best practices to better the success of the program
  • Opportunities to gain experience in all facets of the business
  • Collaborate with an energetic team of like-minded analysts at one of the Top Places to Work in metro Detroit
  • Amazing perks and benefits including but not limited to, high quality medical coverage, 401k with company match, catered lunches and a gym membership

Desired Skills and Experience

  • At least one year of digital marketing experience, preferably in an Analytics capacity
  • Ability to analyze complex/large datasets and distill findings into a compelling story
  • Candidates will be required to take a Microsoft PowerBI skills test
      • Import and clean data from multiple sources using PowerQuery (M)
      • Create a relational data model to combine disparate data sources
      • Design an attractive and insightful dashboard using appropriate visuals
      • Write basic DAX measures as needed to calculate rates and other KPIs
  • Other desired skills
    • Statistical modelling
    • SQL query writing Must be self-motivated, possess strong interpersonal skills, and be detail oriented
    • Excellent communication and presentation skills are expected
    • Bachelor's degree 
    • Experience in Automotive vertical a plus, but not required

Shift Digital is an Equal Opportunity Employer and participates in eVerify