Remote Position
[Remote] Intelligence Developer, Paid Media
🌍 Remote · United States
💼 Full-time
Note: The job is a remote job and is open to candidates in USA. Aquent is recruiting for a 12-month contract role with an unnamed client’s VizOps team. The Intelligence Developer owns the certified data source layer for paid media data, builds Tableau dashboards, supports affiliate commission reconciliation, and maintains related data and team infrastructure.
Responsibilities
- Own the Certified Data Sources: maintain the Tableau Prep flows built on the paid-media data warehouse, add fields and joins, standardize dimensions and metadata, and keep the semantic layer analysts depend on reliable
- Design, build, and iterate Tableau dashboards for LoB stakeholders. Work from a project spec through fixed beta cycles,and follow VizOps visual and development standards
- Investigate and resolve recurring data accuracy issues, including periodic payments-business data QA cycles andquarterly wrap reporting
- Run monthly affiliate commission reconciliation (streaming video and music programs, via Partnerize) and supportannual PO setup
- Find data issues and route them to the owning platform team through the standard ticket process. Document the likely root cause, but don't fix upstream data yourself
- Build and maintain team infrastructure: data-connector alerting, data-sharing documentation, and lightweightPython/SQL automation
- Plan and track work in the team's project management system. Take part in sprint planning, weekly WIP reviews, and peer review
Skills
- 5+ years in marketing analytics, media reporting, or BI development
- Advanced Tableau: data modeling, published data sources, Prep, LODs, performance tuning, and dashboard design
- A portfolio of interactive Tableau dashboards you built, available to review live
- Strong SQL
- Familiarity with paid media KPIs and cost metrics across Display, Video, Social, SEM, and Affiliate
- Comfortable using AI tools in daily analytics work
- Python for automation is a plus
Benefits
- 401k w/ match
- Remote in Culver City, CA
Company Overview
Company H1B Sponsorship