Data Analyst (Media / Marketing)

Sotalent; California; Remote; USD 50,000 - 62,000; Full time

Benefits offered by this job

Medical, dental and vision insurance

Life insurance options

Paid vacation, sick leave and company

Employee Assistance Programme

Financial wellness programmes

Job summary

Sotalent, a remote US-based role with California alignment, is seeking a Marketing Data Analyst to support the measurement and reporting of multi‑platform media campaigns. You will prepare and analyse campaign data, build notebooks and visualisations, and connect advertising metrics with KPIs, sales and consumer insights.

You will work with data and sales teams to deliver accurate, actionable reporting that drives client performance and revenue growth.

Qualifications

• 4+ years of experience in media analytics or data preparation.
• Strong Python skills with Pandas for data manipulation.
• Proficiency in SQL and Excel.
• Experience with AWS and Linux environments.
• Experience with data visualisation tools; Looker Studio preferred.
• Bachelor's degree or equivalent.
• Strong analytical and communication skills.
• Ability to manage competing priorities in a fast-paced environment.

Responsibilities

• Develop, maintain and troubleshoot data notebooks.
• Extract, transform, validate and prepare campaign datasets.
• Run queries across AWS and BigQuery environments.
• Analyse relationships between media campaigns, sales performance and consumer data.
• Match media assets with tracking mechanisms and campaign KPIs.
• Create standardised and customised datasets, reports and data visualisations.
• Analyse campaign performance and provide observations and actionable insights.
• Manage multiple client accounts, projects and reporting deadlines.
• Collaborate with sales and data teams on media analytics.

Skills

Python (Pandas)

SQL

Excel

Looker Studio

Education

Bachelor's degree

Tools

AWS

Linux

Job description

Marketing Data Analyst – Media Campaign Analytics

Location: Remote, US (California-based position)

Salary: $49,920–$62,400 per year ($24–$30 per hour)

Employment Type: Full-time, permanent

Role Overview

An opportunity is available for a Data Analyst to support the delivery, measurement and reporting of complex, multi-platform media campaigns. The role focuses on preparing and analysing campaign data, building reporting notebooks and visualisations, and connecting advertising performance metrics with campaign KPIs, sales and consumer insights.

Working closely with data and sales teams, the analyst will deliver accurate, actionable reporting that supports client performance and revenue growth.

Key Responsibilities

• Develop, maintain and troubleshoot data notebooks.
• Extract, transform, validate and prepare campaign datasets.
• Run queries across AWS and BigQuery environments.
• Analyse relationships between media campaigns, sales performance and consumer data.
• Match media assets with tracking mechanisms and campaign KPIs.
• Create standardised and customised datasets, reports and data visualisations.
• Analyse campaign performance and provide observations and actionable insights.
• Manage multiple client accounts, projects and reporting deadlines.
• Collaborate with sales and data teams on media analytics.

Requirements

• 4+ years of experience in media analytics, data preparation or a relevant equivalent educational background.
• Strong Python skills, particularly Pandas, data importing/exporting, filtering and merging.
• Proficiency in SQL and Excel.
• At least 1 year of experience working with AWS and Linux operating systems.
• Experience with data visualisation tools; Looker Studio preferred.
• Bachelor's degree or equivalent college qualification.
• Strong analytical, problem-solving and communication skills.
• Ability to manage competing priorities in a fast-paced environment.
• Medical, dental and vision insurance.
• Life insurance options.
• Paid vacation, sick leave and company holidays.
• Employee Assistance Programme.
• Additional voluntary benefits and financial wellness programmes.