The Amazon ARTS (APEX-RoW Technology Solutions) team is looking for a Business Intelligence Engineer to optimize in one of the world's largest and most complex data warehouse environments. You are expected being passionate about working with huge database and someone who loves to bring datasets together to create dashboards and business reports. You are required to have deep expertise in creation and management of datasets and optimization of database.

You should be expert at implementing and operating stable, scalable data flow solutions from production systems into end-user facing applications/reports. You are required to have excellent business and communication skills to be able to work with business stakeholders to develop business report/dashboard and to support building data pipeline. You will own customer relationship about data and execute tasks that are manifestations of such ownership, like ensuring high data availability, low latency, documenting data details and transformations and handling user notifications and training.

This role offers an opportunity to make a significant impact on our organization's data infrastructure while working with new technologies and collaborating with diverse teams across RoW (the rest of the world excl. NA and EU) countries.

Key job responsibilities
The role is responsible to drive large cross team programs with limited guide from manager: 1) optimize user’s data pipeline and SQL and database infrastructure across RoW; 2) help business stakeholders to provide data pipeline solutions with Amazon/ARTS internal tech products and AWS services (e.g. Redshift, SageMaker, EMR, ETL tools, data lake); 3) develop scripts for maintenance automation; 4) execute the tech implementation with a clear milestone planning and lead it to smooth launch; 5) help business stakeholders ramp up with team internal and Amazon tech products (e.g., Redshift Cluster, ETL tools, query performance)

A day in the life
An average day may look like:

Attend daily standup to give status updates
Monitor, maintain and optimize the team data infra health and performance
Develop script to automate maintenance of the team data infra
Learn about a new business intelligence technology and AWS services

About the team
The Amazon ARTS (APEX-RoW Technology Solutions) team is responsible for creating core analytics tech capabilities and data engineering services for RoW (the rest of the world excl. NA and EU) countries. It comprises of platforms development, research science, software development and data engineering. ARTS develops scalable analytics applications and research modeling to optimize operation processes. The team standardizes and optimizes data sources and visualization efforts across geographies, builds up and maintains the online BI services and data mart.
At ARTS, data engineers, data scientists, business intelligence engineers and product managers use rigorous quantitative approaches to ensure that we target to provide high quality data tech products to our customers around the world, including India, Japan, Australia, Brazil, Mexico, Singapore, Turkey and MENA.

Basic Qualifications

- 5+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
- 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
- Speak, write, and read fluently in Japanese at a business level or above (N1+)
- Experience leading engineering discussions around technology decisions and strategy related to a product

Preferred Qualifications

- Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets
- Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift
- Speak, write, and read fluently in English

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.