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 and Power BI since 2014, developing all data integration required to feed Tableau and Power BI from any data source. As a Tableau and Power BI consultant and trainer, Emilio can quickly interpret business needs and build insightful dashboards.

Portfolio

Zoetis
Microsoft Power BI, Tableau, Azure, Pricing, Financials, Data Analytics...
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

Power BI Developer

2023 - PRESENT
Zoetis
  • Utilized SQL and Python to extract, clean, and analyze data. Created visualizations and dashboards using Power BI.
  • Translated complex data sets into clear, actionable insights. Provided recommendations based on data analysis to support business strategy and decision-making.
  • Worked with product managers, data scientists, and other stakeholders to understand business requirements and deliver tailored BI solutions.
  • Developed and maintained key performance indicators (KPIs) to monitor and improve business performance. Generated regular reports to track business performance and present findings to senior management.
Technologies: Microsoft Power BI, Tableau, Azure, Pricing, Financials, Data Analytics, Reporting, Data Analysis, Azure Data Lake, Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW)

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, Dedicated SQL Pool (formerly SQL DW), Azure SQL Data Warehouse, DAX, Tableau Prep Flow

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, Tableau Prep Flow, Business Analysis

Senior Business Intelligence Engineer

2019 - 2022
Amazon.com
  • Utilized SQL and Python to extract, clean, and analyze data. Created dashboards using tools like Tableau and Power BI.
  • Designed, developed, and maintained scalable data models and pipelines. Worked with AWS services such as Redshift, S3, and Glue.
  • Conducted strategy implementation and prioritized projects, initiatives, and feature sets.
  • Translated complex data sets into clear, actionable insights. Provided recommendations based on data analysis to support business strategy and decision-making.
  • Worked with product managers, data scientists, and other stakeholders to understand business requirements and deliver tailored BI solutions.
  • Developed and maintained key performance indicators (KPIs) to monitor and improve business performance.
  • Generated regular reports to track business performance and present findings to senior management.
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 Prep Flow, Business Analysis

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, Business Analysis

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, Business Analysis

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.
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

Tools

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

Languages

SQL, Python, Snowflake

Paradigms

Business Intelligence (BI), ETL

Storage

Databases, Redshift, MySQL, PostgreSQL, Microsoft SQL Server

Platforms

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

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 Prep Flow, Business Analysis, 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, Azure Data Lake

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