Jhony Chu, Developer in Madrid, Spain
Jhony is available for hire
Hire Jhony

Jhony Chu

Verified Expert  in Engineering

Bio

Jhony is a data analytics expert with 8+ years of experience leading and implementing end-to-end analytics projects, from data project planning and definition to data extraction, ingestion, cleaning, transformation, and data visualization on cloud platforms.

Portfolio

Freight Finance Co. DBA Express Freight Finance
Tableau, Dashboard Development, Analytics, KNIME, PostgreSQL, Python...
Volvo Car
Microsoft Power BI, Snowflake, BigQuery, Marketing, Data Migration...
Toptal Client
Microsoft Power BI, SQL, Microsoft SQL Server, Tableau, ETL, Data Warehousing...

Experience

  • Microsoft Power BI - 10 years
  • Tableau - 10 years
  • SQL - 10 years
  • Business Intelligence (BI) - 10 years
  • Python - 8 years
  • Google Data Studio - 8 years
  • Google BigQuery - 8 years
  • APIs - 8 years

Availability

Full-time

Preferred Environment

Python, SQL, Microsoft Power BI, Tableau, Google Data Studio, APIs, Google Cloud Platform (GCP), Data Visualization, Dashboards, Analytics, Google Sheets, Google Sheets API, Looker Studio, Dashboard Design, Dashboard Development, Data Cleaning, Automation, Data Integration, Marketing, Data Validation, Google Analytics API

The most amazing...

...implementation I've led covered end-to-end analytics, from data extraction to processing, automation, and visualization, while utilizing different data sources.

Work Experience

Tableau Developer

2021 - PRESENT
Freight Finance Co. DBA Express Freight Finance
  • Integrated APIs from multiple 3rd-party tools, such as Outreach, CallRail, Salesforce, and Google, to streamline data integration and enhance cross-platform functionality.
  • Developed and automated pipelines using KNIME, ensuring efficient data processing and workflow automation.
  • Introduced materialized views to optimize the performance of recurring queries and reports in PostgreSQL to Tableau Dashboards.
  • Improved the performance of Postgres queries that fed into Dashboards by refactoring and applying indexing strategies, reducing the execution time by 30% to 60%.
  • Demonstrated expertise in Tableau's advanced functionalities, including Level of Detail (LOD) expressions, data blending, joins, and calculated fields, enabling in-depth analysis and granular data manipulation.
  • Leveraged these advanced functionalities in Tableau to create interactive dashboards that provide dynamic insights and facilitate data exploration for end-users.
  • Developed machine learning models to accurately predict potential fraud, leveraging advanced algorithms and data analysis techniques.
  • Partitioned Salesforce Lead Data Tables by Date to improve query performance for data exploration purposes.
Technologies: Tableau, Dashboard Development, Analytics, KNIME, PostgreSQL, Python, Machine Learning, Automation, Google Sheets, Google Sheets API, Social Media, Dashboard Design, Data Cleaning, Airtable, Integration, Make (formely Integromat), Excel Contact Databases, SQL Server Integration Services (SSIS), Google Docs, Docker, Google Analytics 4, Facebook Ads API, Facebook Ads, Google Search Console, Amazon Web Services (AWS), Microsoft Power Automate, Website Traffic, Data Integration, Git, Marketing, Data Validation, Google Cloud Storage, Microsoft Excel, Google Analytics API

Data Engineer

2024 - 2025
Volvo Car
  • Integrated Google Analytics 4 (GA4) data into Snowflake to enhance insights for the online shop team. Developed automated data pipelines and optimized GA4 event data models.
  • Created dynamic Power BI dashboards with DAX and direct queries to provide real-time reporting on KPIs such as conversion rates and traffic sources.
  • Streamlined data processes, improving reporting speed and enabling data-driven decision-making across teams.
Technologies: Microsoft Power BI, Snowflake, BigQuery, Marketing, Data Migration, Data Validation, Google Cloud Storage, Microsoft Excel, Google Analytics API

RFP Presales Support

2024 - 2024
Toptal Client
  • Supported Toptal team in generating strategic sales slides for data architecture model for PowerBI and Microsoft ecosystem.
  • Mapped potential risks and challenges for migration from Tableau to PowerBI.
  • Mapped existing issues and proposed potential solutions about their existing data modeling for migration.
  • Built data architecture for potential migration from Tableau to PowerBI.
Technologies: Microsoft Power BI, SQL, Microsoft SQL Server, Tableau, ETL, Data Warehousing, Azure, SQL Server Integration Services (SSIS)

Tableau Consultant

2023 - 2024
Cosgrove Partnership Inc
  • Set up a Tableau Embedded environment with a login screen to filter different client reports based on login credentials.
  • Set up a data warehouse in BigQuery with a multi-tenant structure to support Tableau dashboards.
  • Implemented data extraction for several APIs, including QuickBooks, Google Maps Reviews, Google Analytics 4, Facebook Ads, and Google Search Console to integrate all the data in one single place.
  • Created and automated dashboards in Tableau for a multi-tenant service in Tableau Embedded with an integrated login platform for several companies, enhanced with row-level security.
Technologies: Tableau, Google Sheets, APIs, Google Docs, Airtable, Python, Docker, Google Cloud, Tableau Embedded Analytics, Make (formely Integromat), QuickBooks API, QuickBooks Online, Google Analytics 4, Google Analytics, Facebook Ads API, Facebook Ads, Google Search Console, Excel Contact Databases, Amazon Web Services (AWS), Website Traffic, Snowflake, Data Integration, Git, JavaScript, Marketing, Data Migration, Data Validation, Google Cloud Storage, Microsoft Excel, Google Analytics API

Data Visualization | Data Engineer Expert

2023 - 2024
Travelodge
  • Refactored and processed business Google Sheets into BigQuery.
  • Processed, cleaned, and transformed hotel sales and employee data by region and hotel in BigQuery.
  • Created reports and generated insights in Google Data Studio for each region, hotel, and employee on an incentive program basis.
Technologies: Google Data Studio, Excel Reporting, SQL, Excel 2016, Google Sheets, Google Docs, Data Integration, Git, Data Validation, Microsoft Excel, Looker, Looker Studio, Google Analytics API

Google Data Studio Dashboard Developer

2023 - 2023
Travelodge - Main
  • Automated the data flow from the client internal data source to Google Data Studio through Google Sheets.
  • Managed the data blending in Google Data Studio to generate the defined metrics.
  • Optimized the dashboard performance and the formulas created by the cleaning to improve the speed of the dashboard.
Technologies: Google Data Studio, Excel Reporting, Excel 2016, Google Sheets, Dashboards, SQL, Looker Studio, Dashboard Development, Data Cleaning, Automation, Integration, Make (formely Integromat), Google Docs, Data Integration, Git, Marketing, Microsoft Excel, Looker, Google Analytics API

Tableau Developer

2023 - 2023
Skyloop Digital Ltd
  • Utilized BigQuery for data cleaning and transformation processes.
  • Optimized Postgres Queries pipeline that fed into BigQuery by applying indexing and partitioning based on event dates.
  • Employed BigQuery to create materialized views for optimized querying and performance.
  • Leveraged Tableau to develop customized reports aligned with specific business requirements.
Technologies: Tableau, Google BigQuery, BigQuery, Dashboards, Data Visualization, Google Sheets, Google Sheets API, Social Media, Dashboard Design, Dashboard Development, Data Scraping, Web Scraping, Data Cleaning, Automation, Integration, Docker, Google Analytics 4, Facebook Ads API, Facebook Ads, Google Search Console, Website Traffic, Snowflake, Data Integration, Git, Marketing, Data Migration, Data Validation, Google Cloud Storage, Microsoft Excel, Looker, Google Analytics API

Data Engineer and BI Developer

2022 - 2022
ClimateWells
  • Developed a fully automated pipeline to upload data into buckets after reading from the drive using Python.
  • Applied regular expression and natural language processing (NLP) using named entity recognition (NER) packages on text to classify data using Python.
  • Deployed containers to automate whole extraction and transformation in Google Cloud Platform using Cloud Run.
  • Built and designed an insightful dashboard for C-level executives in Looker Studio.
Technologies: SQL, Data Analytics, Data Modeling, Data Analysis, ETL, Dashboards, Tableau, Microsoft Power BI, Python, Dash, Data Visualization, Cloud Run, Containerization, Natural Language Processing (NLP), Generative Pre-trained Transformers (GPT), Data Architecture, Automated Data Flows, Data Warehousing, Data, Databases, Google Cloud, Google Cloud Functions, Analytics, Excel 2016, Data Cleansing, Google Sheets, Google Sheets API, Looker Studio, Dashboard Development, Data Cleaning, Automation, Integration, Google Docs, Docker, Data Integration, Git, Data Validation, Looker

Senior Data Analyst

2021 - 2022
ITRenew Inc.
  • Developed, automated, and maintained data processes from the Cloud using Python for a financial project.
  • Monitored and secured the correct functioning of ETL processes.
  • Developed, automated, and maintained business reports in Tableau.
Technologies: Tableau, Python, MySQL, Data Engineering, Data Pipelines, Microsoft SQL Server, ETL, Data Visualization, Azure SQL Data Warehouse, Data Analysis, Dashboards, Data Architecture, Automated Data Flows, Data Warehousing, Data, Databases, Google Cloud, Google Cloud Functions, Analytics, Excel 2016, Data Cleansing, Tableau Prep Flow, Dashboard Design, Dashboard Development, Data Cleaning, Automation, Azure, SQL Server Integration Services (SSIS), Docker, Git, Data Validation

Data Analytics Manager

2020 - 2022
LastObject
  • Implemented end-to-end analytics and reporting solution from scratch within three months.
  • Recommended and presented insights and findings to C-level executives on a weekly basis.
  • Identified new technology opportunities for the company and reduced the monthly fixed costs by 100%.
Technologies: BigQuery, SQL, Python, Google Data Studio, APIs, Google Cloud Platform (GCP), Data Analytics, Business Intelligence (BI), Reports, Social Networks, Analytics, Google Analytics, Data Engineering, Data Pipelines, ETL, Data Visualization, Google BigQuery, Data Modeling, Data Analysis, Dashboards, Data Architecture, Automated Data Flows, API Integration, Stitch Data, Data Warehousing, Data, Databases, Google Cloud, Google Cloud Functions, Excel 2016, User Interface (UI), Data Cleansing, Google Sheets, Google Sheets API, Social Media, Looker Studio, Dashboard Development, Data Cleaning, Automation, Integration, Google Docs, Google Analytics 4, Facebook Ads API, Facebook Ads, Google Search Console, Website Traffic, Snowflake, Marketing, Data Validation, Looker, Google Analytics API

Data Analytics Team Lead

2020 - 2021
Banner Analytics
  • Identified and implemented scalable solution for data discrepancies project in six months.
  • Managed a team of developers and quality assurance analysts to improve and automate a company solution.
  • Presented results about data quality with over 95% confidence to C-level executives.
Technologies: SQL, Python, Tableau, Google Cloud Platform (GCP), Data Analytics, Business Intelligence (BI), Reports, Analytics, BigQuery, Data Engineering, PostgreSQL, Data Pipelines, ETL, Data Visualization, Google BigQuery, Dashboards, Data Architecture, Automated Data Flows, Data Warehousing, Data, Databases, Google Cloud, Google Cloud Functions, Data Analysis, Excel 2016, Data Cleansing, Dashboard Development, Data Cleaning, Airtable, SQL Server Integration Services (SSIS)

Digital Analytics Data Consultant

2018 - 2019
Accenture
  • Managed end-to-end implementation of analytics and data visualization tools for Chatbot’s products across industries.
  • Performed in-depth analysis of client’s historical data, identifying and regularizing 100% of sales revenue discrepancies.
  • Conducted exploratory data analysis on the client’s current digital marketing capabilities and recommended detailed, actionable guidelines aligned with their enterprise-wide objectives of data for deep learning.
Technologies: Microsoft Power BI, Google Data Studio, SQL, Python, Machine Learning, Google Cloud Platform (GCP), Amazon Web Services (AWS), Data Analytics, Business Intelligence (BI), Reports, Data Science, Social Networks, Mobile Apps, Mixpanel, Analytics, BigQuery, Google Analytics, PostgreSQL, Data Pipelines, ETL, Data Visualization, Google BigQuery, Data Modeling, Data Analysis, Dashboards, Data Architecture, Automated Data Flows, Data Warehousing, Data, Databases, Google Cloud, Excel 2016, User Interface (UI), Data Cleansing, Google Sheets, Google Sheets API, Social Media, Looker Studio, Dashboard Design, Dashboard Development, Data Scraping, Web Scraping, Data Cleaning, Integration, Google Docs, Google Analytics 4, Facebook Ads API, Facebook Ads, Google Search Console, Data Integration, Marketing, Microsoft Excel, Looker, Google Analytics API

