Emilio Carnicero, Developer in Madrid, Spain
Emilio is available for hire
Hire Emilio

Emilio Carnicero

Verified Expert  in Engineering

Data Visualization Developer

Location
Madrid, Spain
Toptal Member Since
December 29, 2021

Emilio is a computer science engineer and MBA graduate with 18 years of experience helping businesses define and analyze their KPIs across marketing, sales, operations, and finance. He is skilled in SQL and has been working with Tableau since 2011, developing all data integration required to feed Tableau from any data source. As a Tableau consultant and trainer, Emilio can quickly interpret the business needs and build insightful dashboards.

Portfolio

Amazon.com
Tableau, Asana, Reports, Data Analytics, Data Analysis, Data Visualization...
Freelance
Tableau, Alteryx, Business Intelligence (BI), Reports, Data Analytics...
PepsiCo
Google Analytics, Data Analysis, Dashboards, SQL, Google Data Studio...

Experience

Availability

Part-time

Preferred Environment

Tableau, SQL, Alteryx, Tableau Desktop Pro, Tableau Server, Python, Excel 2013, ETL Tools, DataViz

The most amazing...

...Tableau dashboard I've built allows companies to track customer acquisition cost and LTV per channel, helping define the most effective marketing strategies.

Work Experience

Program Manager Amazon Transportation

2019 - PRESENT
Amazon.com
  • Oversaw innovation in Amazon's Middle Mile Transportation network by defining, scoping, and implementing new ideas and driving the product development from design to release.
  • Defined the business strategy to transform the current transportation environment.
  • Conducted strategy implementation, prioritized projects, initiatives, and feature sets.
Technologies: Tableau, Asana, Reports, Data Analytics, Data Analysis, Data Visualization, Analytics, Microsoft Power BI, Redshift, Data Modeling, Pricing, Reporting, Microsoft Excel, Transportation & Logistics, Transportation & Shipping, Logistics

Tableau Consultant

2018 - PRESENT
Freelance
  • Helped the organizations get valuable insights from their data by utilizing the power of Tableau and Alteryx.
  • Developed visual dashboards that automate data gathering and represent it interactively and graphically, facilitating their interpretation.
  • Assisted senior managers in defining KPIs and building solutions that allow agile multidimensional analysis.
  • Conducted training sessions for clients. As a certified Tableau trainer, I helped people from diverse backgrounds become fluent with the Tableau software.
Technologies: Tableau, Alteryx, Business Intelligence (BI), Reports, Data Analytics, Google Data Studio, Data Analysis, Analytics, Looker, Microsoft Power BI, Microsoft SQL Server, Training, Redshift, Data Modeling, Azure, Pricing, Reporting, Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW), DAX

Data Analyst

2022 - 2022
PepsiCo
  • Built a set of dashboards to monitor internal communication articles consumption and newsletter CTR.
  • Developed data integration via SQL using BigQuery and dashboards using Looker Studio from Google.
  • Gathered requirements from Pepsico's internal communications teams and led functional reviews and testing with them.
Technologies: Google Analytics, Data Analysis, Dashboards, SQL, Google Data Studio, Data Modeling, Pricing, Reporting, DAX, Microsoft Excel

Senior Strategic and Planning Officer

2017 - 2018
European Investment Fund
  • Provided forecasts and analysis of the EIF's business activities to support strategic and tactical decision-making.
  • Partnered with internal stakeholders to design and implement suitable analytical dashboards to enhance EIF's capital allocation visibility.
  • Harmonized how the EIF's activity, data, and information is synthesized, consolidated, and reported.
  • Performed analysis of cost and revenue generated by the different EIF mandates.
Technologies: Tableau, Reports, Data Analytics, Data Analysis, Data Visualization, Analytics, Data Modeling, Financials, Pricing, Reporting, Microsoft Excel

Financial Analyst

2011 - 2017
Amazon.com
  • Streamlined planning and reporting. Furthermore improved the processes, standardization, and automation efforts of the variable costs across the EU fulfillment centers.
  • Managed the reporting efforts for weekly and monthly close processes, annual planning, and regular forecast updates.
  • Developed and maintained tools to drive standardization and automation with the existing reports and improved data accuracy and timeliness of reporting.
  • Led regular variance analysis on actuals versus planned and forecasts that included delivery of executive summaries explaining material variances.
Technologies: Tableau, Finance, Financial Modeling, Analytics, Data Modeling, Financials, Reporting, Microsoft Excel

BI Consultant

2005 - 2009
Accenture
  • Played a key role as the project manager implementing a pan-European Business Intelligence platform for a major consumer goods company.
  • Designed and developed a forecasting tool to improve the effectiveness of the company's deal schedule.
  • Managed the scope delivery within the agreed timelines and budget.
Technologies: SQL, ETL, Databases, Data Modeling, Reporting

Sales Performance Dashboard

https://public.tableau.com/app/profile/emilio.carnicero/viz/SalesPerformanceMonitoring/SellOutDashboard
Interactive dashboard to track sales performance per brand, region, and month, drilling down into the performance of individual stores. The dashboard allows you to filter by brand and area, detailing the performance of a specific selection.

User Engagement Dashboard

https://public.tableau.com/app/profile/emilio.carnicero/viz/Engagementdashboard/UserEngagementperAcquisitionDate#1
The user engagement dashboard tracks users' engagement, retention, and average order price for an eCommerce company. By using the dashboard, the company observed the quality of the users acquired each week and measured the lifetime value of each cohort of users to optimize their marketing investment.

Survey Dashboard

https://public.tableau.com/app/profile/emilio.carnicero/viz/SurveyDashboard_16372748130570/SurveyDashboard
The Survey Dashboard provides a graphical and interactive analysis of survey answers. The dashboard creates a visual representation of the survey answers providing an easier understanding of the answers and trends across users' different profiles.

Store Location and Sales Map

https://public.tableau.com/app/profile/emilio.carnicero/viz/VolumeperStoreMap-Indiana/VolumeperStoreMap
A geographical dashboard that enables store location analysis for a US chain of stores. The dashboard allows the graphic visualization of the density of stores in each city area and the location of the top-selling stores.

Languages

SQL, Python, Snowflake

Tools

Tableau, Tableau Desktop Pro, DataViz, Microsoft Excel, Microsoft Power BI, Looker, Asana, Google Analytics

Paradigms

Business Intelligence (BI), ETL

Storage

Databases, Redshift, MySQL, PostgreSQL, Microsoft SQL Server

Other

ETL Tools, Excel Expert, Data, Excel 365, Data Collection, Data Engineering, Data Visualization, Dashboards, Reports, Data Analytics, Data Analysis, Analytics, Training, Data Modeling, Reporting, DAX, Tableau Server, Finance, Web Marketing, Google Data Studio, Fivetran, Data Build Tool (dbt), Financials, Pricing, Transportation & Logistics, Transportation & Shipping, Logistics, Operations, Predictive Modeling, Predictive Analytics, Financial Modeling

Platforms

Alteryx, Amazon Web Services (AWS), Azure, Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW)

2010 - 2011

Master’s Degree in Business Administration (MBA)

IE Business School | Instituto de Empresa - Madrid

2000 - 2005

Bachelor's Degree in Computer Science

University of Alicante - Alicante, Spain

OCTOBER 2019 - PRESENT

Alteryx Designer Core

Alteryx

SEPTEMBER 2019 - PRESENT

Predictive Analytics for Business

Udacity

MAY 2017 - PRESENT

Tableau Trainer

Tableau

MARCH 2017 - PRESENT

Tableau Certified Consultant

Tableau

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring