Data Analyst
Current- Update weekly dashboards and productionize ad-hoc reports in Looker, design 40% of new metrics for the LCU dashboard, and guarantee the output to help stakeholders evaluate important metrics.
- Initiate QA process to monitor significant metrics such as sales, test each version before launch, design logs to ensure functionality and track failure, and reduce sanity check time by 50%.
- Optimize dashboard performance by launching cost analysis, remove duplicated metrics that cost 30% of… Show more
- Optimize dashboard performance by launching cost analysis, remove duplicated metrics that cost 30% of extra computing power to maintain efficiency and control costs.
- Perform ad-hoc analysis using SQL, Python, and Web analytical tools, and collaborate with cross-functional teams to troubleshoot the problems, and deliver insightful stories.
- Clean competitor merchant lists with 1M+ inputs, design a workflow to match competitors with transactions, compare competitors’ order volume, sales and AOV to investigate the reason for competitor outperformance.