At Amazon.com, we strive to be Earth's most customer centric company. To support this vision, we need customer centric problem solvers, highly curious learners and experimenters and innovators who can build sustainable solutions at scale. If you are such person, this is your chance to work hard, have fun, and make history.
Key job responsibilities
The candidate will own the production and delivery of a suite of standard reports, tools regularly used by the organization to make key business decisions. This will involve:
1. Creating, supporting and continuously improving reports and metrics that support the business operations
2. Converting data into digestible business intelligence and actionable information using tools like Quicksight/Tableau
3. Shaping and delivering key metrics, reports, and indicators by which our business will assess its performance
4. Diving deep into large data sets to answer specific business questions using Excel, SQL and other data manipulation languages
5. Working directly with business teams to utilize metrics and analysis to determine improvement opportunities
Tools used include:
1. SQL (Redshift)
2. Excel Advanced VBA
3. Tableau/Quicksight
4. Report scheduling tools (internal)
5. AWS (S3, Lambda, Athena)
The candidate will be detail oriented and driven to provide insightful and timely information to customers. There is always room to make things better so this candidate should also have the ability to invent and simplify. Lastly, the candidate should have an ability to work effectively with cross-functional teams and an ability to work in a fast-paced and ever-changing environment.
About the team
The RBS is an integral part of Amazon online product lifecycle and buying operations. The team is designed to ensure Amazon remains competitive in the online retail space with the best price, wide selection and good product information. The team’s primary role is to create and enhance retail selection on the worldwide Amazon online catalog. The tasks handled by this group have a direct impact on customer buying decisions and online user experience.
- 1+ years of tax, finance or a related analytical field experience
- 2+ years of complex Excel VBA macros writing experience
- Experience defining requirements and using data and metrics to draw business insights
- Experience with SQL or ETL
- Experience with reporting and Data Visualization tools such as Quick Sight / Tableau / Power BI or other BI packages
- Experience in Amazon Redshift and other AWS technologies
- Experience creating complex SQL queries joining multiple datasets, ETL DW concepts