Business Intelligence Engineer, NCRC Science and Analytics_

Bellevue

Description

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

Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit mazon.jobs/en/disability/us.

Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $89,600/year in our lowest geographic market up to $185,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit boutamazon.com/workplace/employee-benefits. This position will remain posted until filled. Applicants should apply via our internal or external career site.