Business Intelligence Engineer, Search Capacity

DESCRIPTION

The Amazon Search team creates powerful, customer-focused search solutions and technologies. Whenever a customer visits an Amazon site worldwide and types in a query or browses through product categories, Amazon Search service go to work. We design, develop, and deploy high performance, fault-tolerant, distributed search systems used by millions of Amazon customers every day.
As a Business Intelligence Engineer in the Search Capacity team, you will:

• Scale the Amazon Search service by working closely with service owners in engineering and operations to understand the service in depth and drive optimal scaling and capacity planning.
• Identify and track key performance metrics around efficiency and costs.
• Manage planning, ordering, and budgeting for hardware and other computational resources.
• Develop and improve tools for automating the foregoing responsibilities wherever possible.
• Analyze resource utilization and performance test data to identify variables impacting performance and scalability. Develop models for required hardware resources to meet current and future SLAs.

BASIC QUALIFICATIONS

• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience with data modeling, warehousing and building ETL pipelines
• Experience writing complex SQL queries
• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
• Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field
• Experience with forecasting and statistical analysis
• 3 years industry experience in one of the following areas: data engineering, business intelligence, or business analytics.

PREFERRED QUALIFICATIONS

• Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift
• Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business
• Proficient in leveraging Python or equivalent language to manipulate data and set up automated processes as per business requirements