Manager, Data Analytics

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, Data & Analytics owns the data, dashboards, and reporting behind our omnichannel media programs. This role builds and maintains client dashboards, runs the monthly and quarterly reporting cycle, keeps our BigQuery data accurate and reliable, and automates how performance insights reach the media and client teams.  

This is a hands-on role. You should be equally comfortable investigating why numbers do not reconcile, writing SQL to validate a dataset, working with a vendor to repair a data feed, troubleshooting GA4 tracking, and building a client-facing dashboard.  

The ideal candidate has built dashboards and reporting for multichannel media programs, and enjoys making the work more accurate, faster, and easier to scale.  

Responsibilities  

Dashboards and Reporting  

• Own client-facing dashboards across paid search, paid social, programmatic, endemic and direct publishers, website analytics, and measurement partners  
• Build dashboards around each client’s KPIs and measurement plan, on a consistent agency standard  
• Run the monthly and quarterly reporting cycle end to end data collection, validation, reconciliation, analysis, and QA  
• Turn results into clear narratives on what happened, what changed, and what needs attention, with Media and Client Services  

Data Management and BigQuery  

• Maintain the accuracy, structure, and documentation of media and reporting data in BigQuery  
• Write SQL to validate, transform, and reconcile data across platforms, vendor reports, dashboards, and client deliverables  
• Maintain consistent campaign taxonomy, naming conventions, and field mappings  
• Trace reporting problems from the client output back to the source, and fix the root cause  

Integrations and Tracking  

• Monitor data flows from platforms, publishers, endemic partners, and measurement vendors, and resolve failed or late loads with vendors  
• Support GA4 and Google Tag Manager setup and QA, including events, conversions, UTMs, and campaign parameters  
• Partner with our data engineering partner on pipeline architecture and new integrations  

AI-Enabled Insights  

• Build and improve AI-enabled workflows that surface trends, anomalies, and pacing issues from BigQuery  
• Validate AI-generated insights, separating real performance changes from tracking or data issues  
• Set QA and governance standards so automated insights are accurate and explainable  

Workflow Improvement  

• Identify manual reporting tasks that can be automated, and implement practical fixes  
• Document data sources, business logic, and troubleshooting steps, and train team members on routine reporting  

Qualifications  

• 3 to 5 years of experience in marketing or media analytics, business intelligence, or marketing technology  
• Built and maintained client-facing dashboards in Looker Studio, Tableau, Power BI, or a similar platform  
• Owned recurring monthly or quarterly marketing performance reporting  
• Strong hands-on SQL, with Google BigQuery or a comparable cloud data warehouse  
• Strong working knowledge of GA4, conversion tracking, UTMs, campaign taxonomy, and tagging  
• Experience with data from Google Ads, Microsoft Ads, Meta, LinkedIn, DV360, and other DSPs through APIs, connectors, or SFTP feeds  
• Pharma or healthcare media experience preferred, across HCP and patient campaigns  
• Python or another scripting language a plus  

Key Skills  

• Data validation and reconciliation  
• Dashboard design and development  
• SQL and data modeling  
• Root-cause troubleshooting  
• Clear communication with non-technical teams  
• Automation and AI judgment  

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.