<ul><li>Managed the analytics infrastructure and logistics team.</li><li>Oversaw all activities and ensured alignment with the business's vision and objectives.</li></ul>

Director of Analytics

<ul><li>Managed the Lux Data foundation.</li><li>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.</li><li>Worked hand in hand with product managers to provide data support and analysis for product launches and product enhancements.</li><li>Developed all the Lux certified metrics using Airbnb internal framework.</li><li>Taught regular SQL, Tableau and data classes (Airbnb Data University).</li><li>Performed regular data studies and analyses on Luxury Retreats sales performance.</li><li>Collaborated with the research team on finding data insights.</li></ul>

Data Scientist & Business Intelligence Specialist

<ul><li>Reported to the vice president finance and operations.</li><li>Built the business intelligence (BI) department at Luxury Retreats (medium size company with over 300 employees).</li><li>Designed and implemented the BI department mission and vision from ground up.</li><li>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.</li><li>Designed the strategy and the roadmap of data and BI at Luxury Retreats.</li><li>Led the data transition and integration from Luxury Retreats to Airbnb.</li><li>Transformed the company from an intuition based to a fact-driven decision-making culture.</li><li>Provided competitive intelligence and actionable insights to all departments.</li><li>Coached and mentored a team of BI developers, statisticians and programmers.</li><li>Administered the Tableau Server of LRI.</li><li>Created complex reports and dashboards in Tableau Desktop.</li><li>Trained users of different departments to implement a self-service BI strategy.</li><li>Performed predicting modelling using SPSSS.</li></ul>

Business Intelligence Director

<ul><li>Designed BI applications using Oracle Essbase.</li><li>Created regulatory reports and templates (Y12, non-consolidated reporting, FR-Y11, FR-2314) using Clarity visualization tool.</li><li>Designed reports using Microsoft Reporting Services, T-SQL, mxl and mdx.</li></ul>

Data Analyst

<ul><li>Modelled a data warehouse using MS SQL Server applications.</li><li>Created ETLs using BIDS.</li><li>Implemented Tableau Server and Desktop and delivered departmental dashboards and reports.</li><li>Ran ad-hoc complex SQL queries to meet reporting needs.</li></ul>

Business Intelligence Consultant

<ul><li>Created and administered different SQL server databases and data marts aimed to support the product and account management department.</li><li>Developed different data marts adapting them to the business needs.</li><li>Designed reports using Microsoft Reporting Services, T-SQL, Excel, MS-Access, BO and Dundas data visualization software.</li><li>Developed and automated DTS packages (ETL) in SQL Server Business Development Studio to update the information of all the databases.</li><li>Analyzed information and made recommendations.</li><li>Provided SQL Server training to different departments across Expedia (Montreal, Arlington, TX, and London, England).</li><li>Administered a Microsoft Reporting Services Server and posted reports in it.</li><li>Wrote complex SQL scripts.</li><li>Created graphs, dashboards, and maps using Dundas Data Visualization package for MS Reporting Services.</li><li>Managed a group of people that map information into the databases.</li><li>Helped with long-term product planning and strategy.</li></ul>

Ernesto Suguer

English (British)

Ernesto Suguer is a data analyst with over 15 years of experience in business intelligence and analytics fields. He is the director of analytics at Reef Technology and former data scientist and business intelligence specialist at Airbnb Canada. At Morgan Stanley, he served as a data analyst who designed BI applications using Oracle Essbase and regulatory reports and templates using the Clarity visualization tool. Ernesto also worked for Expedia, Intel, and Future Electronics.

Ernesto Suguer

Employment Highlights

Education Highlights