Data Analyst

Role overview

Responsibilities

• Develop and troubleshoot notebooks on the company server that connect ad delivery metrics with campaign KPIs.
• Validate data and run queries using AWS and BigQuery.
• Collect and analyze relationships among campaigns, sales, and consumer data.
• Extract, transform, and load campaign data into report visuals; produce standardized and customized datasets.
• Match media assets with tracking mechanisms, analyze data, and provide observations and insights.
• Create visualizations, manage multiple client accounts and deadlines, and collaborate with sales on media analytics.

Qualifications

• Strong Python skills, including Pandas, importing and exporting, filtering, and merging data; strong SQL and Excel skills.
• Knowledge of data visualization tools; Looker Studio is preferred.
• Strong analytical and problem-solving skills, collaboration, communication, planning, organization, and prioritization.
• Four or more years of media analytics and data preparation experience, or commensurate educational experience.
• At least one year of AWS and Linux operating system experience; college degree required.

Location and work arrangement

• Location is listed as VIRTUAL, CA.

Compensation

• Hourly pay is listed at $24.00–$30.00; salary is determined by relevant experience, skills, qualifications, and market factors.

Employment

• Position type is regular and time type is full time.

Benefits

• Benefits include medical, dental, and vision coverage, life insurance, paid vacation and sick time, company holidays, a 401(k), an employee assistance program, and additional voluntary programs.