Ernesto Suguer, Data Scientist and Developer in Montreal, QC, Canada
Ernesto Suguer

Data Scientist and Developer in Montreal, QC, Canada

Member since July 8, 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.
Ernesto is now available for hire

Portfolio

  • Reef Technology
    Redshift, Tableau, Jira, SQL, Bitbucket, Confluence, Documentation, Databases...
  • Airbnb
    SQL, Apache Airflow, Apache Hive, Presto DB, Databases, Data Engineering...
  • Luxury Retreats International
    SQL Server Integration Services (SSIS), Tableau Server, Tableau Desktop Pro...

Experience

Location

Montreal, QC, Canada

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.

Employment

  • 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)
  • 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)

Experience

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

Skills

  • Tools

    Tableau, 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, Business, Business Administration, Data Warehousing, Data Warehouse Design, ETL Development, Finance, Tableau Server, Documentation, Data Engineering
  • Languages

    Excel VBA, SQL
  • Frameworks

    Presto DB

Education

  • Master's Degree in Business Administration
    2000 - 2001
    Univesidad del CEMA - Buenos Aires, Argentina
  • Bachelor's Degree in Electrical Engineering
    1991 - 1997
    Universidad Tecnológica Nacional - Buenos Aires, Argentina

To view more profiles

Join Toptal
Share it with others