Senior Paid Media Analyst at The Avalon Consulting Group, LLC | Annapolis, MD | $95K/yr – $110K/yr

Senior Paid Media Analyst

Annapolis, MD (Remote)

$95K/yr – $110K/yrSenior Level4+ years expFull time

Posted 7 weeks ago

Top 1% of applicants do these two things.

The other 99% submit and hope. You're about to do something different.

Job Summary

Own cross-channel measurement and reporting data flow, turning ad server, paid media, email, and web analytics into reliable dashboards and actionable fundraising insight.

Data Architecture: Build and maintain pipelines that feed unified views across ad servers, paid media, email, and web analytics.
Attribution & Insights: Develop de-duplicated conversion data and multi-touch attribution to guide optimization for donors and campaigns.
Reporting Excellence: Keep Tableau dashboards and ETL processes healthy, reconciled, and scalable for internal and client teams.

Job Description

Responsibilities

Lead the integration and ongoing management of ad server data into Avalon’s broader reporting ecosystem.
Build and maintain data pipelines that integrate ad server, paid media, email, and web analytics data.
Analyze de-duplicated conversion data and support the development of multi-touch attribution models that provide a more complete understanding of supporter behavior.
Maintain, troubleshoot, and enhance Avalon’s digital reporting environment, including Tableau dashboards and ETL workflows.
Ensure the integrity, consistency, and reconciliation of data across digital platforms, ad servers, ETL tools, and internal databases.
Develop scalable reporting solutions that enable internal teams and clients to confidently understand performance.
Analyze paid media, email, and cross-channel performance to identify trends, opportunities, and areas for optimization.
Translate complex analytical findings into actionable recommendations for Digital and client teams.
Support testing, forecasting, attribution analysis, and measurement initiatives that improve fundraising outcomes.

Requirements

approximately 4-6 years of experience in digital analytics and paid media measurement and analysis.
Experience working with paid media, email, web analytics, and digital marketing datasets.
Advanced SQL/T-SQL skills and experience working with large, complex datasets.
Experience building and maintaining Tableau dashboards and reporting solutions.
Hands-on experience with ad server implementation, management, and reporting.
Experience with ETL tools and data ingestion platforms such as Hevo, FiveTran, Windsor, Funnel, or similar.
Experience identifying, troubleshooting, and resolving data discrepancies across reporting environments.
Strong understanding of attribution methodologies, conversion tracking, and digital measurement frameworks.

Preferred

Experience working with de-duplicated conversion data and multi-touch attribution models.
Experience designing data structures, field mappings, and reporting frameworks that support scalable analytics.
Understanding of platform attribution differences across paid media and email environments.
Experience supporting nonprofit fundraising, donor acquisition, or direct response marketing programs.
Python programming experience.
Experience pulling and processing data through APIs.
Experience with forecasting, scenario modeling, marketing mix modeling, or incrementality testing.
Experience working with other data visualization tools such as Looker Studio.

Benefits

comprehensive benefits package, including employer-paid health, dental, and vision insurance
generous paid leave
remote work reimbursements
employer-paid life and disability insurance
safe harbor 401(k) plan