Amazon Business Intelligence Engineer NCRC Science Analytics 

United States, Washington, Bellevue 

389200139

As a BIE on the NCRC team within Amazon Returns and Recommerce, you will be a part of the Science and Analytics team collaborating with a group of Analysts, Economists, and other Engineers. You will have an opportunity to participate and innovate across the engineering landscape, starting from ingestion, storage, processing and reporting. You will partner closely with analysts and economists in the pursuit of investigative data. You will educate and train customers to self-serve , present 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 -needs when participating in discussions about new products or features.
Key job responsibilities- 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 output efficiently, and have in-depth knowledge of the data available in area of expertise. Pull the 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.
- Recommending improvements to back-end data sources for increased accuracy and simplicity.

- Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field
- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
- Experience writing complex SQL queries
- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
- Experience with data modeling, warehousing and building ETL pipelines
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business