Marketing Data Analyst Resume Examples

Marketing Data Analyst

Develops and deploys customer targeting models for product campaigns using the IBM SPSS data modeling software. Provides return on investment analyses on campaign efforts and presents results to the Product and Advertising teams. Supports ad-hoc reporting as needed and administers the integration of marketing communication materials with internal electronic systems.

• Generated $4M in wealth management sales with the implementation of a new targeting model.
• Identified $13M cross-sell opportunity that led to the investigation and implementation of a credit card redesign effort.
• Leveraged advanced MS Excel skills to provide analytics on routine product campaigns and their return on investment; performed quarterly reporting of the customer website using Google Analytics.

Senior Marketing Data Analyst

• Relationship manager for LiveRamp - measuring performances of online marketing campaigns; optimized data flow from Dish to LiveRamp to Adobe Audience Manager, by ensuring data consumption standards are consistent across the board, and expectations are aligned
• Led project to streamline campaign fulfillment process using Workfront and successfully implemented across a Marketing department of 100+ individuals; saving numerous man hours, and increasing efficiency by 120%
• Audited past acquisition and up-sell campaigns, saving the organization $200,000 (~10%) per campaign in 2015; ensuring optimized customer targeting
• Improved household address matching leading to savings worth $170,000
• Identified new markets for internet services using FCC data, and competitive analysis; increasing target market by 20%
• Analyzed a consumer panel of 15,000 subscribers, defined by A/B testing, and identified KPIs for customer acquisition, retention and loyalty
• Generated reports to present findings to C-level execs, using Microsoft Excel, and Tableau; highlighting behavioral patterns and quality of acquired customers during a Price Lock campaign

Marketing Data Analyst

• Managed Grassroots marketing team such as scheduling, communication, and assigned activities as required.
• Used Excel to create and gather reports with heavy data to present to higher management (Pivot tables, V-lookups, create reports using Access, and formulas to manipulate data).
• Generated daily, weekly, and monthly reports using Excel and Powerpoint to send out to the internal teams, which highlight sales, profit, monthly targets, and related data.
• Reconciled data between reports and various Verizon internal data sources. Ensured accuracy of reporting and research; analyzed and resolved discrepancies.
• Utilized internal client reporting structures such as AMDB, BDMS and any other additional databases identified as necessary.
• Facilitated program reporting, database manager and internal communications as directed through higher management.

Sales and Marketing Data Analyst

• Carried out in-depth research to develop market entry strategies for a new business line, increased market penetration in 32 states
• Utilized data analysis and visualization tools (incl. tableau) to deliver actionable insights for business development, created customizable programs for 5 major clients to increase retention
• Worked closely with IT, Sales and Marketing teams to automate and optimize key workflows to identify costs, results, and opportunities; streamlined business resources by standardizing business processes and improving internal system integration
• Evaluated marketing metrics by studying prospect behavior and sales trend, more than doubled program participation in 6 months

Marketing Data Analyst Intern

• Built regression models between revenues and features influencing the sales. Figured out the relation between selected influential factors and the views of posts on data from social media. Raised suggestions for increasing traffic and transactions.
• Using R, applied Web Scrapping to access destinations data in packages from the [company name]. Analyzed and summarized sales information for all destinations and applied on the email preference system.
• Researched in different Multi-Channel Attribute Models using R. Compared the results with those in Google Analytics. Finally picked Markov Model for reference of more efficient advertising.

Marketing Data Analyst

• Used text mining of 2000 Amazon reviews to uncover customer attitudes and sentiments on oral care products and gave insight as to what contributes to their overall rating and purchasing intentions
• Applied data mining techniques to compare and highlight top customer opinions of a product as a means to provide feedback to enhance future products
• Tracked search engine traffic, bounce rate, conversion rate, inbound links and other marketing metric to monitor websites and analyze a huge amount of data at both the aggregate and individual page level through Advanced Google Analytics
• Used predictive analytics and regression modeling to examine and determine patterns in data that company can use to predict and understand customer behavior, such as shopping habits and purchasing trends
• Corporate with TURN (DSP/DMP) to ingest and unify disparate marketing data to drive audience acquisition, engagement, and conversion across that complex buying journey for expanding programmatic media buying

(part-time) Marketing Data Analyst

• Lead a team of 6 duke students and execute an online search ad campaign for an NGO with a $250 budget.
• Monitor the SEO performance daily. Guide campaign decisions based on data, A/B testing, growth goal, and client interview.
• Analyze data, identify key issues, and allocate the budget to optimize the campaign. Surpass KPI goal by achieving 49,000+ impressions, 690+ clicks, 1.42% CTR) in 3 weeks.

Marketing Data Analyst Intern

• Ensured that Google AdWords and Hubspot Ads campaigns are optimized to bring highly targeted traffic to FastVisa’s website with ensuring a very strong ROI
• Performed Google Analytics analysis and reporting based on customer usage data
• Created, analyzed, and optimized Google AdWords and Hubspot campaigns for across varying target segments
• Worked with large data sets in Excel and uploading data/content for ads using the AdWords Editor tool
• Used Python, R, Excel Pivots or other data science tools to monitor and analyze the customer usage results
• Conducted AB testing across ads and landing pages
• Assisted in the execution and evaluation of optimization activities, including but not limited to: keyword development expansion, ad creation, lead generation and landing page optimization
• Published comprehensive monthly and weekly reports based on customer usage data
• Created PPC Strategy and SEO strategy for FastVisa website

Marketing Data Analyst

• Assisting Sales and Revenue Managers in sales planning, sales discount validation, data reconciliation.
• Tracking daily productivity to provide clear, compelling metrics reporting on a regular basis.
• Generating business intelligence reports using pivot tables and pivot charts from cleaned data.
• Using SQL for organizing and abstracting data from MS access data bases and created reports.
• Finding new insights with available data and presenting the analysis for the process improvements.

Marketing Data Analyst

• Lead on marketing data reports for the Final Distribution Retail team inside [company name]
• Manages the Digital Customer Experience online and works with End-to-End Web interface for more than 10,000+ products within the Final Distribution Retail team
• Constantly working to revamp and recreate web content and constantly working to recreate the way product information is displayed
• Ensuring and leading the Commercial Reference Creation & Master Data consolidation for more than 10,000+ products
• Managing the Product data in Schneider systems (OPS, Etim, pictures)
• Working to deploy and animate the required tools/platforms to process data and support Business requirements for Current & Future Offer marketing.
• Lead O
• Process owner of the commercial reference creation
• Supports the coordination for the data transfer
• Masters data flows & associated Information Systems
• Ensures the completeness and quality of the marketing data (OPS, Etim, pictures )