Emilio is available for hire
Hire EmilioEmilio Carnicero
Verified Expert in Engineering
SQL Developer
Dubai, United Arab Emirates
Toptal member since December 29, 2021
Bio
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 required data integrations 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...
ZoomInfo
Tableau, SQL, Data Modeling, Snowflake, Data Engineering
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
Work Experience
Power BI Developer
2023 - PRESENT
Zoetis
- Built the analytical framework to monitor pricing performance and identify revenue improvement opportunities, while developing sophisticated models to isolate and explain the sales impact of price, volume, and mix.
- Designed a Power BI analytical application adopted by 500+ users, combining executive dashboards, pricing simulations, and net revenue forecasting capabilities. Developed scenario-based Power BI dashboards to assess pricing decisions.
- Worked with product managers, data scientists, and other stakeholders to understand business requirements and deliver tailored BI solutions.
- Created complex DAX measures for pricing analytics (dynamic price-volume-mix decomposition, scenario-based variance analysis, weighted average selling price evolution, margin bridge calculations, and time-intelligent comparisons).
- Developed Python and Spark-based interfaces to query Databricks and build analytical data models in Microsoft Fabric, strengthening the end-to-end data pipeline from raw data extraction to business-ready reporting.
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), Data Engineering, Databricks
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, Tableau Prep Flow
Tableau Expert
2025 - 2026
ZoomInfo
- Optimized Tableau data sources end-to-end by tuning and refactoring underlying Snowflake queries and data models, and redesigned the Tableau semantic layer, reducing dashboard response times from over five minutes to under five seconds.
- Transformed user experience from "barely usable" to "instant, decision-ready analytics."
- Diagnosed root causes across the entire stack and applied deep technical expertise in Snowflake, SQL, and Tableau modeling to deliver faster insights, achieving higher user adoption and lowering ongoing maintenance costs for the customer.
Technologies: Tableau, SQL, Data Modeling, Snowflake, Data Engineering
Product Data Analyst
2024 - 2024
Recare Deutschland GmbH
- Analyzed key product metrics, identifying patterns in user behavior and product adoption.
- Developed automated reporting dashboards using Looker to track product performance and retention metrics.
- Applied predictive analytics to identify potential risks and opportunities in healthcare product usage across different client segments.
Technologies: Looker, Looker Modeling Language (LookML)
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, Data Engineering
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
Project History
Sales Performance Dashboard
https://public.tableau.com/app/profile/emilio.carnicero/viz/SalesPerformanceMonitoring/SellOutDashboardInteractive 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#1The 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/SurveyDashboardThe 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/VolumeperStoreMapA 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.
Education
2010 - 2011
Master’s Degree in Business Administration (MBA)
IE Business School | Instituto de Empresa - Madrid, Spain
2000 - 2005
Bachelor's Degree in Computer Science
University of Alicante - Alicante, Spain
Certifications
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
Skills
Tools
Tableau, Tableau Desktop Pro, DataViz, Microsoft Excel, Microsoft Power BI, Tableau Prep Flow, Looker, Asana, Google Analytics
Languages
SQL, Python, Snowflake, Looker Modeling Language (LookML)
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), Databricks
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
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