Data Analyst Job Bakersfield area,California USA,IT/Tech

iHeart

Media Markets

The audio revolution is here - and iHeart is leading it! iHeart

Media,
the number one audio company in America , reaches 90% of Americans every month -- a monthly audience that’s twice the size of any other audio company - almost three times the size of the largest TV network - and almost 4 times the size of the largest ad-supported music streaming service.

Because we reach almost every community in America, we're committed to providing a range of programming that reflects the diversity of the many communities we serve - and our company reflects that same kind of diversity. Our company values stress collaboration, curiosity, welcoming dissent, accepting mistakes in the pursuit of new ideas, and respect for everyone.

Only one company in America has the #1 position in everything audio: iHeart

Media!

If you're excited about this role but don't feel your experience aligns perfectly with the job description, we encourage you to apply anyway. At iHeart

Media we are dedicated to building a diverse, inclusive, and authentic workplace and are looking for teammates passionate about what we do!

What We Need:

In this position, you will provide data analytics while working on campaign delivery, reporting on complex, multi-platform, multi-market campaigns. Working closely with your data team members, you will set up notebooks in our server that connect ad delivery metrics with campaign KPIs. You will be responsible for extracting, transforming, and loading campaign data into report visuals. As an Analyst, you will be an expert in matching media assets with tracking mechanisms, analyzing data, providing observations and insight.

Skilled work in this area will directly contribute to winning and retaining significant revenue.

What You'll Do:

Notebook development and troubleshooting
Data validation
Running queries on AWS and Biq Query
Collect and analyze the relationship between campaigns, sales, and consumer data
Work on a wide range of client accounts at the same time, often juggling various projects and deadlines
Produce standardized and customized data sets
Create data visualizations
Work collaboratively with sales on media analytics

What You'll Need:

Skilled in Python including Pandas, importing/exporting, filtering, and merging data
Skilled in SQL
Skilled in Excel
Strong analytical and problem-solving skills
Knowledge of data visualization tools (Looker Studio preferred)
Collaborative work style
Strong communication skills - able to give and receive feedback effectively
Ability to plan and organize, set priorities, and multitask in a fast-paced environment
4+ years of media analytics and data preparation or commensurate educational experience
Minimum 1 year experience in AWS and Linux OS
College degree required

What You'll Bring:

Notebook development and troubleshooting
Data validation
Running queries on AWS and Biq Query
Collect and analyze the relationship between campaigns, sales, and consumer data
Works on a wide range of client accounts at the same time, often juggling various projects and deadlines
Produce standardized and customized data sets
Create data visualizations
Work collaboratively with sales on media analytics

Compensation:

Salary to be determined by multiple factors including but not limited to relevant experience, knowledge, skills, other job-related qualifications, and alignment with market data.

$24.00 - $30.00

Location:

VIRTUAL, CA

Position Type:

Regular

Time Type:

Full time

Pay Type:

Hourly

Benefits:

iHeart

Media's benefits offering is flexible and offers a variety of choices to meet the diverse needs of our changing workforce, including the following:

Employer sponsored medical, dental and vision with a variety of coverage options
Company provided and supplemental life insurance
Paid vacation and sick…