Business Analyst Intern, GM CN BI
Job Description
Scope of Work:1. Maintain and upgrade excel model for weekly business reporting, and support report automation2. 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 documentationKey job responsibilities1) Performance report (weekly & monthly)2) Data visualization development and maintenance3) Query optimization & consolidation4) Documentation maintenance5) Ad-hoc task supportA day in the life1) 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 pipeline4) Documentation maintenance5) Ad-hoc business deep dive
Locations
- China, 31, Shanghai, Shanghai, 31, People's Republic of China
Salary
Salary not disclosed
Estimated Salary Rangemedium confidence
12,000 - 24,000 USD / yearly
Source: ai estimated
* This is an estimated range based on market data and may vary based on experience and qualifications.
Skills Required
- 4. Proficiency English read/write capabilityintermediate
Required Qualifications
- Required Skills: (experience)
- 1. SQL query skills (experience)
- 2. BI Visualization Tools skill (experience)
- 3. Good communication skills (experience)
- 4. Proficiency English read/write capability (experience)
- 5. Detail-oriented (experience)
Preferred Qualifications
- 1. Python Programing in a moderate level (experience)
- 2. ML skillful is a plus (experience)
- 3. Familiarity with Django frame is a plus (experience)
Responsibilities
- 1) Performance report (weekly & monthly)
- 2) Data visualization development and maintenance
- 3) Query optimization & consolidation
- 4) Documentation maintenance
- 5) Ad-hoc task support
Documents
Tags & Categories
Business Analyst Intern, GM CN BI
Job Description
Scope of Work:1. Maintain and upgrade excel model for weekly business reporting, and support report automation2. 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 documentationKey job responsibilities1) Performance report (weekly & monthly)2) Data visualization development and maintenance3) Query optimization & consolidation4) Documentation maintenance5) Ad-hoc task supportA day in the life1) 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 pipeline4) Documentation maintenance5) Ad-hoc business deep dive
Locations
- China, 31, Shanghai, Shanghai, 31, People's Republic of China
Salary
Salary not disclosed
Estimated Salary Rangemedium confidence
12,000 - 24,000 USD / yearly
Source: ai estimated
* This is an estimated range based on market data and may vary based on experience and qualifications.
Skills Required
- 4. Proficiency English read/write capabilityintermediate
Required Qualifications
- Required Skills: (experience)
- 1. SQL query skills (experience)
- 2. BI Visualization Tools skill (experience)
- 3. Good communication skills (experience)
- 4. Proficiency English read/write capability (experience)
- 5. Detail-oriented (experience)
Preferred Qualifications
- 1. Python Programing in a moderate level (experience)
- 2. ML skillful is a plus (experience)
- 3. Familiarity with Django frame is a plus (experience)
Responsibilities
- 1) Performance report (weekly & monthly)
- 2) Data visualization development and maintenance
- 3) Query optimization & consolidation
- 4) Documentation maintenance
- 5) Ad-hoc task support