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