Amazon Business Intelligence Engineer Key 

United States, Texas, Austin 

395958940

Key job responsibilities
- Design, implement, and support a platform providing ad hoc access to large datasets.- Manipulate/mine data from database tables (ex. Redshift, MySQL, Oracle) using SQL and ETL- Manipulate/mine data from log files by writing scripts (ex. PERL, Python, UNIX)- Develop analytical tools: deep-dive tools, UIs, metrics, and dashboard- Work with cross functional stakeholders in defining the source of truth and obsessively making sure the data fidelity is high.- Effectively communicate (written and verbal) solutions and methodologies to senior leadership.- Complete ad hoc data retrieval and analysis.- Monitor existing metrics, develop and propose new metrics, and identify new, actionable risk signals.
A day in the life
- Design, implement, and support a platform providing ad hoc access to large datasets.- Manipulate/mine data from database tables (ex. Redshift, MySQL, Oracle) using SQL and ETL- Manipulate/mine data from log files by writing scripts (ex. PERL, Python, UNIX)- Develop analytical tools: deep-dive tools, UIs, metrics, and dashboard- Work with cross functional stakeholders in defining the source of truth and obsessively making sure the data fidelity is high.- Effectively communicate (written and verbal) solutions and methodologies to senior leadership.- Complete ad hoc data retrieval and analysis.- Monitor existing metrics, develop and propose new metrics, and identify new, actionable risk signals.

- 3+ 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