•Built ETL pipelines providing provider directory and insurance plan data into the core data warehouse for multiple insurance providers•Contributed toward massive conversion of codebase from MySQL to Postgres to leverage Greenplum.•Designed data architecture and built custom features for several large customers. •Refactored and optimized provider directory data loaders through implementation of parallel processes and improvements to SQL.

•Work primarily with the Search Engine Marketing Team providing in depth analysis of large data sets for each of our clients. Optimize account structure, keyword performance, and bid policies to meet client performance metrics. •Use Google Analytics to quantitatively and qualitatively evaluate landing page design, site navigation, potential marketing channels, and customer behavior in order to drive customer acquisition. •Create dashboards and bi-weekly reports using Excel, Google Analytics, and Salesforce for both internal use and also for client’s Sales and Management teams.•Perform and present comparative analysis of competitor’s digital marketing efforts to assist in budget allocation and strategy including marketing channels targeted, keyword inventory, ad copy, and landing pages.