Hello, I'm
Sigrid Wei
Data and analytics professional with experience in SQL, Python/R, and Tableau — building frameworks, dashboards, and predictive models that drive pricing strategy, assortment optimization, and revenue growth.
Who I Am
I'm a data and analytics professional based in Mountain View, CA, passionate about transforming complex datasets into clear, actionable business decisions.
With a master's degree from Duke University's Fuqua School of Business and hands-on experience at Weee!, I specialize in building end-to-end analytical solutions — from writing optimized SQL queries across thousands of SKUs to crafting interactive Tableau dashboards that empower teams to act decisively.
My work sits at the intersection of data science and business strategy, enabling better pricing, smarter assortment decisions, and measurable revenue impact.
I'm deeply data and AI-driven — I believe we're in an exciting era where AI dramatically accelerates how ideas become reality. I leverage AI as a force multiplier for analytical work: moving faster, exploring more, and shipping better insights. But I pair that with rigorous critical thinking and verification — because the goal is to use AI smartly, not to depend on it blindly.
Location
Mountain View, CA
Master's Degree
MS Analytics · Duke University / Fuqua, 2024
Bachelor's Degree
BSc Statistics & Psychology · University of Toronto, 2023
Current Role
Merchandising Strategy Analyst · Weee!
Summer Exchange
University of Oxford · Imperial College London (2022)
Skills & Tools
Programming & Data Tools
Statistical & Analytical Methods
Business Analytics
Collaboration & Execution
Experience
- Built a SKU-level assortment optimization framework using SQL across tens of thousands of SKUs, integrating product tier, storage type, category hierarchy, and funnel performance metrics (impressions, add-to-cart rate, revenue, availability)
- Developed interactive SKU performance dashboards in Tableau tracking revenue, PGM%, availability, impression, penetration, and YoY growth for category managers
- Conducted pricing and elasticity analysis for direct import and bulk-buy SKUs by evaluating competitor pricing, tariff trends, and margin performance
- Led weekly expiration risk reviews, building SQL-based alerts that reduced spoilage costs by $50K🎯 $50K saved within three months
True Media
· Durham, NC
- Built Random Forest predictive models in R to estimate ROI across target segments, identifying niche markets with an estimated 15% increase in marketing ROI📈 +15% ROI
- Conducted EDA on regional tourism and marketing datasets to identify trends, correlations, and data quality issues prior to model development
- Queried campaign performance using SQL, evaluating CPC, CAC, conversion rates to identify high-performing social media platforms
- Developed interactive Tableau dashboards to communicate campaign insights to stakeholders
- Analyzed campaign performance across social media channels using SQL — impressions, clicks, CTR, conversions, and ROI
- Built Tableau dashboards to monitor campaign trends and surface actionable insights on e-commerce and search performance
- Delivered reports that contributed to an approximate 15% improvement in ROI📈 +15% ROI
ByteDance
· Shanghai, China
- Tracked and analyzed headcount movements — monitoring hiring volume, attrition rates, and workforce flow across departments to support data-driven HR planning
- Conducted turnover pattern analysis to surface root causes of attrition, identifying high-risk teams and managers with elevated churn and presenting findings to HR leadership
- Built recurring reports and dashboards in Excel to visualize workforce KPIs, enabling faster identification of talent gaps and retention risks
- Supported HR analytics functions including headcount and attrition monitoring, providing data summaries to guide workforce planning decisions
- Designed and administered employee satisfaction surveys — developed question frameworks, coordinated distribution, and analyzed results to surface engagement trends and actionable recommendations
- Synthesized HR data into structured reports to support cross-functional communication between HR and business unit leads
- Led the events and communications team, managing end-to-end production of online articles and promotional content across social platforms to grow community reach
- Coordinated both online and offline events — liaising between internal teams and external venues/vendors to ensure seamless execution across all club activities
- Spearheaded onboarding and training programs for new members, building structured processes that improved team ramp-up speed and culture alignment
- Developed strong cross-team collaboration skills through ongoing coordination across event planning, marketing, and executive leadership
Projects
Airline Route Profitability Optimization
Analyzed U.S. domestic airline datasets using feature engineering and Random Forest modeling to evaluate route profitability, punctuality, and passenger load factors. Developed composite scoring metrics to rank routes and recommend strategic expansion opportunities.
Public Safety & Government Efficiency Evaluation
Analyzed multi-year vehicle accident and incident datasets using SQL to identify risk patterns and long-term trends. Designed interactive Tableau dashboards delivering insights that supported data-driven prevention strategies for North Carolina public safety initiatives.
Market Research & User Segmentation for Video Games
Applied clustering and k-means segmentation with correlation analysis on survey datasets to identify high-value gamer segments and generate targeted marketing strategy recommendations.
Education
Certifications & Honors
Get in Touch
I'm always open to discussing data analytics roles, interesting projects, or opportunities to collaborate. Feel free to reach out through any channel below!