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 Music 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 Music) providing operational bandwidth to Amazon music 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 music 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)
- 4+ years of experience as an analyst or engineer in the data/BI space
- Experience with data visualization using Tableau, Quick sight, or similar tools
- Experience with SQL
- Retrieve and analyze data using SQL, Excel, and other data management systems
- Bachelor’s degree in Computer Science, Computer Information Systems, or related fields
- 4 to 5 years of relevant work experience of SQL with 2 to 3 years of experience writing SQL queries
- Experience in Microsoft Excel
- Ability to work in a fast-paced and rapidly-changing environment with experience managing multiple priorities and projects
- Excellent written, verbal, listening and communication skills
- Experience with reporting tools like Tableau or other BI packages
- Team player - FP&A experience to develop forecasting models, and report variance against goals will be an added advantage