Data Analyst

A leader in the marketing and advertising industry is hiring a Data Analyst in Saint Louis, MO, for a full-time, hybrid position.Summary:This role sits at the intersection of data engineering, analytics, and marketing strategy.Responsibilities:Transform marketing and business data into clear, actionable insights. Support internal teams and clients by building reliable datasets, writing advanced SQL queries, and developing dashboards that drive decision-making. Work closely with media, analytics, and leadership teams to ensure performance is measured accurately and insights are delivered consistently.Minimum Qualifications:3+ years writing advanced SQL queries in production environments2+ years querying large-scale datasets (10M+ rows typical)2+ years working in a cloud data warehouse environment2+ 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 recommendations2+ years validating data accuracy and troubleshooting discrepanciesExcellent communication skillsComfortable being client-facing and presenting findingsPrevious agency, advertising, and/or marketing industry experience is requiredPreferred Experienced:1+ year hands-on experience in BigQuery strongly preferredExperience with Google Cloud Platform (GCP)Familiarity with ETL/ELT tools or data pipelinesExperience working with GA4 event-level dataKnowledge of marketing attribution and measurement frameworks (incrementality, MMM, etc.)Experience supporting agency or multi-client environmentsPython or scripting experience for data manipulation and automation