Business Intelligence Engineer, Intermodal, Supply Chain
Bellevue, WA - USA
Job Summary
Amazon Transportation is expanding intermodal into new geographies scaling Canada and growing Domestic First Mile. We are looking for a Business Intelligence Engineer to be the single threaded owner and thought leader for analytics planning optimization and automation across all three. The savings at stake exceed $100MM and the analysis you produce gets reviewed at the senior business and Finance level.
Our team owns long-term planning network design and the analytical frameworks that set the outlook for intermodal operations. All three programs this role supports are foundational to growing Amazons rail footprint and all three are scaling now. Geography expansion opens new lanes and regions and needs the sizing models to decide which ones to take. Canada planning is moving past pilot where analysis that works today has to become a planning process that holds at several times the volume. Domestic First Mile is running and growing and needs the right systems and measurement to scale without adding a person for every increment.
We are looking for a builder. Strong technically comfortable in ambiguity and more interested in automating a recurring analysis than running it. If you want your models to be what defines how these programs scale this is a good fit.
Key job responsibilities
Own analytics and planning optimization end to end across geography expansion Canada and Domestic First Mile from framing the question through building the models that answer it to landing the decision it drives.
Build the sizing and evaluation models that determine which geographies and lanes the Amazon rail network can take and keep the models honest by tracking realized benefit against the original case.
Own the product roadmap for the analytics and planning tooling setting direction with Technology and Operations Research teams rather than handing requirements to them and using rapid prototyping to prove an approach before it becomes a supported product.
Build the planning process and systems that let Canada hold at several times todays volume and Domestic First Mile keep scaling replacing manual analysis with automated inputs refresh and exception handling.
Find the optimization opportunities nobody has asked for yet size them and make the case for going after them.
Set the analytical direction for senior business and Finance leadership with reasoning that holds up under scrutiny and hold the bar on data integrity validation and documentation so the models stay trusted and maintainable.
- 3 years of analyzing and interpreting data with Redshift Oracle NoSQL etc. experience
- 1 years of SQL ETL or Oracle experience
- 1 years of processing large multi-dimensional datasets from multiple sources experience
- 1 years of performing statistical analysis experience
- 1 years of developing automated reporting experience
- 3 years of in the job offered or a related occupation experience
- 1 years of using SQL ETL (Extract Transform Load) or Oracle 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 in Statistical Analysis packages such as R SAS and Matlab
- 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
- Usage of generative AI tools to enhance workflow efficiency with a willingness to learn effective prompting and evaluation practices
- Ability to recognize opportunities where generative AI could enhance products workflows or customer experiences
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
Required Experience:
IC
About Company
Free shipping on millions of items. Get the best of Shopping and Entertainment with Prime. Enjoy low prices and great deals on the largest selection of everyday essentials and other products, including fashion, home, beauty, electronics, Alexa Devices, sporting goods, toys, automotive ... View more