Intelligence Developer, Paid Media

Step into a pivotal role where your analytical expertise will directly shape the marketing strategies of a global technology leader. Aquent has partnered with an industry-defining pioneer known for creating revolutionary products that connect millions of people worldwide. In this dynamic position, you will not just analyze data-you will build the very foundation of truth that guides major strategic investments across all paid media channels, translating complex data sets into highly visual, actionable narratives that drive global impact.

The Opportunity

Our client is at the forefront of digital innovation, constantly setting new standards for technology and user experience. By joining this high-performing analytics and information design team, you will collaborate with brilliant minds in a fast-paced, agile environment. This role offers the perfect blend of technical challenge and creative problem-solving, giving you the platform to elevate business intelligence and directly influence global marketing spend.

What You'll Do

• Champion the integrity and reliability of certified data sources by maintaining and evolving Tableau Prep flows, enriching data with new fields and joins, standardizing dimensions, and ensuring a robust semantic layer for analysts.
• Design, develop, and continuously refine compelling Tableau dashboards for various business stakeholders, adhering to established visual and development standards throughout fixed beta cycles.
• Investigate and pinpoint the root causes of data accuracy discrepancies, actively participating in regular data quality assurance cycles and quarterly reporting efforts.
• Lead the monthly reconciliation process for affiliate commissions related to digital content programs, utilizing platforms like Partnerize, and provide essential support for annual purchase order setups.
• Proactively identify and document data anomalies, routing issues to the appropriate platform teams for resolution while providing insights into potential root causes.
• Contribute to the enhancement of team infrastructure, including developing data-connector alerts, documenting data-sharing protocols, and building lightweight automation solutions using Python and SQL.
• Actively participate in agile workflows, including sprint planning, weekly work-in-progress reviews, and peer feedback sessions, ensuring timely and effective project delivery.

Must-Have Qualifications

• 5+ years of dedicated experience in marketing analytics, media reporting, or business intelligence development.
• Advanced proficiency in Tableau, encompassing data modeling, publishing data sources, Tableau Prep, Level of Detail (LOD) expressions, performance tuning, and exceptional dashboard design skills.
• A compelling portfolio of live, interactive Tableau dashboards that showcase your expertise and design philosophy (such as a Tableau Public profile, live workbook links, or a packaged .twbx file).
• Strong command of SQL for data extraction, manipulation, and analysis.
• Familiarity with key performance indicators (KPIs) and cost metrics across diverse paid media channels, including Display, Video, Social, Search Engine Marketing (SEM), and Affiliate marketing.
• Comfort and experience utilizing AI tools to enhance daily analytics workflows.

What Will Set You Apart

• Proficiency in Python for automation tasks and advanced data manipulation.