Yanyan is available for hire
Hire YanyanYanyan Wang
Verified Expert in Engineering
Analytics and Data Engineer and Developer
San Diego, United States
Toptal member since September 11, 2026
Bio
Yanyan is a senior analytics and data engineer with 13 years of experience building scalable data pipelines, analytics platforms, and BI solutions for global organizations. She specializes in BigQuery, SQL, Airflow, GCP, and data modeling. Yanyan has a track record of modernizing legacy workflows, improving reliability and performance, and translating complex business needs into production-ready analytics solutions.
Portfolio
MNTN
PostgreSQL, BigQuery, SQLMesh, Apache Airflow, Python, Redshift, Tableau...
Amazon
SQL, AWS Lambda, Business Intelligence (BI), Amazon Redshift...
Amazon.com
SQL, Python, Data Modeling, ETL, Data Pipelines, Data Analytics...
Experience
- SQL - 16 years
- Business Intelligence (BI) - 15 years
- ETL - 15 years
- Tableau - 15 years
- Data Modeling - 14 years
- Apache Airflow - 5 years
- BigQuery - 4 years
- SQLMesh - 2 years
Work Experience
Software Engineer, Analytics
2024 - PRESENT
MNTN
- Led the migration and redesign of analytics models and reporting layers from PostgreSQL to BigQuery, using SQLMesh and Airflow to improve scalability, data reliability, and reporting consistency across teams.
- Migrated complex Tableau data-source logic—including pacing calculations, over/under-spend logic, invoice performance, and campaign attributes—into structured and maintainable BigQuery and SQLMesh data models.
- Designed and built production ETL pipelines using Python and Airflow across AWS data infrastructure, including Amazon S3 and Redshift, and helped migrate orchestration workflows from AWS-based Airflow to GCP/Astro Airflow.
- Established Airflow development best practices and reusable workflow patterns, documented orchestration processes, monitored production pipelines, troubleshot workflow failures, and improved alerting and operational reliability.
- Investigated and resolved production data and reporting discrepancies by tracing upstream and downstream dependencies, validating source data, and correcting data-model and reporting logic to restore accurate downstream analytics.
- Developed and maintained scalable data models for business and data science stakeholders, and partnered with marketing and data science teams on new product and feature launches using API and log-data analysis.
- Owned end-to-end performance analytics and reporting, delivering long-term dashboards and ad hoc analyses across key advertising metrics, including ROAS, CPA, cost per visit, impressions, conversions, and spend.
Technologies: PostgreSQL, BigQuery, SQLMesh, Apache Airflow, Python, Redshift, Tableau, Google Cloud Platform (GCP), Data Modeling, Data Pipelines, Data Warehousing, Big Data, Dashboards, Data Engineering
Senior Business Intelligence Engineer
2022 - 2024
Amazon
- Built end-to-end self-service analytics products for worldwide fulfillment-center stakeholders, integrating operational data and delivering global reporting solutions using SQL, AWS Lambda, SQS/SNS, Redshift, and Tableau.
- Partnered with application teams and fulfillment-center stakeholders to understand upstream application data, develop reporting pipelines, and translate operational requirements into scalable datasets and dashboards.
- Developed and maintained business-critical supply-chain metrics in SQL, providing consistent operational reporting for stakeholders across Amazon’s global fulfillment network.
- Served in the production on-call rotation alongside data engineers, troubleshooting pipeline failures, investigating data issues, and answering technical questions from downstream teams.
- Analyzed forecasting model accuracy and reporting outputs to identify performance gaps and support data-driven supply-chain planning and operational decision-making.
Technologies: SQL, AWS Lambda, Business Intelligence (BI), Amazon Redshift, Amazon S3 (AWS S3), Tableau, Data Pipelines, Data Analytics, Data Quality, Data Warehousing, Big Data, Dashboards, Data Engineering
Business Intelligence Engineer II
2021 - 2022
Amazon.com
- Independently led the design and development of CEDAR, a centralized self-service analytics platform standardizing around 300 business metrics and 400+ modeling and research features for reporting, experimentation, and analysis.
- Designed reusable data models and automated pipelines that replaced project-by-project data preparation, enabling analysts and scientists to access standardized datasets for reporting, experimentation, feature exploration, and research.
- Partnered closely with data scientists on large-scale research initiatives, identifying candidate features, preparing analytical datasets, performing exploratory data analysis, and supporting feature engineering for machine-learning models.
- Designed SQL analyses for experiments and A/B tests, translating behavioral and customer-engagement data into insights that supported product and business decision-making.
- Enabled analysts, marketers, engineers, and scientists to use the centralized platform for ad hoc reporting, operational insights, feature exploration, experimentation, and research.
- Created documentation, established reporting standards, and led training sessions to improve adoption, metric consistency, and trust in the self-service analytics platform.
Technologies: SQL, Python, Data Modeling, ETL, Data Pipelines, Data Analytics, Exploratory Data Analysis, Feature Engineering, A/B Testing, Experimental Design, Machine Learning, Jupyter Notebook, Business Intelligence (BI), Data Warehousing, Big Data, Dashboards, Data Engineering
Data Engineer
2019 - 2021
Amazon Web Service (AWS)
- Led end-to-end analytics projects for AWS Field Marketing, from multi-source data integration and data modeling through ETL development, KPI design, and Tableau dashboard delivery for global stakeholders.
- Built and maintained SQL-based data pipelines and ETL workflows, integrating multiple source systems into Redshift to support scalable marketing analytics and reporting.
- Built and maintained global marketing performance dashboards and shared Tableau data sources, enabling regional leaders to track standardized KPIs and business performance.
- Maintained and applied a transportation simulation model using machine learning and C# to support transportation planning for AWS re:Invent 2019, an event serving approximately 65,000 attendees.
- Delivered Tableau training workshops to global field-marketing teams, helping hundreds of users adopt self-service dashboards and consistently interpret reporting metrics.
Technologies: ETL, Tableau, C#, SQL, Amazon Redshift, Data Modeling, Data Pipelines, Machine Learning, Data Integration, Business Intelligence (BI), Data Warehousing, Big Data, Dashboards, Data Engineering
Senior Data Engineer
2017 - 2019
Daybreak Game Company
- Designed and maintained ETL pipelines using Talend, Jenkins, and AWS S3 to integrate data from multiple sources into Oracle, Vertica, and Snowflake for analytics and reporting.
- Led migration of analytics datasets from Oracle and Vertica to Snowflake, helping modernize the data warehouse and simplify downstream reporting workflows.
- Built and maintained core sales, session, and event data models supporting game-level and portfolio-wide reporting, analytics, and business decision-making.
- Integrated social and digital marketing data from Facebook, Twitter, and Google Analytics through Java-based API connections to expand marketing and customer analytics capabilities.
- Partnered with Finance to design and build a standardized sales data model supporting financial reporting and revenue analysis.
- Led analytics delivery with a 3rd-party marketing partner, translating business requirements into data models and curated datasets for campaign and marketing analysis.
Technologies: Talend, Oracle, Vertica, Snowflake, Java, SQL, Amazon S3 (AWS S3), ETL, Data Modeling, Data Warehousing, JAVA, API Integration, Business Intelligence (BI), Data Pipelines, Big Data, Dashboards, Data Engineering
Data Engineer
2015 - 2017
Daybreak Game Company
- Built Tableau dashboards and analytical reports for finance, game, and executive stakeholders, tracking core gaming KPIs including DAU, MAU, retention, and conversion.
- Led end-to-end marketing analytics projects, partnering with marketing teams on Google Analytics initiatives, campaign data models, and reporting requirements.
- Designed and maintained ETL workflows using Talend to integrate data from multiple sources into Oracle and Vertica for downstream analytics and reporting.
- Built and maintained reporting data models in core databases, providing reusable datasets for business intelligence and operational reporting.
- Supported project managers across the full project lifecycle, helping translate business requirements into data solutions, coordinate delivery, and validate reporting outputs.
Technologies: Tableau, Talend, Oracle, Vertica, SQL, ETL, Data Modeling, Google Analytics, Business Intelligence (BI), Marketing Analytics, Data Pipelines, Data Warehousing, Big Data, Dashboards, Data Engineering
Data Analyst
2014 - 2015
Qualcomm
- Partnered with business users and engineers to gather reporting requirements and deliver BI solutions using Salesforce, Tableau, QlikView, and IBM Cognos.
- Worked with IT teams to design and launch new BI applications, translating business requirements into reporting workflows and end-user solutions.
- Built dashboards and recurring reports and performed statistical and trend analyses to support weekly, monthly, and quarterly business reviews.
- Partnered with global HR teams to consolidate and maintain headcount data, improving visibility into workforce reporting and tracking.
- Supported day-to-day BI operations by troubleshooting reporting-tool issues, maintaining SharePoint data, and helping end users resolve analytics and reporting problems.
Technologies: Salesforce, Tableau, QlikView, IBM Cognos, Business Intelligence (BI), Data Analysis, Statistical Analysis, Trend Analysis, Microsoft Excel, SharePoint, BI Reporting, Dashboard Design, Dashboards, Data Engineering
Business Analyst
2013 - 2014
Homesite
- Developed and maintained departmental SQL Server databases, creating tables, views, stored procedures, and SSIS workflows to support analytics and operational reporting.
- Designed SSRS dashboards and performance-monitoring reports for senior leadership, turning operational data into recurring management insights.
- Built reporting workflows using SQL Server, SAS, Excel, SSIS, and SSRS to transform raw source data into structured datasets and end-user reports.
- Partnered with business stakeholders to gather requirements, modify reporting systems, test enhancements, and ensure delivered solutions met operational needs.
Technologies: SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SAS, Data Modeling, ETL, Business Intelligence (BI), Data Engineering
Project History
Cloud Analytics Platform Migration – PostgreSQL to BigQuery
Led an end-to-end modernization of a legacy analytics platform by migrating reporting models from PostgreSQL to BigQuery, redesigning transformation logic with SQLMesh, and orchestrating workflows with Airflow. I owned dependency analysis, data-model redesign, validation, and production troubleshooting, improving scalability, maintainability, data reliability, and consistency across downstream reporting.
Customer Engagement Analytics & Feature Platform
Independently owned the end-to-end design and development of a centralized self-service analytics platform for customer engagement data, standardizing approximately 300 business metrics and 400+ modeling and research features for reporting, experimentation, exploratory analysis, and modeling.
Global Marketing Analytics Platform
Independently owned the end-to-end design and delivery of analytics solutions for global marketing teams, from multi-source data integration and Redshift modeling to ETL pipelines, reusable SQL datasets, and Tableau reporting. Standardized performance reporting and enabled scalable self-service analytics.
Global Self-service Supply Chain Analytics Platform
Designed and delivered a global self-service analytics solution supporting fulfillment operations across multiple regions. I built scalable reporting datasets and dashboards using SQL, Redshift, S3, and AWS services, enabling stakeholders to monitor operational metrics and make data-driven decisions. I then partnered with engineering teams to troubleshoot production pipelines and improve data reliability.
Education
2012 - 2013
Master's Degree in Information Technology
University of Massachusetts Boston - Boston, MA, USA
2010 - 2012
Master's Degree in Finance
University of Massachusetts Boston - Boston, MA, USA
2010 - 2010
Bachelor's Degree in Economics
Chongqing University - Chongqing, People’s Republic of China
Skills
Tools
BigQuery, Apache Airflow, Tableau, AWS Glue, Microsoft Excel, IBM Cognos, Microsoft Power BI, Amazon QuickSight, Google Analytics
Languages
SQL, Python, C#, Snowflake, SAS, Java
Frameworks
SQLMesh
Paradigms
ETL, Business Intelligence (BI)
Platforms
Oracle, Salesforce, Microsoft, Jupyter Notebook, Talend, QlikView, AWS Lambda, Google Cloud Platform (GCP), SharePoint
Storage
PostgreSQL, Amazon S3 (AWS S3), Redshift, Database Management, Data Pipelines, Data Integration, Greenplum, Vertica, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
Other
SQL Server, Data Analytics, Data Modeling, Business Analysis, Data Analysis, Amazon Redshift, Data Quality, Exploratory Data Analysis, Data Warehousing, BI Reporting, Dashboard Design, Data Migration, Big Data, Dashboards, Data Engineering, Large Language Models (LLMs), GCP, Financial Analysis, Financial Modeling, Statistics, Economics, Econometrics, A/B Testing, Statistical Analysis, Trend Analysis, Quantitative Analysis, Feature Engineering, Experimental Design, Machine Learning, JAVA, API Integration, Marketing Analytics
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