
Jhony Chu
Verified Expert in Engineering
Data Engineer and Developer
Madrid, Spain
Toptal member since June 22, 2021
Jhony is a data analytics specialist with 10+ years of experience leading end-to-end analytics projects, including data project planning, source integration, data extraction and ingestion, data cleaning and transformation, and dashboarding/visualization in cloud environments.
Portfolio
Experience
- SQL - 11 years
- Business Intelligence (BI) - 10 years
- Microsoft Power BI - 10 years
- APIs - 9 years
- Tableau - 9 years
- Google BigQuery - 8 years
- Python - 8 years
- Google Data Studio - 8 years
Preferred Environment
Python, SQL, Microsoft Power BI, Tableau, APIs, Data Visualization, Looker Studio, Automation, Data Integration, Slack API, Big Data, Data Aggregation, Key Performance Indicators (KPIs), Reporting, Orchestration
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
Freight Finance Co. DBA Express Freight Finance
- Integrated APIs from multiple third-party platforms (including Outreach, CallRail, Salesforce, and Google) to streamline cross-platform data integration and improve analytics data availability.
- Developed and automated data pipelines using KNIME, improving workflow orchestration, processing efficiency, and reliability for recurring reporting and analytics use cases.
- Built and enhanced interactive data visualization dashboards using advanced calculated logic, joins/blending, and granular analytical techniques to support dynamic exploration and decision-making.
- Optimized PostgreSQL-backed reporting performance by introducing materialized views, query refactoring, and indexing strategies, reducing dashboard-source query execution times by 30%–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.
- Improved analytical capabilities through advanced modeling and data preparation initiatives, including date-based partitioning of Salesforce lead data and development of fraud-prediction models.
Senior Back-end Engineer
Vail Creatives
- Built a multi-source attribution model combining Klaviyo, Meta Ads, Google Ads, and offline sales data to connect digital touchpoints with revenue outcomes.
- Designed deterministic and probabilistic matching logic using email-based identity resolution to improve attribution accuracy across channels.
- Automated extraction and ingestion pipelines with Airbyte and BigQuery, creating a scalable foundation for marketing performance reporting.
- Developed parameter-driven dashboards with BigQuery-backed Row Level Security to deliver controlled, self-serve reporting for different stakeholders.
- Transformed fragmented marketing and sales data into a unified reporting model that supported attribution analysis and better budget decisions.
Data Engineer
Woven by Toyota, Inc - UK
- Supported data search workflows for scenario-based scene discovery, enabling customer-facing teams to identify relevant scenes for testing, validation, and development use cases.
- Developed and supported PySpark-based data processing workflows orchestrated with Airflow to prepare large-scale scenario datasets for downstream data search analysis from time series unstructured data.
- Collaborated extensively with cross-functional teams (engineering, product, and customer-facing stakeholders) to translate scenario requirements into searchable data logic and actionable outputs.
- Optimized query performance for data search and analysis workflows, improving responsiveness and efficiency when retrieving scenario-specific records.
- Built internal dashboards and analytics views for stakeholders to support debugging, development health monitoring, and operational visibility across workflows.
- Developed reporting/visualization assets to track internal metrics, surface bottlenecks, and improve communication between technical teams and business stakeholders.
Data Analyst
LONGAVIA UAB
- Ingested TMS data from APIs using Python and loaded curated datasets into Microsoft Fabric to support scalable analytics and Power BI reporting.
- Partnered with client stakeholders to define dashboard requirements and KPI frameworks, translating TMS operational metrics into actionable reporting logic and business-aligned measures.
- Built and maintained Power BI dashboards for operational and performance reporting, delivering interactive analysis for shipment trends, SLA adherence, and logistics KPIs.
- Developed Power BI data transformations in Power Query and designed data models (relationships/star schema) to standardize source data and improve report usability and consistency.
- Optimized Power BI report performance through efficient data modeling, DAX measure design, and streamlined Power Query transformations on API-derived datasets.
- Troubleshot reporting/data integration issues across API ingestion, Fabric datasets, and Power BI refresh pipelines, resolving schema and data-quality inconsistencies.
Tableau Developer
Vecna Robotics, Inc
- Built and maintained AWS Glue-based ETL workflows to prepare, transform, and structure raw operational data for Athena consumption, improving data consistency, reducing manual data handling, and supporting scalable dashboard reporting.
- Led performance optimization for a BI dashboard solution by identifying calculation bottlenecks in the visualization layer and redesigning aggregation/query logic in AWS Athena, reducing load times from 10 minutes to 5 seconds.
- Identified excessive row-level recalculation in the reporting layer (calculated logic repeatedly executed across large datasets), causing approximately 10-minute dashboard load times.
- Reverse-engineered existing reporting logic across the visualization layer and Athena-backed views to trace recalculation bottlenecks and optimize query/aggregation design.
- Integrated dashboards with AWS Athena and multiple data sources to support reliable, analytics-ready reporting and cross-source analysis.
- Enhanced existing dashboards in a BI/data visualization platform by adding new capabilities, including per-hour filtering and improved stop-report filtering for operational monitoring.
- Built and optimized data visualization solutions by combining dashboard feature enhancements with upstream data/query optimization to improve performance, filtering flexibility, and usability at scale.
Data Engineer
Volvo Car
- Built and optimized Power BI reports for marketing and sales stakeholders, covering sales pipeline performance, ad investment, ROAS, and campaign effectiveness.
- Supported migration of GA4 data workflows from BigQuery to Snowflake, helping establish a more scalable foundation for reporting and analytics.
- Collaborated across analytics and engineering teams to validate migrated data, align metric definitions, and maintain reporting continuity during the transition.
- Designed semantic Power BI models with bridge tables, helper dimensions, and aggregate tables to support scalable cross-functional reporting.
- Built advanced DAX logic for dynamic month, quarter, and year reporting, improving analytical flexibility without compromising metric consistency.
- Improved maintainability of legacy Power BI reports by reverse-engineering existing data models, documenting logic, and restructuring calculations for clarity and reuse.
- Developed Power Query scripts with dynamic date parameter handling and previous-period comparison logic for enterprise performance reporting.
- Used native Snowflake queries in Power Query to push heavy transformations to the source, improving performance and reducing duplication risks in DirectQuery models.
- Supported enterprise reporting continuity during BigQuery-to-Snowflake migration by validating data outputs, aligning KPI definitions, and adapting Power BI datasets accordingly.
RFP Presales Support
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.
Tableau Consultant
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.
Data Visualization | Data Engineer Expert
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.
Google Data Studio Dashboard Developer
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.
Tableau Developer
Skyloop Digital Ltd
- Utilized BigQuery for large-scale data cleaning, transformation, and modeling processes, helping convert raw affiliate media and marketing purchases and performance data into structured, analytics-ready datasets for reporting and decision-making.
- Built and supported Airflow-orchestrated data pipelines to ingest, process, and scale Affiliate Network and advertisement data from APIs into BigQuery, improving automation, reliability, and readiness for downstream reporting in Tableau.
- Optimized the PostgreSQL query pipeline feeding BigQuery by improving indexing strategies, refining query logic, and applying date-based partitioning to support faster processing and more efficient downstream analysis.
- Employed BigQuery to create and maintain materialized views that improved query performance, reduced reporting latency, and supported more reliable access to high-volume advertising and affiliate performance data.
- Leveraged Tableau to develop customized reports and dashboards aligned with specific business requirements, enabling stakeholders to monitor KPIs, analyze campaign performance, and explore trends across multiple traffic and revenue sources.
Senior Power BI Developer
Wokelo - AI
- Built and optimized Power BI dashboards to track platform usage, report exports, newsletter engagement, Q&A activity, and user adoption across organizations and workflows.
- Designed the underlying semantic model in Power BI, integrating multiple application tables and resolving complex relationship paths across users, reports, activity logs, profiles, and newsletter data.
- Developed custom calendar dimensions and time-based modeling logic in DAX to support daily, monthly, quarterly, cumulative, and trend-based reporting.
- Created advanced DAX measures for user engagement KPIs such as Active Users, DAU, newsletter opens, and running report totals, leveraging USERELATIONSHIP, filter context control, and cumulative logic.
- Implemented reusable measures for behavioral analytics and adoption tracking, enabling stakeholders to monitor platform activity, engagement trends, and workflow usage over time.
- Improved report accuracy by aligning inactive relationships and date contexts correctly across multiple fact-like tables, reducing ambiguity in user- and time-based calculations.
- Delivered self-service reporting views with interactive filters for organization, user, workflow, and date range, helping teams analyze product usage and reporting behavior more effectively.
Data Engineer and BI Developer
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.
Senior Data Analyst
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.
Data Analytics Manager
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%.
Data Analytics Team Lead
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.
Digital Analytics Data Consultant
Accenture
- Developed a Power BI chatbot analytics and traffic performance dashboard for a CPG client, transforming event-based interaction data into actionable KPI reporting and stakeholder insights.
- Collaborated with the development team to understand how chatbot event data was captured in Azure and made available for analytics and reporting.
- Built stakeholder-facing dashboard views to monitor chatbot traffic trends, user interaction patterns, and operational performance indicators.
- Processed and transformed event-level source data into reporting-ready datasets, applying business logic to support traffic, usage, and performance metrics in Power BI.
- 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.
Performance Improvement Data Consultant
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.
Experience
Data Integration and Visualization for an eCommerce Company
Data Engineer and Power BI Development for Global Automotive Company
Data Engineer & Tableau Embedded Expert for Multi-tentant Client Dashboard
https://imgur.com/a/uHaeHPPDashboard Optimization and Business Intelligence Developer
Education
Master's Degree in Big Data and Business Analytics
IE Business School - Madrid, Spain
Certifications
Tableau Desktop Specialist
Tableau Software
Skills
Libraries/APIs
Google Sheets API, QuickBooks API, Facebook Ads API, Google Analytics API, Slack API, REST APIs, Playwright, Node.js, PySpark
Tools
Microsoft Power BI, Tableau, Stitch Data, BigQuery, Google Analytics, Excel 2016, Google Sheets, Make (formerly Integromat), Google Docs, Git, Microsoft Excel, dbt Cloud, Slack, Tableau Desktop, Amazon Athena, Power Query, Power BI Desktop, Tableau Prep Flow, Tableau Embedded Analytics, Looker, AWS Glue, Power BI Report Server, Google Forms, Claude, Composer, GitHub
Languages
Python, SQL, Snowflake, Google Apps Script, Power Query M, JavaScript, HTML, CSS
Frameworks
Spark
Paradigms
ETL, Business Intelligence (BI), Automation, Database Development
Platforms
Google Cloud Platform (GCP), Azure, Docker, Microsoft Power Automate, Google Ads, Klaviyo, Salesforce, Oracle, Azure SQL Data Warehouse, Amazon Web Services (AWS), Mixpanel, Cloud Run, Azure Synapse, Microsoft Fabric, Airbyte, Databricks, Qlik, KNIME
Storage
Databases, MySQL, 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, Redshift
Industry Expertise
Social Media, Marketing
Other
Google BigQuery, Google Data Studio, APIs, 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 (GA4), Facebook Ads, Google Search Console, Website Traffic, DAX, Google Tag Manager, Meta Ads, Data Build Tool (dbt), Amazon Redshift, Interactive Dashboards, Data Reporting, Workflows, Attribution Modeling, Data Warehouse Design, Data Warehouse Implementation, Tableau Server, Artificial Intelligence (AI), Data Governance, Big Data, Data Aggregation, Business, Key Performance Indicators (KPIs), Reporting, Trend Analysis, Orchestration, Dataproc, Cloud Infrastructure, Data Science, Social Networks, Amazon RDS, Database Optimization, Containerization, Data Migration, AI Agents, Azure Data Lake, Quality Assurance (QA), Machine Learning, Mobile Apps, Dash, Natural Language Processing (NLP), Cloud Tasks, Generative Pre-trained Transformers (GPT), Excel Reporting, Cloud, Flyte, Mode Dashboards, Stakeholder Management, Cross Functional Team Engagement, Time series Data Search, PowerQuery, Dashboard Optimization, Reverse Engineering, Supabase, Row-level Security (RLS), Semantic Modelling
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring