Ernesto Suguer, Developer in Montreal, QC, Canada
Ernesto is available for hire
Hire Ernesto

Ernesto Suguer

Verified Expert  in Engineering

Data Scientist and Developer

Location
Montreal, QC, Canada
Toptal Member Since
July 16, 2020

Ernesto is a business intelligence professional with more than 15 years in the field. With his expertise in data warehousing, Amazon Redshift, MS SQL Server, ETL (SSIS), Tableau Desktop, and Tableau Server, he helps companies integrate and organize data from multiple sources to be used for reporting and analysis. His attention to detail, strategic thinking, and expertise make him a highly qualified individual for various projects.

Portfolio

Reef Technology
Redshift, Tableau, Jira, SQL, Bitbucket, Confluence, Documentation, Databases...
Zoetis - Main
SQL, Data Visualization, Tableau
Zoetis
SQL, Data Visualization, Tableau, Google Sheets

Experience

Availability

Part-time

Preferred Environment

Tableau Desktop Pro, Tableau Server, SQL Server Integration Services (SSIS), Microsoft SQL Server, Redshift, Jira, Agile, Bitbucket

The most amazing...

...thing I've built and managed was the entire data lifecycle of Luxury Retreats, from data acquisition, cleansing, integration, and data warehousing.

Work Experience

Director of Analytics

2020 - PRESENT
Reef Technology
  • Created Tableau Dashboards to provide visibility for the Retail team and maintained legacy Power BI reports.
  • Worked on analytics studies to provide insights aimed at increasing efficiencies and revenue.
  • Partnered with data engineering to build pipelines and process automation.
  • Provided data support to all the retail business lines, specifically merchandising, supply chains, operation, and brand curation.
Technologies: Redshift, Tableau, Jira, SQL, Bitbucket, Confluence, Documentation, Databases, Data Engineering, Business Intelligence (BI), Google Sheets

Senior Business Analyst

2022 - 2022
Zoetis - Main
  • Developed complex Tableau dashboards to provide visibility to some of the business units.
  • Compiled requirements from business users and translated them into interactive visualizations.
  • Presented the results to a business audience with excellent feedback.
Technologies: SQL, Data Visualization, Tableau

Senior Business Analyst

2022 - 2022
Zoetis
  • Conducted a lost customer analysis for the Diagnostics BU, where I provided lots of new insights.
  • Created a dashboard with a super complex set of requirements.
  • Created a framework to give Tableau permissions for new diagnostics users.
Technologies: SQL, Data Visualization, Tableau, Google Sheets

Data Scientist

2019 - 2020
Airbnb
  • Played an integral role during the biggest data migration ever performed at Airbnb. It included building new data sources, integration to Airbnb infrastructure, data cleansing, and setting up a new Tableau Server.
  • Developed Airbnb-certified metrics using an internal framework.
  • Trained 100 people in SQL, Tableau, and Airbnb data infrastructure as part of Airbnb Data University.
Technologies: SQL, Apache Airflow, Apache Hive, Presto DB, Databases, Data Engineering, Business Intelligence (BI)

Business Intelligence Director

2013 - 2019
Luxury Retreats International
  • Modeled a data warehouse using MS SQL Server applications.
  • Played a key role to position the BI department as the hub of knowledge and data that provides meaningful insights that drive more-informed decisions across the organization.
  • Integrated data from multiple sources to a single data warehouse.
Technologies: SQL Server Integration Services (SSIS), Tableau Server, Tableau Desktop Pro, Microsoft SQL Server, Databases, Business Intelligence (BI)

Data Analyst

2010 - 2012
Morgan Stanley
  • Designed regulatory reports and templates (Y12, non-consolidated reporting, FR-Y11, FR-2314) using Clarity Visualization Tool.
  • Designed BI applications by building cubes in Oracle Essbase.
  • Designed reports using Microsoft Reporting Services, T-SQL, MXL, and MDX.
Technologies: Microsoft SQL Server, Essbase, Databases, Business Intelligence (BI)

Airbnb Biggest Data Migration

Played an integral role during the biggest data migration ever performed at Airbnb. It included building new data sources, integration to Airbnb infrastructure, data cleansing, and setting up a new Tableau Server.

LR Data Warehouse

At Luxury Retreats, leadership had visibility through basic reports and CSV data dumps. As a consultant, I met with all the stakeholders and modeled the Data Warehouse. I worked with engineering on data requirements, IT for setting up the infrastructure for data and reporting, and with all the business leaders to model the data warehouse around the business needs. After building the DW there was consistency in the numbers, data was clean and accessible across the organization.

Fed Reporting at Morgan Stanley

I worked with controllers to set many of the Federal Reserve regulatory reporting (Y12, FR-Y11, and FR-2314) through a series of cubes and data entry tools like IBM Clarity. I was part of the team that set up the Basel 3 requirements.

Connectivity Data Mart

At Expedia, I was part of the connectivity team that managed the connections from chains and hotels to the Expedia database. I built a connectivity data mart that hosted most of the systems used by hotels across the globe. This data mart was the only one in the world with this kind of information.

Data Analysis for a Montreal School

I conducted data analysis to understand the demographic of potential students for the school in the Montreal market. The project involved data acquisition and analysis, and the output was the number of families the school could potentially target by each of the markets in the Montreal region.

Tools

Tableau, Google Sheets, Tableau Desktop Pro, Apache Airflow, Microsoft Power BI, Jira, Bitbucket, Confluence, Microsoft Power Apps

Paradigms

Business Intelligence (BI), Database Design, ETL, ETL Implementation & Design, Agile

Storage

SQL Server 2012, SQL Server Integration Services (SSIS), Database Modeling, Microsoft SQL Server, Databases, Database Architecture, Redshift, Apache Hive, Essbase

Other

Dashboards, Data Visualization, Data Analysis, Data Analytics, Business, Business Administration, Data Warehousing, Data Warehouse Design, ETL Development, Finance, Tableau Server, Documentation, Data Engineering, Google Data Studio

Languages

Excel VBA, SQL

Frameworks

Presto DB

2000 - 2001

Master's Degree in Business Administration

Univesidad del CEMA - Buenos Aires, Argentina

1991 - 1997

Bachelor's Degree in Electrical Engineering

Universidad Tecnológica Nacional - Buenos Aires, Argentina

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