Business Intelligence Engineer II, AWF Exports Visibility

Amazon; Factoria (WA); On-site; USD 100,000 - 160,000; Full time

Benefits offered by this job

Sign-on bonus

Restricted stock units (RSUs)

Health insurance

401(k) matching

Paid time off

Job summary

Amazon seeks a skilled Business Intelligence Engineer II for AWF Exports Visibility in Bellevue. You will write optimized SQL, build scalable data pipelines, and collaborate with data scientists and product teams to improve forecasting metrics and dashboards.

You will define business metrics, develop reporting solutions, and deliver insights across cross-functional teams, leveraging Tableau/Quicksight and Python for data processing.

Qualifications

• 5+ years analyzing and interpreting data with Redshift, Oracle, NoSQL etc.
• 3+ years SQL, ETL or Oracle experience
• 3+ years processing large, multi-dimensional datasets
• 3+ years performing statistical analysis
• 3+ years developing automated reporting
• 3+ years in the job offered or related occupation
• Bachelor’s degree in Computer Science, Engineering, Mathematics, Statistics, Economics, or related field
• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience with data modeling, warehousing and ETL pipelines
• Experience using SQL to pull data and Python for data processing

Responsibilities

• Write high quality optimized SQL to retrieve and analyze data from relational databases (e.g., Redshift)
• Collaborate with BI teams to design and implement ETL data pipelines for billions of records
• Work with Data Engineers and business users to design clean data sources for analytics
• Partner with data scientists and product management to drive data-driven improvements
• Create user-friendly, repeatable reporting solutions to minimize ad hoc requests
• Define and develop business-critical metrics, reports, KPIs, and financials across forecasting products

Skills

SQL

Data analysis

Tableau

Quicksight

Python

ETL

Redshift

Oracle

Data modeling

Data warehousing

Education

Bachelor's degree in Computer Science, Engineering, Mathematics, Statistics, Economics or related field

Tools

Tableau

Quicksight

Python

SQL

ETL tools

Redshift

Oracle

Job description

Business Intelligence Engineer II, AWF Exports Visibility

Job ID: 10532823 | Amazon.com Services LLC

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

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