Amazon Business Intelligence Engineer Amazon Customer Service 

United States, Washington, Seattle 

172079199

Key job responsibilities
As part of the BIE team, you will have an opportunity to participate and innovate across the BI landscape, starting from data ingestion, storage, processing, and automated self-serve reporting. You will partner closely with business, finance and product teams from CS, Operations teams and stakeholders from Returns, as well as the Recommerce and Sustainability organization to understand their data needs and ensure business users are able to answer hard questions with real data. You will educate and train customers to self-serve data, present data in new forms, explore reporting options, and innovate. You will participate in business reviews and new initiatives. You should be able to identify and help close gaps in the information available, as well as predict up-and-coming data needs when participating in discussions about new products or features.Your responsibilities will include:- Translate basic business problem statements into analysis requirements.
- Develop queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting.
- Write queries and outputs efficiently, and have in-depth knowledge of the data available in your area of expertise.
- Pull data needed with standard query syntax; periodically identify more advanced methods of query optimization.
- Convert data to make it analysis-ready.
- Recognize and adopt best practices in reporting and analysis: data integrity, design, analysis, validation, and documentation.
- Troubleshoot operational data-quality issues.
- Review and audit existing ETL jobs and queries.
- Recommend improvements to back-end data sources for increased accuracy and simplicity.A day in the life1. Medical, Dental, and Vision Coverage
2. Maternity and Parental Leave Options
3. Paid Time Off (PTO)
4. 401(k) Plan

- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Experience with data modeling, warehousing and building ETL pipelines
- Experience in Statistical Analysis packages such as R, SAS and Matlab
- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling