Job Information
Amazon Business Intelligence Engineer II, Sourcing Performance Operations in Heredia, Costa Rica
Description
Have you ever ordered a product on Amazon and when that box with the smile arrived, wondered how it got to you so fast? Wondered where it came from and how much it cost Amazon? If so, the Amazon Global Supply Chain Optimization Technologies organization is for you.
Watch this video to learn more about our organization, SCOT: http://bit.ly/amazon-scot
Strategic Sourcing Systems (OSS) at Amazon is seeking a Business Intelligence Engineer (BIE) to join our team. As a BIE in this role, you will be a key contributor to enhancing the Inbound efficiency and accurate predictions of our supply chain sourcing inbound operations through business intelligence. Our current focus is on improving overall visibility that Amazon has into incoming inbound freight through improving signal quality as well as signal aggregation. This allows us to orchestrate inbound freight through the supply chain, and improve overall inbound lead times. You will collaborate with cross-functional teams to drive data-driven insights that optimize inbound signals, scheduling, and overall supply chain performance.
Key job responsibilities
Design, develop, and maintain complex data models and ETL pipelines to support operations and a diverse portfolio of business intelligence products, tools, and services
Create and optimize SQL queries for large-scale data analysis, diving deep into data to analyze root causes and implement simple, long-term solutions
Build and maintain interactive dashboards and visualizations that support business decisions and strategic initiatives across Ops teams
Partner with business stakeholders and product/tech teams to understand requirements, identify opportunities for innovation and improvement, and translate them into technical solutions
Conduct in-depth analyses and create comprehensive reports aligned with S-Team and OLT goals to drive company-wide success
Implement data quality controls and monitoring systems to ensure data integrity and reliability at scale
Develop automated reporting solutions and self-service analytics capabilities, staying current with trends and best practices in business intelligence and data analytics
Collaborate with data engineering and product/tech teams to optimize data architecture and performance within a highly collaborative, fast-paced environment
Mentor team members and share knowledge to foster a culture of continuous learning within the organization
About the team
The Optimal Sourcing Systems (OSS) team at Amazon is at the forefront of revolutionizing global supply chain management. We are responsible for developing and implementing cutting-edge algorithmic solutions and data platforms that drive Amazon's sourcing decisions worldwide. Our mission is to optimize the entire procurement process, from vendor selection to inventory placement, ensuring the most efficient and cost-effective supply chain operations. We tackle complex challenges that directly impact Amazon's bottom line and customer satisfaction by leveraging advanced analytics, machine learning, and big data technologies to make data-driven decisions that optimize costs, improve delivery times, and enhance product availability across millions of items.
Basic Qualifications
3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
Experience with data modeling, warehousing and building ETL pipelines
Experience with data visualization using Tableau, Quicksight, or similar tools
Experience writing complex SQL queries
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
Preferred Qualifications
Master's degree or above in BI, finance, engineering, statistics, computer science, mathematics or equivalent quantitative field
Knowledge of Microsoft Excel at an advanced level, including: pivot tables, macros, index/match, vlookup, VBA, data links, etc.
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 developing and presenting recommendations of new metrics allowing better understanding of the performance of the business
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.