Business Intelligence Engineer II, AWF Exports Visibility

Amazon Worldwide Fulfillment (AWF) supports Amazon’s strategic vision of bringing worldwide cross-border product selection at the lowest price to our customers and helping sellers and vendors (manufacturers, distributors and brand owners) navigate international trade and logistics. We design and build products and programs with a focus on customer, seller, and vendor experience, and global scalability.

Key job responsibilities
1. Write high quality optimized SQL to retrieve and analyze data from relational databases (ex. Redshift)
2. Collaborate with other Business Intelligence teams to design and implement ETL data pipelines for extracting and analyzing billions of records from multiple databases.
3. Work closely with Data Engineers and business users to design clean and scalable data sources required for analytics and reporting.
4. Work closely with data scientists and product management to drive data-driven improvements to science artifacts
5. Create user–friendly, repeatable reporting solutions to minimize ad hoc customer requests
6. Define and develop business-critical metrics, reports, key performance indicators, and financials across all forecasting products that are consumable by a wide range of functions and levels.

A day in the life
In a normal day, the Exports Visibility BIE will work close with stakeholders to define metrics, validate data, build consensus and document the definitions. They will work building dashboards, AI automation tools, custom ad-hoc queries and aligning expectations across multiple teams.

About the team
AWF works directly with logistics cross-border carriers and partner with several stakeholder teams to constantly improve the international delivery experience. In AWF, the Exports Visibility team is seeking a highly skilled and motivated Business Intelligence Engineer to join our team in Bellevue. GM Exports is growing rapidly in scope, scale and complexity - driving ever growing data needs to support critical business decisions. Our ideal candidate is someone who is always learning as the business grows and as relevant technologies continue to evolve. If you enjoy innovating, thinking big and want to contribute directly to the success of an industry changing business, you may be a prime candidate for this position.

Basic Qualifications

- 5+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
- 3+ years of SQL, ETL or Oracle experience
- 3+ years of processing large, multi-dimensional datasets from multiple sources experience
- 3+ years of performing statistical analysis experience
- 3+ years of developing automated reporting experience
- 3+ years of in the job offered or a related occupation experience
- Bachelor's degree or foreign equivalent in Computer Science, Engineering, Mathematics, Statistics, Economics, or a related field
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Experience with data modeling, warehousing and building ETL pipelines
- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling

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
- Experience creating processes and improving tools that have measurably improved productivity, quality, or advertiser experience
- Experience in identifying, leading, and executing opportunities to improve, automate, standardize or simplify finance or business tools and processes, or experience in creating process improvements with automation and analysis

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.

The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon also offers comprehensive benefits including health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage), 401(k) matching, paid time off, and parental leave. Learn more about our benefits at https://amazon.jobs/en/benefits.

USA, WA, Bellevue - 99,500.00 - 160,000.00 USD annually