Amazon Sr Business Intelligence Engineer NCRC Science Analytics 

United States, Washington, Bellevue 

306877916

As a Senior Business Intelligence Engineer (Sr. BIE) on the NCRC team within Amazon Returns and Re-commerce, you will be a part of the Science and Analytics team collaborating with a group of Analysts, Economists, PMs 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 build complex data solutions that integrate with cross-organizational systems, enabling our team to scale and build self-serve BI tools. You will partner closely with analysts and economists in the pursuit of investigative data. 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- Recognize and adopt best practices in reporting and analysis: data integrity, design, analysis, validation, and documentation.
- 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.
- 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.

- 10+ years of professional or military experience
- 5+ years of SQL experience
- Experience programming to extract, transform and clean large (multi-TB) data sets
- Experience with theory and practice of design of experiments and statistical analysis of results
- Experience with AWS technologies
- Experience in scripting for automation (e.g. Python) and advanced SQL skills.
- Experience with theory and practice of information retrieval, data science, machine learning and data mining