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) Documentation maintenance

5) Ad-hoc business deep dive

BASIC QUALIFICATIONS

Required Skills:

1. SQL query skills

2. BI Visualization Tools skill

3. Good communication skills

4. Proficiency English read/write capability

5. Detail-oriented

PREFERRED QUALIFICATIONS

1. Python Programing in a moderate level

2. ML skillful is a plus

3. Familiarity with Django frame is a plus