Manager, Media Analytics and Reporting
21 hours ago
New York
At Silverlight Digital, our mission is to connect healthcare professionals and patients with information about treatments that can improve lives. As an independent boutique digital media agency, we bring smart thinking, collaboration, and deep care for our craft to every client partnership. We build a culture where every voice matters, people take meaningful ownership, and we work toward a shared purpose: helping doctors and patients make informed treatment decisions. We plan, buy, and measure media across search, social, programmatic, CTV, and publisher direct, and we build every plan so the channels work together toward the brand’s business goal. Silverlight is organized around four pillars: Client Services, Omnichannel Strategy, Growth, and Finance. Each has a named leader and clear ownership, so clients get fast answers and our teams know exactly what they own and who they partner with. We work as a true extension of our clients’ teams. That means understanding not just campaign objectives, but the brand priorities, competitive dynamics, and people behind them, and building collaborative, high-trust partnerships that drive shared success. If you want to do meaningful work alongside a smart, dedicated team, we’d love to meet you. Overview The Manager, Media Analytics & Reporting owns the campaign data, dashboards, and client reporting behind our pharma and healthcare media programs. You will turn delivery and performance data from every channel in the media plan into dashboards and reports our clients trust, run the monthly and quarterly reporting cycle, and keep our BigQuery media data accurate as it grows. This is a hands-on role at a media agency. You should be equally comfortable reconciling a DSP’s delivery against our reporting, writing SQL to fix a campaign taxonomy issue, chasing a publisher for a missing file, troubleshooting GA4 conversion tracking, and building the dashboard a brand team opens before their quarterly review. This role does not own media strategy, channel strategy, campaign optimization, or measurement strategy. The channel leads stay accountable for those; this role owns the data and reporting they rely on. The role is remote, within commuting distance of New York City, with in-office team meetings and client meetings as needed. Responsibilities Client Reporting and Dashboards • Own client-facing dashboards that bring together paid search, paid social, programmatic, CTV, endemic and publisher-direct delivery, website analytics, and measurement partner data, • Build each dashboard around the brand’s media plan, audiences (HCP and patient), KPIs, and measurement plan, • Run the monthly and quarterly reporting cycle end to end: data collection, delivery reconciliation, analysis, and QA before anything reaches Client Services, • Turn campaign results into clear narratives on what happened, what changed, and what needs attention, for quarterly business reviews and client meetings Media Data and BigQuery • Maintain and extend the existing BigQuery media data environment so it stays accurate, documented, and reliable, • Write SQL to validate and reconcile delivery and spend across platforms, ad servers, publisher reports, dashboards, and client deliverables, • Maintain consistent campaign taxonomy, naming conventions, and field mappings across every channel and partner, • Trace reporting problems from the client output back to the source, and fix the root cause Partner Data and Tracking • Maintain and extend the data feeds already in place from platforms, DSPs, endemic publishers, and measurement partners, and add new sources as clients and partners come on, using APIs, connectors, SFTP feeds, cloud storage drops such as Amazon S3, and flat files, • Catch failed or late partner loads, and work with publishers and vendors to resolve them, • Support GA4 and Google Tag Manager setup and QA, including events, conversions, UTMs, and campaign parameters, before campaigns launch AI-Enabled Performance Insights • Build and improve AI-enabled workflows that flag pacing issues, delivery anomalies, and performance shifts from BigQuery, • Validate AI-generated insights, separating real campaign changes from tracking or data issues, • Set QA and governance standards so automated insights are accurate and explainable before media leads or clients see them Workflow Improvement • Identify manual reporting tasks that can be automated, and implement practical fixes, • Document data sources, business logic, and troubleshooting steps, and train the media team on routine reportingQualifications, • 4 to 6 years in media or marketing analytics, ideally at a media agency or in-house media team, • Built and maintained client-facing campaign dashboards in Looker Studio, Tableau, Power BI, or a similar platform, • Owned recurring monthly or quarterly media performance reporting, • Strong hands-on SQL, with Google BigQuery or a comparable cloud data warehouse, • Hands-on experience with data from Google Ads, Microsoft Ads, Meta, LinkedIn, DV360, and other DSPs or ad servers, including maintaining the feeds that carry it, • Strong working knowledge of GA4, conversion tracking, UTMs, campaign taxonomy, and tagging, • Pharma or healthcare media experience preferred, across HCP and patient campaigns, including endemic publishers and measurement partners, • Python or another scripting language a plusKey Skills, • Media delivery and spend reconciliation, • Campaign dashboard design, • SQL and data modeling, • Root-cause troubleshooting, • Explaining media results to non-technical teams and clients, • Automation and AI judgment Salary range: $85,000 to $110,000 base, depending on experience. Silverlight Digital is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or other fascinating characteristics that make us unique.