Lead the architecture and delivery of a centralized, interoperable data foundation across Salesforce (CRM), AdPoint (OMS), Google Ad Manager (GAM), Meta, and other media platforms.
Design and govern APIs and services that enable seamless interoperability, campaign workflows, pacing, status tracking, delivery reporting, and discrepancy management.
Architect and oversee scalable data pipelines on Google Cloud into BigQuery (batch and near-real-time), ensuring monitoring, lineage, auditability, and SLA adherence.
Build and maintain a finance-grade reporting layer powering Looker and Domo; standardize and govern metric definitions (booked, delivered, billed, pacing, forecast, yield).
Drive automation of data ingestion, transformation, reconciliation, and quality controls to reduce manual processes and improve root-cause analysis.
Establish consistent identifiers, mapping rules, and entity resolution frameworks across systems to enable a single source of truth.
Lead and mentor a small NYC-based engineering team while coordinating sprint execution with outsourced development partners.
Partner closely with Revenue Operations, Finance, Marketing, and Product to prioritize roadmaps and deliver scalable, business-aligned solutions—including exploring AI/ML applications for anomaly detection, forecasting, deduplication, and operational automation.
Requirements
Deep experience (12+ years) in data architecture and/or data engineering, including hands-on work within ad tech or publisher revenue workflows.
Proven success integrating Salesforce, OMS platforms (AdPoint or similar), and Google Ad Manager to enable operational interoperability and reporting.
Strong understanding of ad operations data structures and processes (campaign hierarchies, trafficking, delivery, pacing, discrepancies).
Advanced expertise building data products on Google Cloud, with BigQuery as a core warehouse solution.
Strong SQL, canonical and dimensional data modeling skills, and a commitment to auditability and finance-grade accuracy.
Demonstrated ability to lead teams and deliver results using a combination of in-house and outsourced engineering resources.
Clear communicator who can translate complex technical concepts into business-aligned solutions; skilled in documentation including data contracts, runbooks, and architecture diagrams.
Experience with Looker modeling/semantic layers and/or Domo governance preferred.
Familiarity with GAM reporting APIs, log-level data, MDM/entity resolution, or applied AI/ML for automation and forecasting is a plus.
Ability to work in-office in New York City 4 days per week.
Tech Stack
BigQuery
Cloud
SQL
Benefits
Work with the Best: Collaborate with top-tier professionals across media, advertising, tech, fashion, lifestyle, and publishing, shaping the future of these dynamic industries.
Grow Your Skills: Unlock your potential with access to innovative training programs, immersive workshops, and exclusive industry events.
Work-Life Harmony: Enjoy the flexibility of hybrid work, empowering you to balance professional success with personal priorities.
Foster Connection & Belonging: Join our Employee Resource Groups and help create a welcoming workplace where everyone feels valued and empowered.
Wellness First: Prioritize your well-being with a comprehensive benefits package that includes medical, dental, and vision insurance from Day 1.
Plan for Your Financial Future: Enjoy competitive financial perks, including a 401(k) plan with a generous company match.