Worked with early-stage startups on data engineering projects. Primarily focused on marketing attribution work, relying on Segment and DBT to collect data and develop analytics pipelines in a scalable manner.

All things data... From building data pipelines, to analytics requests, and everything in-between.- Maintained, and scaled internal analytics pipelines to provide data for SEO program, and transitioned the processing from Postgres to Bigquery.- Created marketing attribution infrastructure, relying on Segment to track specific web events and DBT to create data models. - Built Airflow processes to export data from custom internal tools, and into the Google Cloud ecosystem (GCS, BigQuery) for further processing. - Adhoc data pipeline projects around Google Adwords conversion uploads, transfer of data to external partners, etc.- As an expert in most aspects of company data, provided analytics support as needed.

Focused on marketing, cross-channel attribution, growth, data, etc.

- Managed over 40% of company-wide SEM spend, optimizing spend for 450,000+ clicks per week- Identified SEM growth opportunities through analysis of internal and external search trend data - Recommended new tests and landing pages to Product, providing detailed opportunity sizing estimates- Collaborated with SEM team to test bidding strategies and adcopy concepts across verticals, and rolled-out winning recipes- Leveraged and created stored procedures, views, CTEs, temporary tables, and other SQL mechanisms to efficiently query against hundreds of millions of rows of data across multiple databases and warehouses- Partnered with CRM to devise a cross-channel attribution model for email subscribers collected by SEM campaigns- Mentored junior team members, providing project direction and troubleshooting test setup/tracking issues

- Independently managed ~20% of company-wide SEM spend, bidding on millions of keywords to profitable levels- Partnered with product team to brainstorm landing page test ideas, and analyzed results data pulled - Executed A/B landing page tests, developing the JavaScript code necessary to manipulate webpages upon load

- Developed Excel reports to categorize retention emails and easily compare them with statistically significant testing - Coded SQL procedures to define customer segments and count the associated sends, opens, clicks, product orders, and unsubscribes for any specified email campaign - Created business QA and user acceptance testing plans for major functionality launches of new email technologies- Prospected and interviewed consulting firms to guide multiyear, $2.2MM implementation of new email technologies - Presented proposal to save an incremental $30,000 annually by developing internal tracking of mobile email engagement- Championed and coordinated implementation of a monitored email address for all replies received from retention emails- Prioritized the change management queue for the larger CRM marketing organization for each 3-week release cycle

- Managed client relationships by translating business objectives to technical requirements for project execution- Coordinated up to 6 simultaneous internal projects, each requiring 40 to 500 web developer hours- Integrated a 3rd party multivariate testing solution to increase the customer conversion rate from landing pages by 5%- Researched and drafted proposals of future projects to provide senior management with strategic planning information- Organized problem management efforts with Barcelona office to prevent lost sales of over $10,000 per day- Facilitated project postmortem meetings to reflect on and record successes and failures- Communicated project objectives, statuses, progress, and outcomes on an ongoing basis using an internal mediawiki

- Assisted in creation of 2011 and 2012 promotional business planning for Listerine, Rembrandt and Reach brands- Analyzed past sales data using Excel to evaluate potential success of future promotions - Developed and distributed daily promotional sell-through reports for management- Created budget to monitor all oral care promotional expenditures- Focused on advancing a strategic future promotion for a platinum customer account- Acted as a liaison between various internal groups and customer teams

- Represented brand at trade shows with upwards of 10,000 consumers and industry professionals in attendance- Engaged consumers using social media outlets such as Facebook and Twitter- Facilitated re-launch of company website and provided ongoing maintenance- Prepared weekly company e-newsletters showcasing online promotions