Jing Huang

Data analyst with experience using SQL, Excel, Power BI, Tableau, and Python to clean, validate, analyze, and visualize business data. Skilled in KPI reporting, dashboard development, trend analysis, forecasting support, data quality checks, process improvement, and actionable recommendations.

Marketing Data Analyst (Project-Based Role) at Optizent Consulting Services (2023-01 – Present)

• Extract, clean, transform, validate, and analyze marketing, customer, campaign, sales, and business datasets using SQL, Excel, and Python to support KPI reporting and business decision-making.
• Develop Power BI dashboards using DAX and data modeling to track campaign performance, customer behaviour, conversions, revenue trends, and business KPIs.
• Analyze website, paid media, organic, CRM, and campaign data to identify trends, anomalies, reporting gaps, and performance improvement opportunities.
• Define and document KPIs, validation rules, reporting assumptions, and data-quality checks to improve consistency, accuracy, and stakeholder alignment.
• Use AI-assisted workflows to support SQL development, data review, dashboard QA, reporting automation, anomaly detection, and insight summarization.

Sales Specialist at Home Depot Canada (2019-07 – 2025-08)

• Monitored product movement, inventory levels, and data discrepancies to improve reporting accuracy, stock availability, and operational efficiency.
• Supported promotional execution, product-information updates, order coordination, and customer follow-up to improve service and sales performance.
• Developed inside-sales strategies, generated project opportunities, strengthened customer relationships, and supported growth across blinds, flooring, and installation services.
• Analyzed sales, inventory, pricing, product, and customer-demand data using Excel and Tableau to identify trends and support merchandising and business decisions.

Marketing Consultant at Progenics Stem Cell Cryobank (2019-01 – 2019-05)

• Analyzed CRM, website, and marketing-performance data using Tableau to identify customer-engagement trends, lead-generation opportunities, and campaign improvement areas.
• Reviewed website content, landing pages, customer journeys, and online lead flows to identify opportunities to improve user experience and conversion performance.
• Prepared website updates, marketing materials, analytical summaries, and recommendations for campaign planning and stakeholder review.

Marketing Specialist at Various Companies (2005-01 – 2009-10)

• Conducted market research, analyzed sales performance, prepared business reports, supported forecasting and campaign planning, and coordinated events, trade shows, and investment initiatives.

Master of Business Administration in Marketing – City University of Seattle

Post-Secondary Diploma in Civil Engineering – Beijing City University