Amazon Business Intelligence Engineer Analytics & Data Management 

United States, Washington, Seattle 

143841645

The Advertising Analytics & Data Management team is looking for a BI Engineer who has strong ownership, outstanding business acumen, and excellent analytical abilities to help build analytics and reporting solutions to support various Ad products. In this role, you will partner with stakeholders across product and engineering teams to understand business requirements, conduct analyses, automate reports, provide documentation and data curation, and build out self-serve analytics solutions over PB-scale data lake.Key job responsibilities
- Translate basic business problem statements into analysis requirements.
- Develop queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting.
- Write queries and output efficiently, and have in-depth knowledge of the data available in area of expertise. Pull the data needed with standard query syntax; periodically identify more advanced methods of query optimization. Convert data to make it analysis-ready.
- Recognize and adopt best practices in reporting and analysis: data integrity, design, analysis, validation, and documentation.
- Troubleshoot operational data-quality issues.
- Review and audit existing ETL jobs and queries.
- Recommending improvements to back-end data sources for increased accuracy and simplicity.

- 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