Xiaojing Wang
Summary
Senior Business Intelligence Data Engineer with 5+ years of experience designing and delivering end-to-end BI and analytics solutions across e-commerce, supply chain, and transportation domains. Proven expertise in Power BI, SQL, semantic layer design, and cloud-based data warehousing, with hands-on experience building scalable ELT pipelines using Snowflake, dbt, Airflow, and Python. Strong track record of translating business requirements into high-performance data models and dashboards that support operational and strategic decision-making for 30+ stakeholders. Adept at cross-functional collaboration, data quality governance, and optimizing BI environments for reliability, accuracy, and performance.
Overview
7
7
years of professional experience
Work History
Data Analyst
Karat by Lollicup Inc.
Dallas, Texas
08.2022 - 01.2025
- Designed, developed, and supported end-to-end BI solutions integrating Snowflake, dbt, Airflow, and Power BI, enabling business users to access trusted, near–real-time insights.
- Built and automated 10+ ELT pipelines ingesting data from EDI, REST APIs, and relational databases, reducing manual workflows by 60% and improving data availability and reliability.
- Designed analytics-ready data models and semantic layers in Snowflake to support standardized KPIs and self-service Power BI reporting.
- Developed Power BI dashboards and reports used by 30+ stakeholders across operations, supply chain, and finance to drive daily and strategic decision-making.
- Optimized complex SQL queries and warehouse performance, improving dashboard response times by 30–50%.
- Engineered an e-commerce shipment visibility pipeline with Airflow orchestration and alerting, increasing data refresh frequency from daily to hourly and reducing late-file failures by 30%.
- Led API-based integrations between NetSuite and internal systems, improving cross-system data consistency and reducing sync latency by 40%.
- Partnered closely with Product Owners and business teams to gather requirements, validate metrics, and ensure data accuracy, completeness, and consistency across BI assets.
Research Assistant (Python, SQL)
The University of Texas at Arlington
Arlington, TX
03.2021 - 01.2022
- Analyzed large-scale healthcare datasets using Python and SQL to identify behavioral patterns among dementia patients and caregivers.
- Delivered data-driven insights to aging-services organizations, supporting program optimization and evidence-based decision-making.
Data Specialist (SQL, ETL)
Wuhan Yuanguang Science & Technology Co., Ltd.
Wuhan, China
01.2018 - 04.2019
- Designed and maintained relational databases and ETL workflows supporting public transportation and logistics analytics across multiple cities.
- Built SQL-based data models and collaborated with a 3-person analytics team to improve data quality and consistency, increasing the accuracy of downstream analytical and optimization models.
- Improved data integration processes, reducing inconsistencies and enabling more reliable operational reporting and decision support.
Education
Master of Science - Computer Science
The University of Texas At Arlington
Arlington05-2022
Bachelor of Science - Software Engineering
Xi’an University of Finance And Economics
Xi’an, China06-2017
Skills
- BI & Analytics: Power BI (Semantic Models, DAX, KPI Design), Dashboard Development, Data Visualization
- Data Engineering: SQL, Python, ETL/ELT, Data Warehousing, Data Modeling (Star/Snowflake Schema)
- Cloud & Platforms: Snowflake, AWS, Azure working knowledge), dbt, Airflow
- Integration: REST API, SOAP API, EDI, NetSuite
- Streaming & Big Data: Kafka, Spark, Hadoop
- Databases: Snowflake, MongoDB, MySQL
- DevOps & Tools: Linux, Docker, Git
Timeline
Data Analyst
Karat by Lollicup Inc.
08.2022 - 01.2025
Research Assistant (Python, SQL)
The University of Texas at Arlington
03.2021 - 01.2022
Data Specialist (SQL, ETL)
Wuhan Yuanguang Science & Technology Co., Ltd.
01.2018 - 04.2019
Master of Science - Computer Science
The University of Texas At Arlington
Bachelor of Science - Software Engineering
Xi’an University of Finance And Economics