Business Analyst Intern, GM CN BI

Scope of Work:
1. Maintain and upgrade excel model for weekly business reporting, and support report automation
2. Support visualization tool development and maintenance (e.g. Quicksight)
3. Update KPI metrics and debug the SQL query if necessary;
4. Support business performance deep dive and simple analysis;
5. Verify data pipeline accuracy and exceptional cases solving if any;
6. Assist team's online wiki page by organizing relevant design and maintenance documentation

Key job responsibilities
1) Performance report (weekly & monthly)
2) Data visualization development and maintenance
3) Query optimization & consolidation
4) Documentation maintenance
5) Ad-hoc task support

A day in the life
1) Reports preparations includes but not limited to collecting and formatting offline data/file.
2) Data visualization Quicksight maintenance and development if any.
3) Query optimization for existing data pipeline
4) Doc...