Job Description

​

The Marketing Data Analyst is responsible for transforming marketing and business data into clear, actionable insights. This role sits at the intersection of data engineering, analytics, and marketing strategy—Supporting internal teams and clients by building reliable datasets, writing advanced SQL queries, and developing dashboards that drive decision-making. This individual will work closely with media, analytics, and leadership teams to ensure performance is measured accurately and insights are delivered consistently.

At Cannonball, we value thinkers and doers, people who not only generate big ideas but also bring them to life. In return, you’ll join a team of 45+ passionate Cannonballers committed to creating excellent work and making clients insanely happy.

Minimum Qualifications

• 3+ years writing advanced SQL queries in production environments
• 2+ years querying large-scale datasets (10M+ rows typical)
• 2+ years working in a cloud data warehouse environment
• 2+ years building dashboards in Looker Studio, Tableau, Power BI, etc
• 2+ years working directly with paid media platforms like Meta, Google Ads, DV360, Linkedin, GA-4, etc
• 2+ years translating raw data into clear insights and recommendations
• 2+ years validating data accuracy and troubleshooting discrepancies

Preferred Experience

• 1+ year hands-on experience in BigQuery strongly preferred
• Experience with Google Cloud Platform (GCP)
• Familiarity with ETL/ELT tools or data pipelines
• Experience working with GA4 event-level data
• Knowledge of marketing attribution and measurement frameworks (incrementality, MMM, etc.)
• Experience supporting agency or multi-client environments
• Python or scripting experience for data manipulation and automation

Requirement
Must live in the metro St. Louis area (or be willing to relocate) and work from the Cannonball office at least three days per week, with flexibility based on client and team needs.

To Apply:

Please email your resume to Kris Hoelscher, Human Resources Manager
kris.hoelscher@cannonballagency.com

Note: This job description outlines the general nature and level of work expected in this role. It is not an exhaustive list of responsibilities, duties, or qualifications. Team members may be required to perform other duties as assigned.

Equal Opportunity Employer
Cannonball is committed to providing equal employment opportunities to all employees and applicants without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, marital status, amnesty, or veteran status.

All offers of employment are contingent upon a satisfactory background check.