Performance Improvement Data Consultant

2015 - 2016
EY
  • Improved client’s sales volume by 15% by eliminating process-related bottlenecks.
  • Prepared and presented data-driven insights of adjusted pricing model to C-level suite.
  • Identified and classified five different segments and developed several data-driven strategies for each of them during go-to-market.
Technologies: SQL, Tableau, Data Analytics, Reports, Analytics, Data Pipelines, Microsoft SQL Server, ETL, Data Analysis, Dashboards, Automated Data Flows, Data Warehousing, Data, Databases, Microsoft Power BI, Data Visualization, Excel 2016, User Interface (UI), Data Cleansing, Google Sheets, Google Sheets API, Looker Studio, Dashboard Design, Dashboard Development, Data Cleaning, Microsoft Excel

Experience

Data Integration and Visualization for an eCommerce Company

An end-to-end project about data extraction from several third-party applications, such as Facebook Ads, Google Ads, LinkedIn Ads, and Shopify. I worked on data integration, cleaning, transformation, and creating powerful customized reports, including operations and logistics, customer lifetime value, cohorts, eCommerce and marketing overview, and wholesale dashboard.

Data Engineer and Power BI Development for Global Automotive Company

Integrated Google Analytics 4 (GA4) data into Snowflake to enhance insights and the team's capabilities. Developed automated data pipelines and optimized GA4 event data models. Created dynamic Power BI dashboards with DAX and direct queries to provide real-time reporting on KPIs such as conversion rates and traffic sources. Streamlined data processes, improving reporting speed and enabling data-driven decision-making across teams.

Data Engineer & Tableau Embedded Expert for Multi-tentant Client Dashboard

https://imgur.com/a/uHaeHPP
Developed a Tableau Embedded environment with a login platform to filter client-specific reports using row-level security. Set up a multi-tenant data warehouse in BigQuery to support scalable Tableau dashboards. Integrated data from multiple APIs, including QuickBooks, Google Maps Reviews, GA4, Facebook Ads, and Google Search Console, consolidating all data into a unified source. Automated and optimized dashboards to provide tailored insights for various companies, enabling seamless data visualization and secure access management across clients.

Education

2017 - 2018

Master's Degree in Big Data and Business Analytics

IE Business School - Madrid, Spain

Certifications

NOVEMBER 2020 - PRESENT

Tableau Desktop Specialist

Tableau Software

Skills

Libraries/APIs

Google Sheets API, QuickBooks API, Facebook Ads API, Google Analytics API, Node.js

Tools

Microsoft Power BI, Tableau, Stitch Data, BigQuery, Google Analytics, Excel 2016, Google Sheets, Make (formely Integromat), Google Docs, Git, Microsoft Excel, Looker, Tableau Prep Flow, Tableau Embedded Analytics

Languages

Python, SQL, Snowflake, JavaScript

Paradigms

ETL, Business Intelligence (BI), Automation

Platforms

Google Cloud Platform (GCP), Azure, Docker, Microsoft Power Automate, Azure SQL Data Warehouse, Amazon Web Services (AWS), Cloud Run, Mixpanel, KNIME

Storage

Databases, PostgreSQL, Data Pipelines, Microsoft SQL Server, Google Cloud, SQL Server Integration Services (SSIS), Data Integration, Data Validation, Google Cloud Storage, Amazon S3 (AWS S3), Excel Contact Databases, MySQL

Industry Expertise

Social Media, Marketing

Other

Google BigQuery, Google Data Studio, Data Modeling, Data Visualization, Data Engineering, Data, Data Analytics, Data Warehousing, Dashboards, API Integration, Data Analysis, Reports, Automated Data Flows, Data Architecture, Analytics, Google Cloud Functions, User Interface (UI), Data Cleansing, Dashboard Development, Looker Studio, Dashboard Design, Data Scraping, Web Scraping, Data Cleaning, Airtable, Integration, QuickBooks Online, Google Analytics 4, Facebook Ads, Google Search Console, Website Traffic, DAX, APIs, Data Science, Social Networks, Database Optimization, Containerization, Data Migration, Machine Learning, Mobile Apps, Amazon RDS, Dash, Natural Language Processing (NLP), Cloud Tasks, Generative Pre-trained Transformers (GPT), Excel Reporting

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