Marketing Data Analysis

Juan Figueirido

Marketing Data Analytics

CONTACT

503-***-**** Portland, OR ********@*****.*** linkedin.com/in/juanfigueirido Languages:

• English (fluent)

• Spanish (native)

• Portuguese (basic reading)

Skills and Tools:

• Dashboards and

visualizations

• Marketing data analysis

• Database administration

• Tableau Desktop and Online

• Looker

• Google Data Studio

• Domo

• Power BI

• SQL Server

• Snowflake

• Google BigQuery

• SAS-EG

• MS Excel

• Google Sheets

• Plus, exposure to Google

Analytics, Marketo Engage,

Salesforce, Marketo

Measure, SFDC Einstein,

etc.

Certifications and Courses:

• Microsoft Certified

Professional (MCP)

• Workato Automation Pro I

• Datacamp Data Analyst in

Tableau Track

• SAS® Programming 1 & 2

(Essentials and Data

Manipulation Techniques)

Education:

• BS in Business Management

• Systems Engineering

SUMMARY

I am a meticulous and enthusiastic critical thinker specializing in marketing data analysis. With a proven track record of effectively communicating and collaborating with clients, I excel at comprehending and representing complex marketing data. My expertise lies in translating business requirements into technology specifications and conveying highly technical concepts to non-technical stakeholders. Throughout my career, I have served diverse industries, including automotive, health insurance, advertising, government, martech consulting, and e-commerce. I possess a talent for devising innovative solutions to business problems and delivering engaging and impactful insights through effective visualization techniques. I am committed to continuous learning and eagerly embrace new tools and techniques to stay at the forefront of marketing data analysis practices.

My accomplishments include contributing to revenue funnel optimization, conducting ad-hoc omnichannel reporting and analysis, developing streamlined data collection and dissemination processes, evaluating campaign programs, and effectively managing technical teams. With experience spanning various industries, I am proficient in technologies such as Tableau, MS Excel/Google Sheets, SQL Server, and more, consistently achieving successful outcomes.

Professional references available upon request.

PROFESSIONAL EXPERIENCE

Etumos

Marketing Intelligence Consultant

July 2020 – March 2023 (2 years, 9 months)

• Deliver a clear definition and alignment for the client's B2B revenue funnels and B2B marketing KPIs by gaining a profound understanding of their business strategies and operations utilizing Tableau, Domo, Looker, and different relational database systems.

• Conduct ad-hoc, omnichannel reporting, and analysis across various data sources, generating valuable insights and recommendations for the client.

• Offer data and analytics technology and solution recommendations grounded in logic and truth, with a focus on effective data capture, integration, storage, visualization, and analysis.

• Plan, prioritize, and map out pertinent deliverables, documentation, and communication to ensure effective project management. Technologies used: Tableau, Tableau Prep Builder, Looker, Google Data Studio, Domo, MS Excel (Advance, write formula, VLOOKUP), PowerPoint

(Power user), SQL Server, Snowflake, Redshift, Einstein. Also, exposure to Salesforce, Marketo Engage, Marketo Measure, Google Analytics… Johnstone Supply

Market Research Analyst -- Marketing Analytics

July 2016 – June 2020 (4 years)

• Conduct research and data analytics to establish comprehensive views of market segment growth and trends, while identifying relevant internal and external data sources and developing data sets that support sales and marketing decisions.

• Design processes and infrastructure for the collection and distribution of intelligence (market, competitor, and customer) across the organization.

• Analyze customer data to determine active rates, customer retention rates, RFM analysis, and product mix.

• Evaluate campaign programs by monitoring and tracking campaign performance through key metrics, preparing performance analysis reports of post campaigns, and recommending modifications to concurrent programs to enhance overall program profitability.

• Interpret data and provide recommendations that impact decision- making in identifying market opportunity, market penetration, and market development for distribution and inventory management, as well as new marketing program opportunities.

Technologies used: MS Excel, SQL Server, Power BI. Also, exposure to Epicor Eclipse ERP, Tableau…

Harry & David

Email Marketing Specialist/Data Analyst

April 2014 – July 2016 (2 years, 4 months)

• In my role as a marketing analyst, I was in charge of overseeing the execution of all one-to-one promotional marketing campaigns, such as email and mobile. I skillfully managed stakeholder relationships across marketing, operations, and creative divisions, ensuring seamless planning and deployment of promotional emails that generated more than $100 million annually.

• Generating recurring and ad-hoc analyses on email performance metrics using SAS-EG and MS Excel for the purpose of optimization, segmentation, and recommendation.

Technologies used: MS Excel, SQL Server, SAS, Responsys and Salesforce ESPs. Also, exposure to Google Analytics… Vitacost.com

Data & CRM Marketing Manager

September 2009 – April 2014 (4 years, 8 months)

• I provided support for planning and analysis of the company's customer centricity, encompassing acquisition, retention, and engagement. I deftly managed CRM functions, such as campaign and loyalty programs, while maintaining and cultivating stakeholder relationships. Furthermore, I produced comprehensive reports for all areas of this $400 million per year organization.

• Using MS SQL Server and SAS-EG, I meticulously reported and analyzed data performance trends, while pinpointing opportunities for customer relationship optimizations. I conducted extensive research and identified opportunities for integrating best practices, competitor/industry trends, and new technologies.

Technologies used: MS Excel, SQL Server, SAS, WhatCounts and StrongMail ESPs, plus web development using Dreamweaver. Also, exposure to Google Analytics…

CardOffers.com

IT Manager/Project Manager

January 2006 – April 2009 (3 years 4 months)

• Reported directly to the CEO; I was responsible and accountable for overseeing the maintenance of all licensed or in-house built hardware and software, managing networking and peripheral systems, and administering databases for a credit card online directory.

• I efficiently managed and coordinated multiple web and database projects, built on different technologies, that were directed towards achieving strategic business and organizational objectives.

• I adeptly coached, mentored, and led personnel within a technical team environment, consisting of several web developers, designers, and network admins, to provide seamless support for all employees and over 300 business partners.

Technologies used: MS Excel, SQL Server, Microsoft Visual Studio, Microsoft Access. Also, exposure to SurveyMonkey surveys… Medical Card Systems, Inc.

IT Supervisor

February 2002 – January 2006 (4 years)

• As a technical team leader, I successfully managed a team of over 15 developers and DBAs, while also performing web development and analysis tasks for a health insurance company with over 300K members and consolidated estimated revenues of well over $1 billion a year.

• My role involved developing an extensive range of websites, ensuring that the development and analysis functions were administered consistently and efficiently according to established guidelines and procedures, including those related to internal, statewide, and federal laws.

Technologies used: MS Excel, SQL Server, Microsoft Visual Studio, Microsoft Access, GoldMine CRM. Also, exposure to AS/400 legacy systems, while writing code in COBOL and RPG…

EDUCATION

BS in Business Management (University of Phoenix, 2004-08, graduated) Systems Engineering (Universidad de Oriente, Venezuela, 1991-95, incomplete)

Contact this candidate