Media Analyst
Mars United Commerce
SQLTableau
Media Analyst
Mars United Commerce
full-time
Posted on:
Location Type: Hybrid
Location: Dallas • Missouri, Texas • 🇺🇸 United States
Visit company websiteSalary
💰 $72,390 - $99,960 per year
Job Level
JuniorMid-Level
Tech Stack
AzureCloudSQLTableau
About the role
- Collect, clean, and analyze data from various media platforms
- Audit advertising campaigns, troubleshoot performance issues, and track/report on KPIs
- Deliver best-in-class campaign reporting and insights to enable data-driven media mix decisions
- Work with stakeholders to understand data needs and deliver actionable insights and recommendations
- Ensure data accuracy and integrity across all reports, dashboards, and visualizations
- Support media planning initiatives and provide consultation to Commerce Media planning and buying teams
- Partner with Commerce Media to discuss advertising performance and continuously improve digital media analytics products and services
- Write and approve proposals and presentations, oversee work, and help drive growth of the department
- Assist in knowledge sharing through internal communication events, training, and other written materials
- Maintain relevant marketing certifications and support wider agency initiatives
Requirements
- Bachelor’s degree in data analytics, statistics, mathematics, or a related field
- 2-5 years of experience in media data analysis or a related role
- Proficiency in SQL for querying media performance data and developing custom audiences
- Experience with BI tools such as Tableau and Power BI for data visualization
- Strong skills in Excel for data manipulation and reporting
- Demonstrated experience in media analytics methodologies like Multi-Touch Attribution (MTA), Audience Development, Clustering, Markov Chain analysis
- Familiarity with core media marketing concepts (first-party and third-party cookie-based data collection, attribution models, audience segments)
- Knowledge of retail media ecosystems and platforms such as Amazon, Walmart, Target, Kroger and third-party tools like SKAI, Pacvue, or Criteo
- Experience or familiarity with primary tools: Amazon Marketing Cloud, Walmart Scintilla, Azure Synapse, PowerBI, LiveRamp, Retail Media Platforms (Criteo, The Trade Desk, etc.)
- Maintain relevant marketing certifications and stay informed of media trends, tools, and methodologies
- Strong analytical thinking, attention to detail, excellent communication skills, and collaborative mindset
Benefits
- comprehensive group health plans
- parental leave program that includes paid maternity and paternity benefits for pregnancy, adoption and surrogacy
- flexible paid time off
- broad and confidential employee assistance program
- ongoing wellness support initiatives
- trusted financial health advice and guidance
- promotion of education through tuition support and assistance
- flexible and supportive work environment and culture
- medical coverage, dental, vision, disability for regular roles
- 401k for eligible roles
- temporary roles may be eligible for freelancer/temporary employee medical plan through a third-party benefits administration system
- temporary roles may qualify for participation in our 401(k) plan after eligibility criteria have been met
ATS Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data analysisSQLdata visualizationExcelMulti-Touch AttributionAudience DevelopmentClusteringMarkov Chain analysisdata manipulationreporting
Soft skills
analytical thinkingattention to detailcommunication skillscollaborative mindset
Certifications
marketing certifications
