Analyst, AMC Commerce

Company Description

Spark Foundry is the agency that is shaped by ideas. We believe everyone’s ideas are powerful - big or small. Our knack for exploring them makes us better.

We strongly believe in collaboration, where a thriving working relationship leads to everyone’s best work. Luckily, this conviction attracts likeminded clients and talent to create a positive and magnetic team.

We’re constantly adapting to each of our clients’ businesses’ needs to avoid stagnation. This ensures that our clients get the best service to tackle their future-facing challenges and that our team stays on their toes.

Above all, we love to go above and beyond what’s expected of us. We’ve done this through media innovation that is recognized by both the industry and by our clients who reap the benefits.

The near future is very bright for Spark Foundry, whether that’s a result of Publicis Groupe’s investment in groundbreaking global & local tools and data solutions or because of the contagious momentum amplified by new team members and new clients.

Overview

The Analyst, AMC Commerce will support media and retail analytics through data modeling, data visualization, and clean room environments. This role is responsible for transforming complex datasets into actionable insights, supporting audience development, measurement, and data-driven decision-making across client initiatives.

Responsibilities

• Definition and automation of data analysis extracts for media and retail within data clean rooms.
• Creation of a data model enabling the ingestion and consolidation of data from various retail sources for visualization and analysis purposes.

• Collect, clean, and analyze data from various media platforms.
• Work with stakeholders to understand data needs and deliver actionable insights.
• Ensure data accuracy and integrity across all reports, dashboards, and visualizations.
• Critical thinking to analyze data and derive meaningful media insights.
• Communicate findings and recommendations clearly to stakeholders.
• Support media planning initiatives, including tactical and audience planning.
• Assist in knowledge sharing through internal communication events, training, and other written materials.
• Maintain relevant marketing certifications and stay informed of media trends, tools, and methodologies.
• Write queries in clean rooms and other platforms to build custom audiences and measurement models such as Multi-touch attribution, Markov Chain, Incrementality models, etc.
• Support wider agency and client initiatives.
• Show up - be accountable, take responsibility, and get back up when you are down.
• Make stuff.
• Share so others can see what’s happening.

Qualifications

• 3 years of experience in Data Analysis
• Familiarity with Amazon Marketing Cloud (AMC)
• Familiarity with clean room technologies
• Advanced knowledge of Python (NumPy, Pandas, cloud SDKs)
• Advanced knowledge of SQL (window functions, DML)
• Knowledge of a cloud analytics stack (GCP/AWS), ideally GCP:
• Data storage services (data lake & data warehouse), data transfer, data processing, machine learning
• Knowledge of Data Visualization, in Python and/or with data visualization tools (Power BI, Tableau, Looker, QuickSight)
• Knowledge of API querying (Python “requests” library, cloud SDKs, Postman)
• Critical thinking and experience with exploratory data analysis
• Professional working proficiency in English

Optional Qualifications

• Knowledge of web application development
• Knowledge of the media and advertising industry
• Knowledge of statistics and Machine Learning
• Knowledge of MLOps, including automation and monitoring of statistical models
• Knowledge of agent-based tool development

Additional Information

Salary

Transparency matters to us. The salary range for this position is $50,000-$60,000 per year. Actual compensation within this range will be based on a variety of factors, including relevant experience, knowledge, skills, and applicable certifications. This range reflects what we reasonably expect to offer based on current market data.

AI Use

We use artificial intelligence (AI) tools to support parts of our hiring process, such as reviewing applications or analyzing resumes. These tools assist our recruitment team but never replace human decision-making. We believe in a human-first approach, where your experience and potential are recognized by people.

Spark is an equal opportunity employer with a strong commitment to diversity and inclusion. We create and nurture a vibrant work environment that celebrates, values and leverages all aspects of diversity and inclusiveness, attracts world-class talent and serves as the industry benchmark for best practices. We encourage applications from all qualified individuals and will provide appropriate accommodation for candidates with disabilities or accessibility needs throughout the recruitment process, upon request. Please contact our recruiter for any questions, accommodations or specific requests. We thank all candidates for their interest in Spark however, only those candidates selected for an interview will be contacted.