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.
• Qualified applicants will reside in the United States and will be legally authorized to work in the U.S. at the time of hire. Avalon is unable to sponsor employment visas or provide immigration-related employment sponsorship at this time.

Benefits

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