Business Intelligence Engineer, NCRC Science and Analytics

The NCRC (Net Cost of Refunds and Concessions) team within Returns & Recommerce focuses on ways we can preserve and create customer value while increasing the velocity of Amazon's cost flywheel.

We are constantly innovating to create long-term value at Amazon by investing in the future and focusing on the planet, not just on the bottom line.

WW R&R includes business, product, program, operational, , and software engineering teams, who together manage the lifecycle of returned and damaged products.

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.

A successful BIE will be highly collaborative and organized, capable of prioritizing multiple deliverables and effectively communicate progress and blockers.

You should feel comfortable working across multiple -sources, and be capable of participating in and understanding how multiple systems communicate information to one-another.

We are a new team at Amazon and this is a great opportunity to be on the leading edge. Come join us and innovate with the Amazon NCRC team!

Key job responsibilities

Owning the design, development, and maintenance of scalable solutions for ongoing metrics, reports, analyses, dashboards, etc.

to support analytical and business needs.

• Translate basic business problem statements into analysis requirements.
• Use analytical and statistical rigor to answer business questions and drive business decisions.
• Find and create ways to measure the customer experience to drive business outcomes.
• 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.

BASIC QUALIFICATIONS

• 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

PREFERRED QUALIFICATIONS

• Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift
• Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets
30+ days ago