Previous Job
Previous
Data Analyst - Warner Brothers
Ref No.: 18-01278
Location: Los Angeles, California
Position Type:Contract
Start Date / End Date: 02/05/2018 to 08/31/2018
Title: Jr. Data Analyst
Location: Burbank (Onsite) 
Duration: 4-5 month contract
Pay: 30/hr W2 
Start Date: ASAP 

Our high profile client in Burbank is looking a Jr. Data Analyst to join their team and contribute to a Tableau based dashboard they are launching in February.
  • This dashboard brings together data from across several independent data sources, which are being related (mapped, etc) and then fed to Tableau for the end user to review status of supply chain-related activities (plan, make, deliver)
  • They're expecting that there will be "data issues” present in the initial results, and so they're bringing in an analyst to work with the user team and dig into the findings to help Tech Ops then assign corrective actions, identify process improvement opportunities – in any case, the analysis will be focused solely on looking at the data and providing findings
    • Review dashboard results and focus on exceptions, data trends, etc (Tech Ops will assist with calibrating on the types of things we want this person to focus on)
    • Pull data (in Excel format) and perform analyses of results, including:
      • Missing data – identify and root cause
      • Data inconsistencies – identify and root cause
      • Data trends (e.g. certain things always late, etc) – this is helpful but a lower priority
    • Work with the SMEs of the data sources to assign recommendations on the findings (RCCA)
  • As far as experience
    • Need to be very strong in Excel – you will be using this daily as a primary tool
    • Would be helpful but not critical that you understand Tableau or other data visualization tools
    • Digital supply chain and digital distribution experience would be helpful in contextually understanding the data
    • Strong understanding of SQL