Data Analyst I

Universal Music GroupSanta Monica, CA
Paid Internship

5 months ago

Description

Job Title

Data Analyst

Job Location

United States

Job Overview

  • Read and ingest data from multiple advertising platforms and music consumption data sources.
  • Develop automated ETL flows, tap into ad tech APIs, and create data visualizations in Datorama/Salesforce and DOMO.
  • Manage advertising reporting operations and BI dashboards (Datorama/Salesforce), including maintaining data quality and technical problem solving in a fast-paced environment.
  • Gather and understand business requirements to set functional specifications for dashboards, reports, and reporting applications.
  • Manipulate data into sleek, clean datasets in order to generate reports and dashboards with these datasets as defined by business stakeholders
  • Strong ability to manipulate large datasets to serve an end goal is a must.
  • Demonstrable ability to write complex queries with SQL/Hive.

Compensation

Pay Range: $18.00/hour-$24.00/hour
Benefits: Medical, Dental, Vision, 401K

Responsibilities

  • Read and ingest data from multiple advertising platforms and music consumption data sources.
  • Develop automated ETL flows, tap into ad tech APIs, and create data visualizations in Datorama/Salesforce and DOMO.
  • Manage advertising reporting operations and BI dashboards (Datorama/Salesforce), including maintaining data quality and technical problem solving in a fast-paced environment.
  • Gather and understand business requirements to set functional specifications for dashboards, reports, and reporting applications.
  • Manipulate data into sleek, clean datasets in order to generate reports and dashboards with these datasets as defined by business stakeholders
  • Strong ability to manipulate large datasets to serve an end goal is a must.
  • Demonstrable ability to write complex queries with SQL/Hive.

Requirements

  • Experience with GCP BigQuery, DOMO, and/or a Business Intelligence tool like Datorama/Salesforce, Tableau, or Power BI.
  • Previous experience in an analytics-based role within a tech-based or media company preferred.
  • Experience of working with digital advertising platform data and ad tracking technology including Meta (Facebook) and Google preferred.
  • BA/BS degree in a quantitative field or equivalent experience

We're excited for you to apply!

Ad image

Get email updates for the latest Data Analyst I jobs in Santa Monica, CA

GETTING THIS POSITION

Learn how to get your resume noticed and nail that interview.

Your Internship Checklist

DID YOU KNOW:

Recruiters spend an average of six seconds on each resume?

FREQUENTLY ASKED IN INTERVIEWS

Why do you want to work here?

Employers want to see that you’ve done your homework and are excited about the company. 

Other essential interview questions:

  • Tell me about yourself.
  • How would people describe you?
  • Which is your most significant accomplishment?
  • What is your greatest strength?
  • What is your greatest weakness?
  • What are your preferred programming languages and why?
  • What is a class? What is a super-class?
  • What is a default constructor? What is a conversion constructor?
  • What is the difference between C and C++ ? Would you prefer to use one over the other?
  • What is multiple inheritance? What are its advantages and disadvantages?

Learn more

You're ready for this

Always be on the alert for potentially fraudulent job postings online. Report potential fraud to us if you're unsure about the legitimacy of a job posting or employer on Chegg Internships.

  • Never accept a check or other funds from a company to purchase materials necessary for your position.
  • Avoid and report situations where employers require payment or work without compensation as part of the application process.
  • Avoid corresponding with anyone who reaches out via text or email or outside of the Chegg Internships platform that you don't recognize.
  • Be wary of Google Hangout or Skype interviews as these are not publicly-listed numbers that can be used to verify the legitimacy of the interviewer.
Ad image
other relevant jobs