Business Intelligence Engineer II, AWF Exports Visibility

Amazon Worldwide Fulfillment (AWF) supports Amazons 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 userfriendly 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 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.

- 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
- Bachelors 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

- 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 for more information. If the country/region youre applying in isnt 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 WA Bellevue - 99500.00 - 160000.00 USD annually