Designed ELT pipeline for Marketing department on Google Cloud Platform, including data extraction via APIs, data modeling in DBT, warehousing in BigQuery, and actionizing transformed data through marketing automation, powering new revenue streams through workflows such as abandoned cart emails. Overhauled and executed Marketing department’s end-to-end survey processes, including stakeholder requirement gathering, survey build and data collection in SurveyMonkey, data prep and modeling in R and PowerQuery, and data visualization in PowerBI and Looker Studio, saving 15 hours per month compared to previous processes. Implemented Marketing department’s GA4 property and GTM account from the ground up, including training colleagues on tag creation, unlocking GA4 enhanced ecommerce data through datalayer manipulation via custom JavaScript solutions saving over $2,000 in web agency costs, and creating web dashboards in Looker Studio with custom Closed Funnel Analysis and Rule-Based Acquisition Modeling. Developed a structured data strategy and data governance principles for the Marketing department, supporting a future of data-driven decision-making and advanced analytics capabilities, including predictive and prescriptive modeling.

Lyric Opera of Chicago | May 2022 - Present

Digital Marketing Manager

Managed Development department’s web content via EpiServer CMS, creating pages for events and fundraising initiatives, customized visitor content, and forms with marketing automation, supported by low-level HTML Boosted Giving Tuesday campaign donations by 94% YoY through customer journey optimization by increasing campaign access points, removing conversion barriers, and driving traffic to campaign-specific landing pages. Developed new reporting practices for the annual fund team by deploying Looker Studio and Microsoft Power BI to blend data sources to create comprehensive data-driven narratives.

My Education

Take a look at my formal education

Bachelors of Music in Vocal PerformanceDePaul University | 2017

About Me

Marketing data practitioner with expertise in analytics, automation, and data transformation, delivering actionable insights, streamlined processes, and revenue growth through advanced data solutions.

Create Your Data Portfolio for Free

Erik Dohner

Associate Director of Analytics

Lyric Opera of Chicago | Chicago, IL

Tessitura Conference 2024 Presentation

Tessitura Conference 2024 Presentation

Building to a better future, one dataset at a time

My Work

ETL Project: SurveyMonkey to BigQuery

Data in Action: Abandon Cart Automation with BigQuery and ActiveCampaign

JavaScript in GTM

Transforming Survey Data in R

Tessitura Conference 2024 Presentation

BigQuery: Transforming raw GA4 data for analysis

ETL Project: ActiveCampaign to BigQuery

Marketing ELT Pipeline Architecture

ETL Project: SurveyMonkey to BigQuery

My Certifications

Data Engineer Associate

Data Engineer

Data Analyst Associate

Other Certificates

DataCamp Course Completion

Courses

Courses

Tracks

Projects

My Work Experience

Lyric Opera of Chicago | Apr 2023 - Present

Associate Director of Analytics

Lyric Opera of Chicago | May 2022 - Present

Digital Marketing Manager

My Education

About Me