<ul><li>Built our last touch newbie attribution model in dbt. Along with repeat order attribution model.</li><li>Perform analysis into data quality or ETL issues arising from downstream stakeholder Looker dashboards.</li><li>Built and maintain 50 data models for a $10M datashare agreement.</li></ul>

Senior Analytics Engineer

● Within DBT, imported data sources & created scoring methodology for internal MTA model. Showing fractional units & CAC split by 25 different media channels, allowing the business to optimize at Ad level granularity.
● Created digital app ELT pipelines using Fivetran connectors, dropping data into Redshift tables for analysis.
● Set up Airflow DAGs to orchestrate SQL & Python scripts, building data models for data science teams.
● Built data models using Looker ML & manage Looker data quality for all app related data.

Built an anomaly detection tool in Python, utilizing a 2 step automated ETL pipeline. Detecting device specific incidents at an 85% faster rate.
● Developed multiple new metrics for the product and tech team, measuring product health and user engagement.
● Utilized scheduling tools to create dozens of optimized ETL pipelines, automating SQL and Python scripts.
● Worked in Snowflake & built dozens of complex Tableau dashboards, using advanced functionalities and actions.
● Independently manage partnership stakeholder relationships with respect to optimization of product features, product
health, and insight generation.

● Led effort to re-design marketing attribution data pipeline ETL – worked with 3rd party marketing attribution vendor Kochava & internal engineering team, allowing for faster and more real time marketing optimizations.
● Created and executed paid media optimization plan & sensitivity analysis for Google Search, Apple Search and Bing, resulting in $100k+ / month savings and a 50% increase in efficiency of KPI metric Cost Per Quality User.
● Created automated Tableau dashboard mapping registration attribution, by platform (iOS, Android, Web), as well as onboarding experience, identifying platform / acquisition method specific opportunities to improve onboarding.
● Performed sentiment analysis using Python to measure sentiment around brand term on twitter, helping measure the
impact of our $5.4M marketing campaign efforts.
● Create automated Tableau dashboards and perform KPI ad hoc requests for internal executive leadership, external
partner studios (Disney, NBC Universal, Warner Bro’s, Sony Pictures, and 20th Century Fox), as well as retailer partners (Amazon, Apple, Google Play, Microsoft, Fandango, Vudu, and Comcast).

Personal details

Eric P.

Summary

Technical skills

Work Experience