Data Analyst

iHeartMedia; California; Hybrid; USD 33,000 - 41,000; Full time

Benefits offered by this job

Employer sponsored medical

Dental and vision options

Paid vacation and sick time

Paid company holidays

401K plan

Employee Assistance Program (EAP)

Volunteer opportunities

Job summary

iHeartMedia is seeking a data analytics professional to join our campaign analytics team in a virtual role based in California. You will connect ad delivery metrics to campaign KPIs, build notebooks, validate data, and produce visuals that inform decisions across multiple client accounts.

You should be proficient in Python (Pandas), SQL, Excel, and data visualization tools, with 4+ years in media analytics and experience with AWS.

Qualifications

• Proficient in Python with Pandas, data import/export, filtering and merging.
• SQL proficiency for data extraction and transformation.
• Strong Excel skills for data manipulation and reporting.
• Solid analytical and problem-solving abilities.
• Knowledge of data visualization tools; Looker Studio preferred.
• Collaborative work style with effective communication.

Responsibilities

• Notebook development and troubleshooting
• Data validation
• Running queries on AWS and BigQuery
• Collect and analyze the relationship between campaigns, sales, and consumer data
• Work on a wide range of client accounts with multiple projects and deadlines
• Produce standardized and customized data sets
• Create data visualizations
• Work collaboratively with sales on media analytics

Skills

Python

Pandas

SQL

Excel

Looker Studio

Data Visualization

Education

College degree

Tools

AWS

BigQuery

Job description

iHeartMedia, 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: iHeartMedia! 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 iHeartMedia 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 BiqQuery
• 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 BiqQuery
• 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

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: iHeartMedia’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 time
• Paid company holidays
• A Spirit day to encourage and allow our employees to more easily volunteer in their community
• A 401K plan
• Employee Assistance Program (EAP) at no cost – services include telephonic counseling sessions, consultation on legal and financial matters, emotional well-being, family and caregiving
• A range of additional voluntary programs, such as spending accounts, student loan refinancing, accident insurance and more!

The Company is an equal opportunity employer and will not tolerate discrimination in employment on the basis of race, color, age, sex, sexual orientation, gender identity or expression, religion, disability, ethnicity, national origin, marital status, protected veteran status, genetic information, or any other legally protected classification or status.

Non-Compete will be required for certain positions and as allowed by law.

Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records. Click Here to learn about the San Francisco Fair Chance Ordinance.

Our organization participates in E-Verify. Click here to learn about E-Verify.