Business Intelligence Engineer, ORBIT Demand and Capacity Planning BI
Amazon.com Services LLC•7h ago
United StatesOnsite$99.5K–$160KFull-timeMid Level3+ yrs exp
H-1B verified · 2310 LCAs
Top focus
Business AnalystHr Business PartnerDemand Planner
- Have you ever ordered a product on Amazon and when that box with the smile arrived you wondered how it got to you so fast? Have you wondered where it came from and how much it cost Amazon to deliver it to you? If so, the WW Amazon Logistics, Last Mile team is for you. We manage the delivery of tens of millions of products every week to Amazon’s customers, achieving on-time delivery in a cost-effective manner to deliver a smile for our customers. Amazon Logistics is looking for a customer focused, analytically and technically skilled Business Intelligence Engineer to drive effective performance measurement and management, innovation and execution in last mile delivery. This position will be responsible for leading a BIE team building out analysis and visualization tools and processes’ to support our growing Amazon Logistics business. The successful candidate will be able to effectively retrieve, integrate, visualize and present critical data to improve the efficiency of the package delivery network
- enable efficient management of a large global logistics system. This individual will work with technical and business teams to optimize planning, execution, process improvement and track progress against goals. This role requires an individual with excellent analytical abilities, business acumen and comfort with technical teams and systems. The successful candidate will be a self-starter comfortable with ambiguity, with strong attention to detail
- enjoy working with large scale of data. Key job responsibilities Partner with internal stakeholders across multiple teams, gathering requirements and delivering end to end solutions Partner with Data Engineering and Software Development Engineers to prioritize and define AMZL data and BI development needs Work with in-house scientists, global supply chain, transportation and logistics teams to identify new BI capabilities and projects Conduct deep dive investigations into operations execution and business problems, identify opportunities
- lead or support implementation (role varies by opportunity) Analyze and visualize large scale geo-spatial logistics and transaction data to articulate user behavior or delivery process problems
- output solid analysis report with recommendation Serve as liaison between the WW Planning and Analytics team and the operations business teams to achieve the goal of providing actionable insights into current delivery performance
- ad hoc investigations into future improvements or innovations. This will require data gathering and manipulation, synthesis and modeling, problem solving
- communication of insights and recommendations Develop queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting About the team The AMZL ORBIT (Operations Reporting, Business Intelligence
- Technology) team works as an integral part of AMZL worldwide to ensure that its business intelligence and analytics needs are met. By providing information, insight
- decision support, we strive to enable success of all parts of AMZL. Our stakeholder set includes senior management, station operations, DSP management, Flex management, long-term planning, Ops technology (Voice of the Delivery Station, Voice of the Customer), network planning
- pretty much every BI and Ops teams in AMZL. The BI team maintains and improves metric reporting and AMZL's content in PerfectMile. This team also support publication of WBR decks across NA, EU and JP. We also support a limited set of reports in Tableau and QuickSight dedicated for analytical purposes.
- 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 - Experience with data visualization using Tableau, Quicksight
- 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
- Redshift - Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability
- 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
- 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
- parental leave. Learn more about our benefits at https://amazon.jobs/en/benefits . USA, TX, Austin - 99,500.00 - 160,000.00 USD annually
Required skills
SQLETLTableauQuicksightPythonAWSRedshiftOracleNoSQLRSASMatlab