Ellen Hsu
Diversely skilled Data Analyst with a capacity for learning at a fast pace and managing large, complex projects. Database engineer and builder of advanced reports, SQL queries, ETL processes, and data visualizations. Fearless problem-solver, often automating and reducing system complexities by over 40%. Passionate about transforming data into user-friendly tools and bridging communication between engineers and end-users.
Skills
- Big Data & AWS - Snowflake admin, Spark, Athena, Google Big Query, S3, Redshift, Airflow
- SQL - nested queries, JSON functions, PostgreSQL, SQLAlchemy
- Tableau - dashboards, multiple sources, relational data, calculations, LOD, maps
- Alteryx - data cleansing, data transformation, statistical analysis
- Python - Pandas, Matplotlib, NumPy, SciPy, Flask, Beautiful Soup, Web APIs
- JavaScript - D3, Plotly, Leaflet
- Excel - advanced formulas, pivot tables, VBA
Experience
Marketing Operations Analyst
Establishing foundational data structures and reporting dashboards for Enterprise Marketing Operations and Strategy. Managing the reporting and funnel analytics for all of Enterprise Marketing. Collaborating with 12+ global markets across NA, EMEA, and APAC, as well as cross-functionally across data platforms, data science, and marketing teams.
Financial Analyst
Introduced and standardized automation into integrated marketplace reports using MDX and OLAP data cubes in Excel. Restructured and streamlined financial reports.
Supply Chain Analyst
Responsible for supply chain network capacity planning and optimization. Analyzing consumer goods flow using data analytics tools including Tableau, Alteryx, Snowflake, Teradata, Excel, etc. Performing cloud database administration and ad hoc analysis. Managing logistics operations in a highly collaborative, cross-functional team environment.
Owner, Entrepreneur
Founded and grew a successful multi-channel retail store, initially as e-commerce then also as a brick-and-mortar store in 2013. Continued to sell on four e-commerce platforms and designed financial tools to forecast the annual purchasing budget, product mix and monthly cash flow.
Marketing Manager
Overhauled the corporate website to a content management system and trained 30 stakeholders from 7 business groups across 4 languages. Managed an international marketing budget of ~$100K. Drove the strategic and creative direction of quarterly advertising campaigns.
Freelance Digital Producer
Produced websites for small to mid-sized businesses in an agency environment. Managed feature enhancements for Intel’s digital asset management system.
Digital Producer
Cleaned 48% of the intranet in obsolete sites and defined new account management procedures. Served as interim Senior Digital Manager to facilitate progress and motivation during leadership and IT transitions.
Education
Data Engineering, Predictive Analytics, Agile, Python II
Certificate - Data Analytics
MBA - Marketing
BA - Interdisciplinary Computing & the Arts
Project Highlights
