About the Organization: Amazon is a US-based multinational electronic commerce company headquartered in Seattle, Washington. Amazon.com started as an online bookstore, but soon diversified into many other categories, with a vision to be earth's most customer-centric company & to build a place where people can come to find and discover anything they might want to buy online.

About the role: Amazon's Finance Operations, Accounting & Analysis (FOAA) team is a fast-paced, team-focused, dynamic environment and delivering great experiences for our customers is top priority. FOAA is seeking a Business Intelligence Engineer to support our Amazon AWS Finance team.
As an Amazon Business Intelligence Engineer you will be working in one of the world's largest and most complex data warehouse environments. You should have deep experience in the design, creation, management, and business use of large datasets. You should have excellent business and communication skills to be able to work with business owners to develop and define key business questions, and to build data sets that answer those questions. You should be good at designing, implementing, and operating stable, scalable, low cost solutions to flow data from production systems into the data warehouse and into end-user facing applications. You should be able to work with business customers in understanding the business requirements and implementing reporting solutions.
The person will need to effectively communicate across all levels and be self-motivated to raise the bar on deriving insights from analytics and identify opportunities to delight the customers. Above all you should be passionate about bringing large datasets together to answer business questions and drive change.

This person will own the production and delivery of suite of analytics reports and dashboards used by the organization to make key business decisions. This will involve:
1) Delivery of standardized performance metrics for global customers (Vendors) and stakeholders (Amazon AWS Finance) providing operational bandwidth to Amazon AWS Finance teams to focus on business partnering initiatives.
2) Partner with existing BI leader in executing defined roadmap of projects.
3) Provide ad-hoc support to Amazon AWS finance and business services for SQL report creation, modification and optimization.
4) Debug report issues, unblock workflows and communicate with other teams and stakeholders by providing regular status updates.

Tools used include:
1. SQL (Oracle and Redshift)
2. ETL tools (internal)
3. Excel
4. Tableau
5. Report scheduling tools (internal)