Business Analyst Intern, AGL CN BI

Job description

from Amazon careers

Amazon strives to be Earth's most customer-centric company where people can find and discover virtually anything they want to buy online. To serve the goal, Amazon has created one of the most advanced fulfillment and logistic networks in the world.
Amazon Global Logistics in China is a team of highly experienced logistics professionals, product & program manager and carrier specialists actively participating in Amazon's international expansion goals. We are seeking some highly motivated individuals who are interested in improving the way products are bought, sold, and distributed on a global scale to join us in China.

Scope of Work:
1. Provide comprehensive support for team reporting preparation and analysis
2. Execute SQL queries and database operations to retrieve and manage team data requirements
3. Use Python (e.g., pandas) to clean, transform and format data for reporting and downstream use.
4. Perform thorough data validation to maintain accuracy, integrity, and consistency across all datasets
5. Handle essential administrative tasks and day-to-day operational support
6. Update KPI metrics, monitor KPI performance and support the KPI performance deep dive by raw data sharing and simple analysis;
7. Provide data support for team operations, projects and ad-hoc requests;
8. Design, develop and maintain scaled, automated, dashboards that will support business needs.

Basic Qualifications

- Work Monday-Friday, up to 40 hours per week
- Bachelor's degree in computer, analytics, business, economics, or a related analytical field (e.g., engineering, math, computer science)
- Experience with data and analysis tools including Microsoft Excel and SQL
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Experience defining requirements and using data and metrics to draw business insights
- Experience in scripting for automation (e.g. Python) and advanced SQL skills.

Preferred Qualifications

- Familiarity with AWS ecosystem tools (e.g. S3, Lambda, Cross Account Access) is a plus.
- Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.