Emilio Carnicero
Verified Expert in Engineering
Data Visualization Developer
Luxembourg City, Luxembourg
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
Experience
- SQL - 15 years
- Data Visualization - 13 years
- Tableau Desktop Pro - 10 years
- DataViz - 10 years
- Tableau - 10 years
- Excel Expert - 8 years
- Tableau Server - 5 years
Availability
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
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.
Tableau Consultant
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.
Data Analyst
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.
Senior Business Intelligence Engineer
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.
Senior Strategic and Planning Officer
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.
Financial Analyst
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.
BI Consultant
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.
Experience
Sales Performance Dashboard
https://public.tableau.com/app/profile/emilio.carnicero/viz/SalesPerformanceMonitoring/SellOutDashboardUser Engagement Dashboard
https://public.tableau.com/app/profile/emilio.carnicero/viz/Engagementdashboard/UserEngagementperAcquisitionDate#1Survey Dashboard
https://public.tableau.com/app/profile/emilio.carnicero/viz/SurveyDashboard_16372748130570/SurveyDashboardStore Location and Sales Map
https://public.tableau.com/app/profile/emilio.carnicero/viz/VolumeperStoreMap-Indiana/VolumeperStoreMapEducation
Master’s Degree in Business Administration (MBA)
IE Business School | Instituto de Empresa - Madrid, Spain
Bachelor's Degree in Computer Science
University of Alicante - Alicante, Spain
Certifications
Alteryx Designer Core
Alteryx
Predictive Analytics for Business
Udacity
Tableau Trainer
Tableau
Tableau Certified Consultant
Tableau
Skills
Tools
Tableau, Tableau Desktop Pro, DataViz, Microsoft Excel, Microsoft Power BI, Tableau Prep Flow, 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, 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
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring