Business Intelligence Engineer II, SCOT-FO, TVP

Amazon.com Services LLC•4h ago

United StatesOnsiteFull-timeMid Level3+ yrs exp

H-1B verified · 2310 LCAs

Apply now

Top focus

Business AnalystHr Business Partner

The Amazon Supply Chain Optimization Technologies (SCOT) team works on some of the world's most complex supply chain challenges, at Amazon scale. We understand inventory availability for the millions of items on Amazon, compute accurate delivery expectations for customer orders
monitor fulfillment network changes to inform delivery updates and optimizations. When customers place orders, our systems utilize real-time, large-scale optimization techniques to optimally select shipping sources and consolidate multiple orders. This enables us to ensure customers receive their shipments within the promised timeframe, in an efficient manner. Fulfillment Optimization (FO) owns products and services that plan and execute First Party (1P) and 3P fulfillment resources for the outbound fulfillment network WW. This includes designing network topology, coordinating resource planning for inventory, labor, planes and trucks
utilizing these resources optimally by being aware of the network’s true capacity, constraints
capabilities. We provide fast, accurate and optimized delivery promises, identify the optimal fulfillment plans
will orchestrate XXB shipments in 2025 to efficiently leverage outbound fulfillment capabilities. The team is composed of scientists, Business Intelligence Engineers (BIE), Software Engineers
Researchers who lead the industry in the development of innovative algorithms and strategies to maximize the long term effectiveness of Amazon’s business. The team is seeking an exemplary Business Intelligence Engineer (BIE) with broad technical skills to build analytic and reporting capabilities that enable optimization of delivery promises for our millions of customers worldwide. The ideal candidate is a highly analytical, critical thinker with advanced problem solving, data mining
software development skills. They will enjoy working with world-class product managers, economists, research scientists, data engineers
software developers to drive decisions across Amazon's retail and operations teams. Successful members of this team are customer obsessed, flexible
collaborative team players who enjoying working across functions and organizations to solve problems and get results. They ask hard questions and build scalable solutions that provide critical business insight necessary to influence decision making across retail and operations teams. They find timely answers buried in large data sets and complex systems, identify root causes, get their hands dirty building data systems and sharing insight. To help describe some of our challenges, we created a short video about Supply Chain Optimization at Amazon - http://bit.ly/amazon-scot Key job responsibilities - Collaborate with software development teams to implement analytics systems and data structures to support large-scale data analysis and delivery of machine learning and econometric models - Define, develop and maintain critical business and operational reports reviewed on a weekly, monthly, quarterly
annual basis - Analyze historical data to identify trends and support decision making, including written and verbal presentation of results and recommendations - Mine and manipulate data from database tables, simulation results
log files - Identify data needs and drive data quality improvement projects - Understand the broad range of Amazon's data resources
when - Provide thought leadership on data mining and analysis A day in the life - Collaborate with the Engineering and Science teams to define new product features, construct data pipelines
test new functionalities - Learn about new Amazon technologies and create proposals to adapt to those technologies - Conduct deep dives into anomalies and generate insights for leadership and product management - Use customers inputs to define new data requirements - Explain plan-over-plan differences or discrepancies between expected and actual performance - Maintain dashboards and reporting
address any data quality issues that arise Amazon offers a full range of benefits that support you and eligible family members, including domestic partners and their children. Benefits can vary by location, the number of regularly scheduled hours you work, length of employment
job status such as seasonal or temporary employment. The benefits that generally apply to regular, full-time employees include: - Medical, Dental
Vision Coverage - Maternity and Parental Leave Options - Paid Time Off (PTO) - 401(k) Plan If you are not sure that every qualification on the list above describes you exactly, we'd still love to hear from you! At Amazon, we value people with unique backgrounds, experiences
skillsets. If you’re passionate about this role and want to make an impact on a global scale, please apply! About the team As the Fulfillment Network Planning team, we leverage big data to identify key patterns, understand root causes
build models to fix the most impactful problems. This role is challenging yet rewarding, requiring innovative thinking, a desire to learn
the skills to develop advanced solutions that continuously improve the customer delivery experience.
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

RedshiftOracleNoSQLSQLETLTableauQuicksightdata modelingdata warehousingPythonRSASMatlabAWSEC2