We're hiring a data analyst to build client-facing dashboards and manage reporting across paid social, paid search, and programmatic campaigns. You'll write SQL against our data warehouse, use Python to automate reporting pipelines, and join client calls to explain performance trends and data discrepancies in plain language.

Reporting & Visualization • Build and maintain client-facing dashboards in our BI/dashboarding environment, translating multi-platform media data into clean, navigable performance views • Own the reporting cadence for assigned accounts: weekly pacing reports, monthly performance summaries, and ad hoc analyses as needed • Design reporting frameworks that scale — not one-off builds that only you can maintain • Document data logic, calculated fields, and methodology so outputs are auditable and explainable Data Engineering & Pipeline Work • Write and maintain SQL queries against our cloud data warehouse to pull, clean, and structure media performance data for reporting • Contribute to the ongoing work of streamlining and centralizing our reporting pipelines • Use Python for data transformation, automation, or light analytical tasks where SQL alone isn’t the right tool • QA your own work and flag data integrity issues proactively — you’re a first line of defense before numbers reach clients Media Data & Platform Fluency • Work directly with data from major ad platforms across paid social, paid search, programmatic, and emerging channels • Understand the measurement nuances of paid media data — attribution windows, modeled vs. observed conversions, platform discrepancies • Collaborate with activation and strategy teams to ensure reporting reflects actual media executions accurately

• 2–3 years of experience in a data, analytics, or reporting role, ideally at a media agency, ad tech company, or in-house media team • Proficiency in a modern BI/dashboarding tool: you can build production-quality dashboards from scratch, not just modify existing templates • Strong SQL skills: comfortable with joins, aggregations, window functions, and debugging queries against large tables • Hands-on experience with paid media data from at least two major advertising platforms (across paid social, paid search, programmatic, or similar) • Working knowledge of Python for data wrangling, automation, or analysis • Understanding of core media metrics and how they are measured differently across platforms (impressions, CPM, ROAS, CPA, viewability, etc.) • Strong attention to detail and a compulsion to QA your own work before it goes out the door • Comfortable communicating directly with clients and explaining data clearly