Looking for a job

Abby Yang

@abbyyang

Message

Data analyst and analytics engineer who turns complex data into executive-ready dashboards and automated ETL pipelines.

United States

Message

What I'm looking for

I’m looking for a role where I can build end-to-end analytics solutions—Power BI/Fabric dashboards, reliable ETL with SQL, and responsible AI—partnering with stakeholders to deliver measurable impact and continuous workflow improvements.

I’m a data-focused business analyst and analytics engineer who translates complex datasets into “decision-ready” insights for departmental leaders. I’ve led cross-functional analytics reporting across compliance, operations, and product teams to keep stakeholders aligned on performance and outcomes.

I designed and delivered executive dashboards surfacing revenue by consultant/product, using accounting and operational data to enable data-driven decisions. I also implemented Microsoft Fabric with end-to-end SQL integration, designing and validating ETL pipelines that reduced manual data cleaning and reporting by 10+ hours/week.

To scale workflows, I built an automated document ingestion pipeline using Power Automate and Python to process 50+ external invoices monthly (PDF/Excel/HTML), eliminating manual effort for accounting. I’ve also managed and customized CRM tracking with automated workflow alerts and executive dashboards for team performance metrics.

I’m committed to practical, responsible AI adoption—designing and delivering a seminar series with biweekly office hours to train 15+ non-technical staff on compliant Copilot usage and PII/HIPAA data handling protocols. Previously, I optimized marketing and eCommerce growth through analytics-driven campaign attribution and customer/sales analysis using tools like Google Analytics, HubSpot, Tableau, and A/B testing.

Experience

Work history, roles, and key accomplishments

Current

Freelance Watercolor Artist

Current

AdhocAbbs

Feb 2021 - Present (5 years 3 months)

Operated an end-to-end eCommerce business, analyzing sales and customer behavior to optimize product mix and promotional strategy. Managed product, pricing, and fulfillment while using analytics to guide business decisions.

eCommerce Management Pricing Strategy Product Mix Sales Analytics Customer Segmentation

Business Analyst

NFP

Nov 2023 - Aug 2025 (1 year 9 months)

Led cross-functional analytics reporting and built executive dashboards that surfaced consultant/product revenue insights for senior leadership. Automated invoice ingestion and implemented Microsoft Fabric SQL ETL pipelines, reducing manual data cleaning and reporting by 10+ hours/week.

Power BI Microsoft Fabric T SQL ETL Power Automate Python Excel Azure DevOps Copilot PII HIPAA Compliance

Marketing Coordinator

Lily Mili

Dec 2020 - Oct 2021 (10 months)

Analyzed consumer and campaign performance using Google Analytics and HubSpot to identify growth opportunities. Optimized media spend and supported data-driven pricing decisions based on reporting and experimentation.

Google Analytics HubSpot Data Reporting A B Testing Excel Prompt Engineering

Marketing Intern

Archipelago Strategies Group

May 2019 - Dec 2019 (7 months)

Tracked media consumption trends and campaign KPIs using Tableau and Excel, building segmentation profiles to optimize paid media targeting. Conducted A/B testing and campaign attribution analysis to improve multichannel performance and inform targeting strategy.

Tableau Excel KPIs A B Testing Segmentation Media Optimization Google Analytics Style Reporting

Branding & PR Intern

Ogilvy

Nov 2017 - May 2018 (6 months)

Adapted global go-to-market assets for regional markets and developed competitive research materials for pitches. Produced event collateral supporting media positioning and stakeholder presentations.

Competitive Research Positioning Communication Strategy

Education

Degrees, certifications, and relevant coursework

LaunchCode Women+

Certificate, SQL Server & Databases

2022 - 2023

Grade: N/A

Activities and societies: Built sales and inventory reports using T-SQL and SSRS in Visual Studio for an e-commerce startup.

Emerson College

Master of Arts (MA), Strategic Communication for Marketing

2018 - 2020

Grade: N/A

Activities and societies: Earned an MA in Strategic Communication for Marketing, completing a capstone focused on agility and restoring growth through refined branding strategy for a local winery.

Beijing University of Technology

Bachelor of Science, Urban Planning

2013 - 2018

Grade: N/A

Activities and societies: Served as manager of the university flag football team, coordinating collegiate games and leading partnership work with NFL China.

Earned a B.S. in Urban Planning.